read_query
Execute a read-only SQL query with row, time, and byte limits to retrieve CSV results, controlling context usage.
Instructions
Run one read-only SQL statement and get CSV back: a header row, data rows, then a '# N rows' trailer that says whether the result was truncated. Time-limited and capped in rows and bytes. Select only the columns you need and keep limit small: results cost context.
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": {
"query": "<query>"
},
"name": "read_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Rows to return, 1 to 1000. | |
| query | Yes | One SELECT statement (WITH ... SELECT, EXPLAIN and PRAGMA table_info(x) also work). |