run_query
Executes read-only SQL SELECT or WITH queries against a SQLite database and returns matching rows, with a configurable limit and truncation flag for large result sets.
Instructions
Run one read-only SQL query (SQLite dialect) and return the rows.
Only SELECT and WITH ... SELECT statements are accepted. At most limit
rows are returned (1 to 1000); truncated is true when more rows
matched, in which case narrow the query or aggregate instead.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| limit | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| columns | Yes | ||
| row_count | Yes | ||
| truncated | Yes |