SQL Query Optimizer

About

Reads SQL queries and EXPLAIN output, identifies bottlenecks (full scans, missing indexes, bad join orders, n+1 patterns), and suggests rewrites or schema changes. Supports PostgreSQL, MySQL, SQLite, and SQL Server. Always explains the reasoning behind each recommendation.

Tags

Skill Instructions Preview

# SQL Optimizer

Diagnose and optimize a SQL query.

## Steps
1. Read the query
2. Read the table schemas (CREATE TABLE statements)
3. Read the EXPLAIN ANALYZE output if provided; otherwise ask for it
4. Identify bottlenecks:
   - Full table scans on large tables
   - Missing or wrong indexes
   - Bad join order
   - SELECT * with large rows
   - N+1 query patterns
   - Lack of LIMIT in pagination
5. Propose:
   - Index changes (with CREATE INDEX statements)
   - Query rewrites
   - Schema changes if appropriate
6. Explain the reasoning for each recommendation

Never drop or modify production data without explicit confirmation.