search_rows
Find records in any dataset using exact filters or typo-tolerant fuzzy search, with sorting and pagination for precise retrieval.
Instructions
Search rows with exact filters, or typo-tolerant fuzzy matching, with sorting and pagination.
Two search modes:
Exact: pass conditions built from {column, op, value}. Ops: eq, ne, gt, gte, lt, lte, contains, in, between, is_empty, is_not_empty. Combine conditions to narrow further (AND).
Fuzzy: pass fuzzy=true plus a query string to match string/text columns tolerantly against typos and misspellings ("Rahual" finds "Rahul Sharma"). Results are ordered by similarity and carry an _score. Narrow with fuzzy_columns to search only specific text columns.
Results are always paginated: page with next_offset instead of raising the limit, and request only the columns you need via columns.
Args: dataset: Exact dataset name, e.g. "Candidates". conditions: Exact-mode filters, e.g. [{"column": "stage", "op": "eq", "value": "Applied"}]. fuzzy: Set true for typo-tolerant matching (requires query). query: Text to fuzzy-match, e.g. "Rahual". fuzzy_columns: Optional text columns to fuzzy-match against (default: all text columns). fuzzy_threshold: Minimum similarity score 1-100 (default 80). sort_by: Column to sort by (exact mode). sort_order: "asc" (default) or "desc". limit: Page size 1-100 (default 20). offset: Rows to skip for pagination (default 0). columns: Column projection, e.g. ["name", "stage"]; id is always included.
Returns: {"ok": true, "dataset", "rows": [{"id", ...columns, "_score"?}], "total": , "count": , "next_offset": }.
Example: search_rows(dataset="Candidates", conditions=[ {"column": "applied_on", "op": "between", "value": ["2026-08-01", "2026-08-31"]}, {"column": "stage", "op": "ne", "value": "Rejected"} ], sort_by="applied_on", sort_order="desc", columns=["name", "stage"]) search_rows(dataset="Candidates", fuzzy=true, query="Rahual", fuzzy_columns=["name"])
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fuzzy | No | ||
| limit | No | ||
| query | No | ||
| offset | No | ||
| columns | No | ||
| dataset | Yes | ||
| sort_by | No | ||
| conditions | No | ||
| sort_order | No | asc | |
| fuzzy_columns | No | ||
| fuzzy_threshold | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||