performance-profiler

N+1 queries occur when a loop executes separate database queries instead of fetching related data in one request. This Skill detects N+1 patterns in your code and queries, then recommends eager loading or batch fetching to consolidate requests into a single operation.

Performance bottlenecks include N+1 queries, inefficient O(n²) loops, memory leaks, and blocking I/O operations. This Skill analyzes code and profiling data to detect these anti-patterns and suggests targeted fixes like indexing, memoization, and pagination.

Memory leaks occur when objects remain in memory unnecessarily, degrading performance over time. This Skill examines profiling sessions and code to identify leak sources, then recommends fixes such as proper cleanup, reference management, and garbage collection tuning.

Yes. This Skill applies to backend and frontend performance optimization, detecting inefficiencies in both server-side queries and client-side logic, then recommending context-specific solutions like code splitting, lazy loading, and algorithmic improvements.

After identifying bottlenecks, this Skill suggests profiling tools and measurement methods to validate optimizations. It generates structured performance reports with actionable recommendations tailored to your bottleneck type.

Performance issues discovered in code reviews often stem from inefficient queries, algorithms, or resource management. This Skill analyzes reviewed code to detect N+1 patterns, memory leaks, and blocking operations, providing optimization guidance before deployment.