Run Read-Only SQL
analytics_run_queryRun a read-only SQL SELECT query with pagination to safely explore and analyze SQLite data.
Instructions
Run a guarded, read-only SQL SELECT query with pagination.
The query is executed over a read-only connection protected by a SQLite
authorizer, and is validated to be a single SELECT/WITH statement, so it
cannot modify data. Results are paginated via limit/offset.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | A single read-only SQL statement. Must start with SELECT or WITH. Writes and multiple statements are rejected. | |
| limit | No | Maximum rows to return (1-500). | |
| offset | No | Rows to skip, for pagination. | |
| response_format | No | ``markdown`` (default) or ``json``. | markdown |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |