preen-database-performance

What problem does it solve?

This Skill proactively identifies and resolves database performance bottlenecks, such as N+1 query patterns, inefficient joins, and missing indexes, to reduce latency and query volume.

Core Features & Use Cases

• N+1 Query Detection: Finds queries executed within loops that lead to excessive database calls.
• Join Optimization: Identifies inefficient join operations that can be optimized.
• Index Gap Analysis: Detects missing indexes that slow down query execution.
• Real-DB Regression Testing: Ensures performance improvements are validated against a live database with realistic data.
• Use Case: Improve the loading speed of a user's playlist by optimizing the queries that fetch playlist details and associated tracks.

Quick Start

Run the preen-database-performance skill to find and fix N+1 query patterns in the playlist loading path.