performance-reviewer
Installation
SKILL.md
Rails Performance Review
Audience: Rails developers reviewing code for performance issues Goal: Identify N+1 queries, missing indexes, memory issues, and scalability bottlenecks
Analysis Framework
Check all areas systematically. See references/patterns.yaml for anti-patterns and fixes.
| Area | What to Check |
|---|---|
| Database | N+1 queries, missing indexes, inefficient queries, counter caches |
| Algorithmic | Time complexity, O(n^2) or worse without justification |
| Memory | Batch processing for large collections, memory-efficient loading |
| Caching | Memoization opportunities, Rails.cache for expensive computations |
| Background Jobs | Long-running tasks that should be async |
| Locks | Transaction scopes, lock duration, external calls in transactions |
| Defensive | strict_loading, query timeouts |