Semantic (vector) search
infino_semantic_searchSearch by meaning, not exact wording. Embed a query locally, rank rows by vector similarity, and return paraphrases and synonyms with relevance scores.
Instructions
Use when searching for a concept by meaning and the exact wording is unknown — this retrieves paraphrases and synonyms, not just literal matches. Embeds the query with a local model (no API key) and ranks a table's embedding column by vector similarity, each hit with a score. Optional 'filter' restricts the ranking to rows whose keyword column matches a predicate first (a pushdown pre-filter, e.g. semantic search only within rows tagged 'billing'). For exact terms use infino_keyword_search; when the query has both literal terms and an intent use infino_hybrid_search.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| k | No | Maximum results. | |
| query | Yes | Query text; embedded and matched by vector similarity. | |
| table | Yes | Table to search. | |
| column | No | Text column to return with each hit; inferred if omitted. | |
| filter | No | Pre-filter: rank the kNN only among rows whose FTS 'column' matches 'query' (a pushdown pre-filter, not a post-filter on the results). | |
| columns | No | Columns to return with each hit (e.g. an id, path, or line range to cite). Defaults to the text column; '_id' and 'score' are always included. | |
| vectorColumn | No | Vector column to search; inferred if omitted. |