sql-pro

An agent skill by Jeffallan, from Jeffallan/claude-skills. Tags: analytics, database, debugging, migration, performance.

What it does

Optimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks why their query is slow, needs help writing complex joins or aggregations, mentions database performance issues, or wants to design or migrate a schema. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis, covering index creation, recursive queries, EXPLAIN/ANALYZE interpretation, before/after query benchmarking, or migrating queries between database dialects (PostgreSQL, MySQL, SQL Server, Oracle).

Install

With the skills CLI, which installs into Claude Code, Codex, Cursor and other agents:

npx skills add Jeffallan/claude-skills --skill sql-pro

Or copy the skill folder into Claude Code's skills directory by hand (~/.claude/skills for every project, or .claude/skills inside one):

git clone --depth 1 https://github.com/Jeffallan/claude-skills
cp -r claude-skills/skills/sql-pro ~/.claude/skills/sql-pro

Safety box score

Not rated yet. A safety box score grades what a skill and its scripts can reach on the machine of whoever installs it, across eight categories from shell execution to secrets access. Anyone can request one from this page; it is saved for everyone. How the score works.

Source

Repository

Jeffallan/claude-skills (all skills from this repository)

Path

skills/sql-pro/SKILL.md

Branch

main

Updated

2026-09-19

Related skills

• database-optimizer — Optimizes database queries and improves performance across PostgreSQL and MySQL systems.
• postgres-pro — Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features.
• redshift-guide — Amazon Redshift is NOT PostgreSQL — corrects PostgreSQL-derived LLM mistakes; covers Redshift-specific SQL, DDL, COPY/UNLOAD, system views, metadata discovery.
• monitoring-expert — Configures monitoring systems, implements structured logging pipelines, creates Prometheus/Grafana dashboards, defines alerting rules.
• amazon-dynamodb — Designs, reviews, and debugs DynamoDB data layers from design axioms — enumerates access patterns, chooses partition/sort keys and GSIs.
• amazon-keyspaces — Provides authoritative compatibility checks, pricing estimates, connection troubleshooting, pre-warming guidance.