mysql_explain

Files (1)

• SKILL.md

SKILL.md (first lines)

# MySQL Explain Skill

Provides MySQL query execution plan analysis:
- **EXPLAIN**: Show query execution plan
- **EXPLAIN ANALYZE**: Show actual execution time and costs (MySQL 8.0+)
- **EXPLAIN FORMAT**: Output in JSON, TREE, or traditional format
- **EXPLAIN PARTITIONS**: Show partition information

Shows:
- Access type (ALL, index, range, ref, eq_ref, const, etc.)
- Key used and possible keys
- Rows examined
- Extra info (using filesort, using index, etc.)

Use `builtin_mysql_explain` tool with fields:
- `dsn`: MySQL DSN (e.g., user:pass@tcp(host:3306)/dbname)
- `query`: SQL query to explain
- `type`: Explain type (classic, analyze, format, partitions)
- `format`: Output format for FORMAT type (json, tree, traditional)
- `timeout`: Query timeout in seconds (default: 30)
- `show_execution_time`: Show actual execution time (true/1 or false)

Example:
```
dsn: "root:password@tcp(localhost:3306)/mydb"
query: "SELECT * FROM users WHERE email = 'test@example.com'"
type: "analyze"
```

Note: This tool executes EXPLAIN on the query, not the query itself. Use `show_execution_time` to also run and time the actual query.

From fisker086/AIOps, Apache-2.0.

More from fisker086/AIOps