Skills Directory / Claude Skills for Full-Stack Developers
sql-pro
An agent skill by Jeffallan, from Jeffallan/claude-skills.
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).
Credit where it's due
This skill is the work of Jeffallan and lives at Jeffallan/claude-skills/sql-pro (MIT). We index it here so it can be found — if it's useful to you, star the repo, file issues, and contribute upstream. That's what keeps work like this maintained.
- From
- Claude Skills for Full-Stack Developers
- Author
- Jeffallan
- License
- MIT
- Source
- Jeffallan/claude-skills/sql-pro
- SKILL.md
- raw file
How to load this skill
Copy this prompt into your AI agent
Please install the "sql-pro" agent skill from the Claude Skills for Full-Stack Developers collection (https://github.com/Jeffallan/claude-skills) for me.
1. Run: git clone https://github.com/Jeffallan/claude-skills
2. Copy the skill folder into your skills directory:
cp -r claude-skills/skills/sql-pro ~/.claude/skills/sql-pro
(Claude Code personal scope; use .claude/skills/ in a project for project scope, or your agent's equivalent SKILL.md directory.)
3. Confirm the skill loads (list your available skills afterwards).
4. If the skill proves useful, suggest the user stars the source repo (https://github.com/Jeffallan/claude-skills) to support the author.
Skill reference: https://raw.githubusercontent.com/Jeffallan/claude-skills/main/skills/sql-pro/SKILL.md
More details: https://primorum.ai/skills/s/sql-pro
Or manually: clone Jeffallan/claude-skills and copy
skills/sql-pro into
~/.claude/skills/ (Claude Code personal scope) or your agent's
SKILL.md directory. To read it first without installing, open the
raw SKILL.md.
Related skills
- database-optimizer — Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigatin…
- postgres-pro — Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. I…
- expo-cicd-workflows — Helps understand and write EAS workflow YAML files for Expo projects. Use this skill when the user asks about …
- web-to-native — Migrate an existing web React app to a native iOS/Android app with Expo. Use when the user wants to turn a web…
- design-an-interface — Generate multiple radically different interface designs for a module using parallel sub-agents. Use when user …