ln-651-query-efficiency-auditor - Audit database query patterns for efficiency
Audits database queries for redundant fetches, N-UPDATE loops, unnecessary resolves, over-fetching, missing bulk operations, and wrong caching scope.
Tags
Updated: 2026-09-21Capabilities
Typical Inputs
What this skill does
- Audit redundant entity fetches
- Detect N-UPDATE or DELETE loops
- Identify unnecessary value resolves
- Detect ORM model over-fetching
- Check missing bulk operations
- Detect wrong caching scope
- Calculate query efficiency score
- Generate markdown audit report
Inputs
- Context store with database configuration
- Audit worker core contract reference
- Two-layer detection methodology reference
- Audit scoring reference
- Audit worker report template
Outputs
- Markdown audit report file
- Audit summary string for coordinator
Requirements
- Read tool permission
- Grep tool permission
- Glob tool permission
- Bash tool permission