performance-reviewer
Installation
SKILL.md
Performance Reviewer
Overview
This skill analyzes code changes for performance regressions and optimization opportunities. It catches common issues like N+1 database queries, unnecessary re-renders in React components, missing database indexes, unoptimized loops, and bundle size increases before they reach production.
Instructions
Analyzing a Diff or PR
- Get the diff:
git diff main...HEADorgit diff <base>...<head> - For each changed file, evaluate against these performance categories:
Database & Queries:
- Look for queries inside loops (N+1 pattern)
- Check for missing
WHEREclauses or full table scans - Identify missing indexes on columns used in
WHERE,JOIN, orORDER BY - Flag
SELECT *when only specific columns are needed - Watch for unbounded queries without
LIMIT