search_table
Search for text across a table's contents, with options to filter by column, enable advanced operators, and paginate results.
Instructions
Full-text search within a table using Datasette's search functionality.
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": {
"instance": "<instance>",
"database": "<database>",
"table": "<table>",
"search_term": "<search_term>"
},
"name": "search_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| instance | Yes | Name of the Datasette instance (from config) | |
| database | Yes | Database name | |
| table | Yes | Table name | |
| search_term | Yes | Text to search for | |
| search_column | No | Search only in this column (optional) | |
| columns | No | List of columns to return (optional, returns all columns if not specified) | |
| raw_mode | No | Enable advanced FTS operators (AND, OR, NOT, NEAR) | |
| shape | No | JSON shape - "arrays", "objects", or "array" (uses Datasette default if not specified) | |
| size | No | Maximum number of results (uses Datasette default if not specified) | |
| json_columns | No | List of columns to parse as JSON | |
| next_token | No | Pagination token from previous response to get next page |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||