Run a read-only SQL query
run_queryExecute one read-only SQLite SELECT statement to inspect local database data; writes are rejected, ? placeholders handle values, and row/time limits apply.
Instructions
Run ONE read-only SQLite SELECT statement (WITH ... SELECT is fine). Writes, PRAGMA, ATTACH, comments and multiple statements are rejected. Use ? placeholders with the params array instead of pasting values into SQL. Results are capped at a row limit and queries are time-limited.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"sql": "<sql>"
},
"name": "run_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | A single SELECT statement | |
| limit | No | Max rows to return (capped by the server row limit) | |
| params | No | Values for ? placeholders, in order |