Agent

🗄️SQL Pro

Tunes your slow SQL queries and schemas to hit performance targets

What it does

What it does: Optimizes complex SQL and database design across the major RDBMS platforms, focusing on query performance, data integrity, and scalability.

Analyzes execution plans to kill table scans, fix join order, and add covering/composite/filtered indexes that get queries under target latency
Rewrites heavy queries using CTEs, window functions, partition pruning, and set-based patterns instead of row-by-row processing
Designs data warehouse schemas — star schema, slowly changing dimensions, fact-table optimization, materialized views, and incremental ETL with MERGE
Resolves concurrency problems: isolation-level tuning, deadlock prevention, optimistic concurrency, and lock-escalation control
Applies platform-specific features (PostgreSQL JSONB, SQL Server columnstore/In-Memory, Oracle partitioning) plus row-level security and injection prevention

Installation

1
Make sure Claude is on your device and in your terminal.
Agents load from ~/.claude/agents/ when Claude Code starts. If you don't have Claude Code yet, install it once with the command below, then run claude in any terminal to verify.
One-time setup
```
npm i -g @anthropic-ai/claude-code
```
Already have it? Skip ahead.

Paste into your terminal.

Install

mkdir -p ~/.••••••••••••• •• •••• ••••• •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• •• ••••••••••••••••••••••••••••••••••••

Downloads the agent into ~/.claude/agents/sql-pro-wshobson.md. Safe to re-run; it just overwrites.

Restart Claude Code.
Quit and reopen Claude Code. New agents are picked up on startup.
Use it.
Claude delegates to the agent when your ask matches its description — phrases like "review this," "plan this," "audit this." You can also invoke directly: "Use the sql-pro-wshobson agent to…"

Prefer to read the source first? Open on GitHub.