explain_query
Analyze SQL query performance by generating execution plans to identify bottlenecks and optimize database operations.
Instructions
Get the execution plan for a SQL query to analyze performance
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Optional: Database name to use for this query | |
| include_actual_plan | No | Include actual execution statistics (optional, defaults to false) | |
| query | Yes | The SQL query to analyze |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Optional: Database name to use for this query",
"type": "string"
},
"include_actual_plan": {
"description": "Include actual execution statistics (optional, defaults to false)",
"type": "boolean"
},
"query": {
"description": "The SQL query to analyze",
"type": "string"
}
},
"required": [
"query"
],
"type": "object"
}