Code Optimization Audit Report

--------|----------------|-------| | 1 | Database & Queries | references/database-queries.md | N+1 queries, SELECT *, missing indexes, ORM misuse, connection pooling | | 2 | Memory & Resources | references/memory-resources.md | Memory leaks, unclosed resources, large allocations, string concat in loops | | 3 | Algorithmic Complexity | references/algorithmic-complexity.md | O(n^2) patterns, unnecessary iterations, wrong data structures for lookups | | 4 | Concurrency & Async | references/concurrency-async.md | Sequential awaits, blocking in async, race conditions, unbounded concurrency | | 5 | Bundle & Dependencies | references/bundle-dependencies.md | Heavy imports, unused deps, duplicate libs, missing lazy loading | | 6 | Dead Code & Redundancy | references/dead-code-redundancy.md | Unused exports, commented code, dead branches, duplicate logic | | 7 | I/O & Network | references/io-network.md | Sequential requests, missing batching, no dedup, missing compression | | 8 | Rendering & UI | references/rendering-ui.md | Re-renders, missing virtualization, layout thrashing, animation perf | | 9 | Data Structures | references/data-structures.md | Wrong structures, unnecessary copies, inefficient serialization | | 10 | Error & Resilience | references/error-resilience.md | Missing timeouts, swallowed errors, no retries, no circuit breakers | | 11 | Caching & Memoization | references/caching-memoization.md | Missing memoization, cache without invalidation, redundant API calls | | 12 | Build & Compilation | references/build-compilation.md | Dev code in prod, missing optimization flags, slow tests, Docker issues | | 13 | Security-Performance | references/security-performance.md | Crypto misuse, missing rate limiting, ReDoS, SQL injection vectors |

Optional agents (spawn if relevant to detected stack):

• Logging & Observability (references/logging-observability.md) — if logging framework detected
• Config & Infrastructure (references/config-infra.md) — if Docker/deployment config detected

Agent Prompt Template

Each agent MUST receive this prompt structure:

You are a {DOMAIN_NAME} optimization specialist. Your job is to find performance
anti-patterns in the codebase at {PROJECT_ROOT}.

CRITICAL RULES:
1. DO NOT read source code files before searching. This avoids anchoring bias.
2. First, read your reference file: {SKILL_DIR}/references/{REFERENCE_FILE}
3. Use Grep and Glob to search for the patterns described in the reference file.
4. Only read 5-10 lines of context around each finding to confirm it's a real issue.
5. Skip patterns that don't match the project's stack: {DETECTED_STACK}

Tech stack detected: {DETECTED_STACK}
Project root: {PROJECT_ROOT}

For each finding, report:
- **File**: path:line_number
- **Pattern**: what anti-pattern was detected