backend-optimizer

What problem does it solve?

This skill eliminates guesswork in backend performance tuning by replacing speculative changes with measured, evidence-based optimizations for slow backend routes, unoptimized database queries, poor schema/index health, and inefficient runtime work.

Core Features & Use Cases

• Report-First Audits: Inventory and rank all backend and database performance candidates by impact, with clear evidence and safe fix paths, stopping before changes unless explicitly approved.
• Bounded Fix Loops: Run structured /goal optimization loops that track state via a candidate ledger and goal-run document, fix only safe high-impact candidates with before/after validation, and resweep until all high-impact surfaces are classified.
• Full Surface Coverage: Covers application-visible queries, schema/index/constraint health, backend runtime paths, connection/lock/migration/observability hygiene, and gates high-risk changes like schema redesigns for human approval.
• Use Case: For a web app with slow user profile load times, the skill can inventory all related database queries, identify missing indexes via EXPLAIN plans, apply the smallest safe index fix, validate latency improvements, and reject speculative caching changes without evidence.

Quick Start

Use the backend-optimizer skill to audit your backend and database performance, get a ranked list of bottlenecks with safe fix recommendations, or run a bounded measured fix loop to safely improve high-impact candidates with verified before/after results.