Search a table's rows
search_tableRanked search over one public table's rows, the same search its dataset page runs: words, prefixes, typos and spelling correction, served from the table's search package. NOT a catalogue search (search_datasets finds datasets) and not SQL. Example: {"table_id": "0f2f...", "query": "blade runner 1982"}. settled defaults to true (a finished query, which may be planned by a model); send settled: false for a fast keystroke answer planned by the parser alone. page_size is 1-100 (default 20). columns is a subset of the table's search display columns (default all of them). Returns {rows: [{row_id, fields}], plan, planner, retrieval, next_cursor, count, package: {generation_id, package_digest}, table_version_id, timings}. For the next page send the same query with the answer's plan and next_cursor. like: a row_id from an answer finds the rows most like that row (more like this; query, when not empty, is a topic beside it), on a table whose search has meaning vectors. mode (first page only): auto (default) lets the planner choose; meaning ranks by meaning alone; image finds rows whose pictures look like the query (posters showing a red sky over a city); emoji searches by the query's emojis. A table whose search cannot run a mode answers invalid_plan. count: true also asks for the exact number of matching rows; count is null when the table cannot count yet. corrected, when present, is the spelling the search used. A table with no ready search answers search_unavailable with a reason: preparing (ask again shortly), not_public (another workspace's private or link-shared table; your own workspace's tables are searchable whatever their visibility) or the package's state. To filter, sort or aggregate, use query_table. Requires an mr_use_ workspace key (Authorization: Bearer) or an OAuth connection, like query_table, and counts against the same allowance. Cite the package generation and digest. Reads past the free sample (the first 500 rows of a table in stored order) count against the workspace's shared free monthly allowance of 100,000 rows and 1,000 queries (the workspace of the key or grant in use) unless it is subscribed. A download counts the rows it contains, plus one query per table. At the limit the tool answers usage_limit_exceeded with the reset time and an upgrade URL.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table_id": "<table_id>",
"query": "<query>"
},
"name": "search_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| like | No | ||
| mode | No | ||
| plan | No | ||
| count | No | ||
| query | Yes | ||
| cursor | No | ||
| columns | No | ||
| settled | No | ||
| table_id | Yes | ||
| page_size | No |