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
Install
npx skills add ratacat/claude-skills --skill performance-oraclegit 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-oraclePersonal 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
Details
- Skill name
performance-oracle- Repository
- ratacat/claude-skills
- 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
59ratacat/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 Installer
59ratacat/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).
Agent Browser
59ratacat/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".
Plan Review
59ratacat/claude-skills
Have multiple specialized agents review a plan in parallel
Pattern Recognition Specialist
59ratacat/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
Spec Flow Analyzer
59ratacat/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
Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.