Sql Pro

Reach for this when you're staring at a slow query or need to write something gnarly with window functions and CTEs. It walks you through schema analysis, query optimization with EXPLAIN plans, and covering index design across PostgreSQL, MySQL, SQL Server, and Oracle. The workflow enforces a sub-100ms target and won't let you move on until you've eliminated sequential scans on large tables. What I like is the before/after examples showing correlated subquery rewrites and the quick reference for interpreting EXPLAIN ANALYZE output. It's opinionated about set-based operations and will push you toward EXISTS over COUNT, filtering before joins, and avoiding cursors when a single query will do.

skills.sh installs: 6.8K
GitHub stars: 12.3K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add jeffallan/claude-skills --skill sql-pro --agent claude-code

Installs into .claude/skills of the current project.

Files

SQL Pro

Core Workflow

Schema Analysis - Review database structure, indexes, query patterns, performance bottlenecks
Design - Create set-based operations using CTEs, window functions, appropriate joins
Optimize - Analyze execution plans, implement covering indexes, eliminate table scans
Verify - Run EXPLAIN ANALYZE and confirm no sequential scans on large tables; if query does not meet sub-100ms target, iterate on index selection or query rewrite before proceeding
Document - Provide query explanations, index rationale, performance metrics