Database Optimization

Use this skill when improving query performance, schema layout, indexing, or database-heavy code paths.

Priorities

1. Correctness
2. Measured bottlenecks
3. Query and index simplicity
4. Write/read tradeoff awareness
5. Operational safety

Core Rules

1. Measure before tuning

• Start with the real slow query, workload, or access pattern.
• Use the database's plan/explain tooling before changing indexes or schema.
• Do not optimize based on intuition alone.