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

  1. Pull the slow-query log; explain the costliest.
  2. Check index usage, bloat, vacuum/statistics health.
  3. Review connection/pool behavior and locks.
  4. Quantify: query latency percentiles, throughput, contention.
  5. Identify capacity limits: disk, memory, connections.
  6. Prioritize fixes by impact/effort.
  7. Verify improvements before/after.
Installs
1
First Seen
Oct 22, 2026
Security Audits