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.
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 | |||