execute_sql
Execute SQL queries on a Datasette database to retrieve and analyze data. Supports pagination, time limits, and custom output shapes.
Instructions
Execute SQL query against a Datasette instance.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| instance | Yes | Name of the Datasette instance (from config) | |
| database | Yes | Database name | |
| sql | Yes | SQL query to execute | |
| shape | No | JSON shape - "arrays", "objects", or "array" (uses Datasette default if not specified) | |
| json_columns | No | List of columns to parse as JSON | |
| trace | No | Include query performance trace | |
| timelimit | No | Query timeout in milliseconds | |
| size | No | Maximum number of results per page (uses Datasette default if not specified) | |
| next_token | No | Pagination token from previous response to get next page |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||