database-performance-auditor
Installation
SKILL.md
Database Performance Auditing
Use this skill when
- Investigating slowness from the DB angle
- Reviewing indexes, queries, and planning
- Capacity and bottleneck analysis
Do not use this skill when
- Schema design
- Application code profiling beyond queries
Instructions
- Pull the slow-query log; explain the costliest.
- Check index usage, bloat, vacuum/statistics health.
- Review connection/pool behavior and locks.
- Quantify: query latency percentiles, throughput, contention.
- Identify capacity limits: disk, memory, connections.
- Prioritize fixes by impact/effort.
- Verify improvements before/after.