query_with_explain
Debug SQL query performance by running SELECT queries with EXPLAIN ANALYZE. Optionally include ANALYZE, BUFFERS, and VERBOSE for deeper insights.
Instructions
Run query with EXPLAIN ANALYZE for performance debugging
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": "query_with_explain"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SELECT query to analyze | |
| verbose | No | Include ANALYZE, BUFFERS, VERBOSE |