Explain SQLite Query Execution Plan
sqlite_explain_queryInspect SQLite query execution plans to see index usage, table scans, and optimization steps before tuning or debugging queries.
Instructions
Run EXPLAIN QUERY PLAN on a query to inspect SQLite index usage, table scans, and optimization steps.
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": "sqlite_explain_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SQL query to explain | |
| db_path | No | Path to SQLite database file |