ln-651-query-efficiency-auditor

What problem does it solve?

This Skill identifies and helps fix inefficient database query patterns that lead to slow performance, increased resource usage, and potential scalability issues.

Core Features & Use Cases

• Redundant Fetch Detection: Finds instances where the same data is fetched multiple times within a call chain.
• Batch Operation Optimization: Detects loops performing individual updates or deletes, suggesting bulk operations.
• Over-fetching Prevention: Identifies when too much data is loaded from the database, recommending selective field loading.
• Use Case: An auditor uses this Skill to scan a codebase, pinpointing specific functions that repeatedly query the same user data, and receives recommendations to refactor these into a single, efficient query.

Quick Start

Run the ln-651-query-efficiency-auditor skill to audit the codebase located at /path/to/your/codebase.