Optimize SQL queries and indexes
database-optimizerskillsetup L2★9,726
Jeffallan/claude-skills ↗What it does
Analyze and optimize database queries and indexes
Best for
Diagnosing 100+ ms query latency when generic optimization doesn't pinpoint the bottleneck.
Inputs
- · EXPLAIN ANALYZE output
- · slow query logs
- · schema
Outputs
- · query execution plan
- · index recommendations
- · timing metrics
Requires
- · PostgreSQL
- · MySQL
- · pg_stat_statements
Preconditions
- · Access to EXPLAIN ANALYZE
- · production baseline metrics
Failure modes
- · Index overhead on writes
- · incorrect statistics
- · replication lag
Trust signals
- · EXPLAIN BUFFERS analysis pattern
- · before/after validation
- · real execution plan examples