query
Execute a read-only SELECT, WITH, or VALUES statement against a SQLite database to inspect data, with write operations blocked and row, size, and time limits applied.
Instructions
Run one read-only SELECT / WITH / VALUES statement. Anything that would write (INSERT, UPDATE, DELETE, CREATE, DROP, ATTACH, VACUUM, PRAGMA assignments, load_extension) is refused. Results stop at max_rows rows and about 200 KB, and the query is interrupted after timeout_seconds. BLOB cells show size plus a hex prefix, and text longer than 200 characters is truncated with its length. Prefer aggregates (COUNT, GROUP BY) over pulling raw rows.
format: markdown (default), csv or json. max_rows: 1-5000. timeout_seconds: 0.1-60.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| path | Yes | ||
| format | No | markdown | |
| max_rows | No | ||
| timeout_seconds | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |