ln-651-query-efficiency-auditor

> **Paths:** File paths (`shared/`, `references/`, `../ln-*`) are relative to skills repo root. If not found at CWD, locate this SKILL.md directory and go up one level for repo root. If `shared/` is missing, fetch files via WebFetch from `https://raw.githubusercontent.com/levnikolaevich/claude-code-skills/master/skills/{path}`. # Query Efficiency Auditor (L3 Worker) **Type:** L3 Worker Specialized worker auditing database query patterns for redundancy, inefficiency, and misuse. ## Purpose & Scope - Audit **query efficiency** (Priority: HIGH) - Check redundant fetches, batch operation misuse, caching scope problems - Write structured findings to file with severity, location, effort, recommendations - Calculate compliance score (X/10) for Query Efficiency category ## Inputs **MANDATORY READ:** Load `shared/references/audit_worker_core_contract.md`. Receives `contextStore` with: `tech_stack`, `best_practices`, `db_config` (database type, ORM settings), `codebase_root`, `output_dir`. **Domain-aware:** Supports `domain_mode` + `current_domain`. ## Workflow **MANDATORY READ:** Load `shared/references/two_layer_detection.md` for detection methodology. 1) **Parse context from contextStore** - Extract tech_stack, best_practices, db_config, output_dir - Determine scan_path (same logic as ln-624) 2) **Scan codebase for violations** - All Grep/Glob patterns use `scan_path` - Trace call chains for redundant fetches (requires reading caller + callee) 3) **Collect ...