Hybrid Search Node

H

Data/Database/Search

Searches the Database using both Vector and Full-Text Search

hybrid_search_local_dbdata

Inputs10

Outputs2

Security exposureUnrated

Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

No score metadata has been set for this node yet.

Input Pins

10

Input

Execution

exec_in

Database

Struct

database

Database Connection Reference

SchemaNodeDBConnectionNodeDBConnectionNodeDBConnection1 fields

cache_keystringrequired

Schema enforced

Search Term

String

search

Full Text Search Term

Vector

Float Array

vector

Vector to Search

Fields

String Array

fields

Column names for both vector (first) and FTS search

Default []

SQL Filter

String

filter

Optional SQL filter on the table's columns. Use $name for a value that comes from a wire — `id = $id` mints a `$id` pin, and the value is bound as a literal instead of being pasted into the predicate.

Params

Struct

params

Values for the filter's $placeholders, as an object keyed by placeholder name without the $ (e.g. {"customer_id": 42}). Only needed when the filter itself comes from a wire — a literal filter derives one pin per placeholder instead. Where both supply the same name, the derived pin wins unless it is empty.

Schemaobjectobjectobject0 fields

No named fields in this schema.

Default {}

Re-Rank

Boolean

rerank

Should the items be reranked using RRF?

Default true

Limit

Integer

limit

Limit

Default 10

Offset

Integer

offset

Offset

Default 0

Output Pins

2

Done

Execution

exec_out

Done Searching Database

Values

Struct Array

values

Found Items

Schemaobjectobjectobject0 fields

No named fields in this schema.

Node Info

Internal name

hybrid_search_local_db

Category

Data/Database/Search

Version

2