Does it support language-specific performance checks?

Yes, it includes specialized logic for Node.js (event loop blocking, string concatenation) and .NET (boxing/unboxing, LINQ allocations, and async/await patterns).

How does this skill detect N+1 query problems?

The skill analyzes loops that contain database calls (like findOne or query) and identifies patterns where multiple sequential requests can be batched or joined into a single efficient query.

Will it suggest trivial micro-optimizations?

No, the skill is configured to filter out micro-optimizations and theoretical improvements, focusing instead on high-impact architectural and algorithmic changes.

How does the complexity analysis work?

It provides a 'Current vs. Optimized' Big O comparison, explaining at what data scale the inefficiency becomes critical to help developers prioritize fixes.

Performance Code Review

Name: Performance Code Review
Author: JesseNaranjo

byJesseNaranjo

•

Analytics & Monitoring

Identifies and resolves algorithmic inefficiencies, memory leaks, and database bottlenecks to optimize application speed and scalability.

The Performance Code Review skill empowers Claude to conduct deep architectural audits focused on system efficiency. It automatically detects critical performance anti-patterns such as N+1 query loops, memory leaks in Node.js and .NET, and inefficient Big O complexity. By prioritizing 'hot paths' like API controllers and database repositories, the skill provides actionable diff-based fixes and comparative complexity analysis, ensuring your code remains performant as your data scales.

Key Features

01Algorithmic complexity (Big O) analysis and optimization

02Automated N+1 query detection and resolution patterns

03Async/await auditing to eliminate sequential execution bottlenecks

041 GitHub stars

05Memory leak identification for Node.js and .NET environments

06Smart prioritization of high-traffic entry points and data layers

Use Cases

01Pre-production performance audits to identify scaling bottlenecks

02Reducing infrastructure costs by improving resource utilization

03Optimizing slow API endpoints and database-heavy services

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jessenaranjo/ai-setup performance-review

For use in Claude.ai and ChatGPT

Download Skill