skills.rest
jovermier
jovermierCOMMUNITY
Explore all skills by this author →
Website𝕏@jrovermierGitHub

performance-oracle

Analyze code for performance bottlenecks and N+1 queries across backend and frontend stacks.

1|Updated Jan 12, 2026
Search Tags:#performance#caching#scalability#memory#bottlenecks#analyze#N+1
One-click install
npx skills add https://github.com/jovermier/claude-code-plugins-ip-labs --skill performance-oracle-jovermier
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: performance-oracle
Source: https://github.com/jovermier/claude-code-plugins-ip-labs/tree/main/plugins/dev/agents/review/performance-oracle
Command: npx skills add https://github.com/jovermier/claude-code-plugins-ip-labs --skill performance-oracle-jovermier

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps teams quickly identify where code is underperforming, enabling targeted optimizations that improve response times, scalability, and resource usage.

Core Features & Use Cases

  • Identify performance bottlenecks
  • Find N+1 query problems
  • Detect inefficient algorithms
  • Identify missing indexes
  • Find unnecessary expensive operations
  • Detect memory leaks
  • Identify caching opportunities
  • Analyze time and space complexity

Use cases include pre-release performance reviews, optimizing hot paths in critical services, and guiding refactors where early detection prevents regressions.

Quick Start

Use the performance-oracle skill to analyze a recent code change and produce a structured performance review that highlights bottlenecks and recommended optimizations.

Frequently Asked Questions about performance-oracle

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I find N+1 query problems and performance bottlenecks in my code?▼

To find N+1 query problems and performance bottlenecks, you analyze code using a structured framework that identifies inefficient algorithms, missing indexes, and expensive operations across backend and frontend stacks.

What is the best way to detect memory leaks and analyze space complexity?▼

Detecting memory leaks and analyzing space complexity involves reviewing long-running processes and hot paths to pinpoint resource usage issues, enabling targeted optimizations that improve scalability and response times.

Can I use a structured performance review for pre-release code changes?▼

Yes, you can apply a structured performance review to pre-release code changes, feature rollouts, and critical services to catch algorithmic inefficiencies and identify caching opportunities before regressions reach production.

Does performance analysis work for both frontend and backend stacks?▼

Performance analysis works across both backend and frontend stacks, applying a structured framework to evaluate time complexity, memory usage, and unnecessary expensive operations in diverse codebase environments.

When should I not use an automated code analysis for performance optimization?▼

You should avoid relying solely on automated code analysis when addressing runtime environment-specific bottlenecks that require live profiling, as static analysis focuses on identifying code-level inefficiencies and missing caching opportunities.

Related Skills

Explore More Software Engineering Skills→
jpcaparasjpcaparas
37

old-lint

Inspect source code change diffs for quality issues.

Community
Basic
IbIFACE-TechIbIFACE-Tech

performance-optimization

Optimize API performance, database queries, and caching mechanisms.

Official
Advanced
PaulKinlanPaulKinlan
2

regression-check

Run full test suites and compare results against a baseline to detect regressions.

Community
Intermediate
geoffjaygeoffjay
8

tokio-troubleshooting

Diagnose deadlocks, leaks, and performance issues in Tokio runtimes.

Community
Advanced