sdcorejs-review-performance-nestjs

What problem does it solve?

Identifies performance bottlenecks in a NestJS backend (N+1 queries, missing indexes, slow migrations, oversized payloads, connection pool exhaustion, sync/blocking work, and memory leaks) before they hit production.

Core Features & Use Cases

• N+1 query detection: Counts queries per endpoint and flags list endpoints likely causing N+1 patterns.
• Index audit & hotspot finding: Checks WHERE-filtered columns for missing indexes and surfaces slow queries via pg_stat_statements.
• Production-like perf gate reporting: Produces Critical/Important/Minor findings including measurements and actionable fixes, with query plan expectations for Critical items.

Quick Start

Ask the skill to run a performance audit gate for your NestJS API focusing on N+1, slow queries, indexes, migration safety, pool sizing, payload size, and memory behavior, then return Critical/Important/Minor findings with file and line references.