Preen Database Performance

Proactively reduce database latency and query volume by finding N+1 patterns, join inefficiencies, and missing indexes in query-heavy paths.

When to Run

Run this skill when:

• Preen rotation selects preen-database-performance
• API or feature paths feel slow under realistic data volume
• Review feedback flags N+1 queries or expensive joins
• Query-heavy code changed without a real-database regression test

Discovery Phase

Start by finding likely hotspots and existing real-db tests you can extend: