What programming languages does it support?

While the core patterns often target JavaScript/Node.js, the underlying performance principles applied to algorithms, SQL, and resource management are applicable to most modern languages.

Does it provide actual performance benchmarks?

It generates benchmark templates and detailed performance reports based on code analysis, helping you quantify improvements before and after optimization.

Can it detect memory leaks?

Yes, the skill evaluates memory allocation patterns, object reuse, and cleanup logic to identify areas where resources aren't being released properly.

Can this skill help with database optimizations?

Yes, it identifies common issues like N+1 queries, missing indexes, and inefficient SQL execution plans, providing optimized query alternatives and joining strategies.

How does Performance Review detect bottlenecks?

It analyzes code patterns for high-complexity algorithms, frequent I/O operations, and inefficient resource allocation to pinpoint specific lines of code causing performance degradation.

Performance Review

Name: Performance Review
Author: Protagonistss

byProtagonistss

分析と監視

Identifies code performance bottlenecks, evaluates resource efficiency, and provides actionable optimization strategies.

概要

The Performance Review skill provides a comprehensive suite of tools for deep code analysis focused on speed and resource efficiency. It systematically evaluates algorithmic complexity, resource consumption (CPU, memory, I/O), concurrency patterns, and database query execution plans. Whether you are debugging a slow API or optimizing high-throughput data processing, this skill helps identify issues like N+1 queries or O(n²) complexity and provides actionable optimization strategies, benchmarks, and performance reports to ensure your applications meet production-grade performance standards.

主な機能

Database query optimization for SQL execution plans and indexing
Concurrency and thread-safety checks for parallel processing
0 GitHub stars
Resource usage evaluation including CPU, memory, and I/O overhead
Automated performance reporting with benchmarks and KPI metrics
Algorithmic complexity analysis for time and space efficiency

ユースケース

Conducting resource-usage audits to reduce cloud infrastructure costs and memory leaks
Identifying and resolving N+1 query issues in database-driven applications
Optimizing high-latency API endpoints through caching and refactoring

概要

主な機能

Database query optimization for SQL execution plans and indexing
Concurrency and thread-safety checks for parallel processing
0 GitHub stars
Resource usage evaluation including CPU, memory, and I/O overhead
Automated performance reporting with benchmarks and KPI metrics
Algorithmic complexity analysis for time and space efficiency

ユースケース

Conducting resource-usage audits to reduce cloud infrastructure costs and memory leaks
Identifying and resolving N+1 query issues in database-driven applications
Optimizing high-latency API endpoints through caching and refactoring