mydatabase_explain_query
Retrieves MySQL EXPLAIN output to analyze index usage, join types, and row estimates, helping optimize slow or blocked SELECT queries.
Instructions
Returns the MySQL EXPLAIN output for a SELECT query. Use this to understand index usage, join types, and row estimates before rewriting a blocked or slow query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SELECT query to analyze. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | EXPLAIN output rows |