db_explain
Analyze SQL query execution plans to identify optimization opportunities for PostgreSQL, MySQL, and SQLite databases.
Instructions
Get query execution plan for optimization analysis.
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": {
"type": "<type>",
"query": "<query>"
},
"name": "db_explain"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| type | Yes | Database type | |
| query | Yes | SQL query to analyze | |
| connection | No | Connection string | |
| host | No | Database host | |
| port | No | Port number | |
| database | No | Database name | |
| user | No | Username | |
| password | No | Password |