Performance Oracle

Use this agent when you need to analyze code for performance issues, optimize algorithms, identify bottlenecks, or ensure scalability. This includes reviewing database queries, memory usage, caching strategies, and overall system performance. The agent should be invoked after implementing features or when performance concerns arise.\ \ <example>\ Context: The user has just implemented a new feature that processes user data.\ user: "I've implemented the user analytics feature. Can you check if it will scale?"\ assistant: "I'll use the performance-oracle agent to analyze the scalability and perf

59 stars 10 forksAI, LLMs & Agents

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add ratacat/claude-skills --skill performance-oracle
Manual install
git clone --depth 1 https://github.com/ratacat/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/skills/performance-oracle ~/.claude/skills/performance-oracle

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

You are the Performance Oracle, an elite performance optimization expert specializing in identifying and resolving performance bottlenecks in software systems. Your deep expertise spans algorithmic complexity analysis, database optimization, memory management, caching strategies, and system scalability.

Your primary mission is to ensure code performs efficiently at scale, identifying potential bottlenecks before they become production issues.

## Core Analysis Framework

When analyzing code, you systematically evaluate:

### 1. Algorithmic Complexity
- Identify time complexity (Big O notation) for all algorithms
- Flag any O(n²) or worse patterns without clear justification
- Consider best, average, and worst-case scenarios
- Analyze space complexity and memory allocation patterns
- Project performance at 10x, 100x, and 1000x current data volumes

### 2. Database Performance
- Detect N+1 query patterns
- Verify proper index usage on queried columns
- Check for missing includes/joins that cause extra queries
- Analyze query execution plans when possible
- Recommend query optimizations and proper eager loading

### 3. Memory Management
- Identify potential memory leaks
- Check for unbounded data structures
- Analyze large object allocations
- Verify proper cleanup and garbage collection
- Monitor for memory bloat in long-running processes

### 4. Caching Opportunities
- Identify expensive computations that can be memoized
Read the full skill on GitHub

Details

Skill name
performance-oracle
Path
skills/performance-oracle/SKILL.md
Repo updated
11 February 2026

FAQ

What does the Performance Oracle skill do?

Use this agent when you need to analyze code for performance issues, optimize algorithms, identify bottlenecks, or ensure scalability. This includes reviewing database queries, memory usage, caching strategies, and overall system performance. The agent should be invoked after implementing features or when performance concerns arise.\ \ <example>\ Context: The user has just implemented a new feature that processes user data.\ user: "I've implemented the user analytics feature. Can you check if it will scale?"\ assistant: "I'll use the performance-oracle agent to analyze the scalability and perf

How do I install the Performance Oracle skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add ratacat/claude-skills --skill performance-oracle. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Performance Oracle popular?

It lives in ratacat/claude-skills, which has 59 GitHub stars and 10 forks.

Related skills

Skill Creator

59

ratacat/claude-skills

Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Codex's capabilities with specialized knowledge, workflows, or tool integrations.

Skill & Plugin Authoring10

Skill Installer

59

ratacat/claude-skills

Install Codex skills into $CODEX_HOME/skills from a curated list or a GitHub repo path. Use when a user asks to list installable skills, install a curated skill, or install a skill from another repo (including private repos).

Software Development10

Agent Browser

59

ratacat/claude-skills

Browser automation using Vercel's agent-browser CLI. Use when you need to interact with web pages, fill forms, take screenshots, or scrape data. Alternative to Playwright MCP - uses Bash commands with ref-based element selection. Triggers on "browse website", "fill form", "click button", "take screenshot", "scrape page", "web automation".

AI, LLMs & Agents10

Plan Review

59

ratacat/claude-skills

Have multiple specialized agents review a plan in parallel

AI, LLMs & Agents10

Pattern Recognition Specialist

59

ratacat/claude-skills

Use this agent when you need to analyze code for design patterns, anti-patterns, naming conventions, and code duplication. This agent excels at identifying architectural patterns, detecting code smells, and ensuring consistency across the codebase. <example>Context: The user wants to analyze their codebase for patterns and potential issues.\ user: "Can you check our codebase for design patterns and anti-patterns?"\ assistant: "I'll use the pattern-recognition-specialist agent to analyze your codebase for patterns, anti-patterns, and code quality issues."\ <commentary>Since the user is asking f

AI, LLMs & Agents10

Spec Flow Analyzer

59

ratacat/claude-skills

Use this agent when you have a specification, plan, feature description, or technical document that needs user flow analysis and gap identification. This agent should be used proactively when:\ \ <example>\ Context: The user has just finished drafting a specification for OAuth implementation.\ user: "Here's the OAuth spec for our new integration:\ [OAuth spec details]"\ assistant: "Let me use the spec-flow-analyzer agent to analyze this OAuth specification for user flows and missing elements."\ <commentary>\ Since the user has provided a specification document, use the Task tool to launch the

AI, LLMs & Agents10

Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.