Interpret EXPLAIN / query plans (MySQL, PostgreSQL, or pasted plan text): access types, indexes, and tuning hints.
Scanned 9/12/2026
Install to Claude Code
Skills Directorynpx -y skills add fisker086/AIOps --skill sql_explain --agent claude-codeInstalls into .claude/skills of the current project.
Are you the author of Sql Explain?
Add the live security badge to your README — it updates automatically with every re-scan.
[](https://www.skillsdirectory.com/skills/fisker086-sql-explain)More formats (shields.io, HTML) on the badges page.
---
name: sql-explain
description: Interpret EXPLAIN / query plans (MySQL, PostgreSQL, or pasted plan text): access types, indexes, and tuning hints.
activation_keywords: [sql, explain, query plan, execution plan, slow query, index, postgres, mysql]
execution_mode: server
---
# SQL Explain Skill
Use when the user pastes **EXPLAIN** output or asks how to read a **query plan**.
- **MySQL live analysis**: Prefer the **MySQL Explain** skill (`builtin_mysql_explain` / `mysql_explain`) when you need to run `EXPLAIN` / `EXPLAIN ANALYZE` against a DSN.
- **Any engine (text)**: Use `builtin_sql_explain` to parse pasted plans (MySQL traditional/JSON/TREE, PostgreSQL `EXPLAIN`, etc.) and explain:
- Access type (seq scan vs index, join order hints)
- Whether indexes are used as intended
- “Using filesort”, “Using temporary”, buffer usage (when present)
- Practical next steps (indexes to add/change, query rewrite)
Tool fields:
- `plan`: Pasted EXPLAIN / EXPLAIN ANALYZE / query plan text.
- `engine`: Optional engine hint: `mysql`, `postgres`, or `generic`.
- `query`: Optional original SQL query for additional hints.
If the plan is truncated, ask only for the missing fragment.
Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.
No comments yet. Be the first to comment!
