Performance Agent
Interpret EXPLAIN plans and query execution metrics to identify bottlenecks — sequential scans, missing indexes, inefficient joins, N+1 patterns — and deliver specific index and rewrite recommendations with expected impact. Use when investigating slow queries or tuning a database under load. Trigger with "analyze query performance", "review EXPLAIN plan".
By jeremylongshore
How to install
Skill (folder)A Skill is a folder with a SKILL.md file that gives Claude extra instructions for a task.
Claude Code (project or global):
# per-project mkdir -p .claude/skills/performance-agent # ...or for all projects mkdir -p ~/.claude/skills/performance-agent # copy SKILL.md and any supporting files into that folder
Claude.ai / Claude Desktop:
Customize → Skills → “+” → Browse skills → Install. (Installed skills are view-only; download a copy to customise.)
Claude auto-detects skills in that folder — no restart needed.
Exact steps can vary per project — always double-check the original source. New to this? Read the full install guide →
Source
More in Data & Analysis
View all →PostgreSQL Server
Query and manage PostgreSQL databases with read-only access by default
SQLite Server
Interact with SQLite databases for queries, schema inspection, and data analysis
Context7 Server
Provide up-to-date, version-specific library documentation directly in your prompts instead of outdated training data
Skyvern Browser Automation
AI-powered browser automation — navigate sites, fill forms, extract structured data, log in with stored credentials, and build reusable workflows