---

name: sql-pro description: Use when Optimizes SQL queries, designs database schemas, and troubleshoots performance issues.

Sql Pro

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). — One of 66 full-stack developer skills in Jeff Allan's claude-skills plugin (MIT, 9.4k stars).

What you get

• Public GitHub repo (Jeffallan/claude-skills)
• the skills/sql-pro folder with SKILL.md and references. Install via /plugin install fullstack-dev-skills@jeffallan.

Customize your output

• Fork the repo and extend the skill's reference files for your own stack conventions.

Example output

Activates on a matching request (e.g. building or reviewing Sql Pro code) and can chain with other skills in the pack.

Best for

Full-stack developers and engineering teams using Claude Code.