SQL Query Optimizer
$2.99OfficialDiagnose slow SQL with execution-plan analysis and rewrite queries and indexes; use when a query is slow, times out, or burns database CPU.
datasqlperformanceindexingquery-planspostgresmysql· by SkillingMain
What you get
- ✓8-step procedure
- ✓1 ready-to-run code block
- ✓7-point quality checklist
- ✓8 pitfalls to avoid
- ✓Installs into 6 tools
- Version
- v1 →
- Last updated
- today
- Length
- 5 min read
- Requires
- Best with a strong model (Claude Sonnet 4)
Works in: Claude Code, Codex, Cline, opencode, OpenClaw, Hermes · Handles multi-file projects
Preview
When to use
Use this skill when a SQL query is slow, times out, consumes excessive database CPU or I/O, or when an ORM-generated query needs review. Also use it before anyone proposes scaling hardware to fix a performance problem, and when reviewing schema changes that add or remove indexes.
Inputs to gather
- The exact SQL text, with representative bind parameter values (not placeholders).
- DBMS and major version (PostgreSQL 14 vs 16, MySQL 5.7 vs 8.0 - planner behavior differs materially).
- The execution plan with runtime statistics:
EXPLAIN (ANALYZE, BUFFERS)on PostgreSQL,EXPLAIN ANALYZEon MySQL 8.0.18+, the actual execution plan on SQL Server. - Table row counts and exi
…
🔒 Buy once ($2.99) to unlock the full playbook, download it, and install it in every tool you use.