# sql-pro

> Claude/Codex skill by [@jeffallan](https://omgskills.com/library/jeffallan/index.md) · 8.8k stars · Updated 2026-05-01

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).

Tags: ai-agents, claude, claude-code, claude-marketplace, claude-skills

## Install

```sh
git clone https://github.com/Jeffallan/claude-skills /tmp/claude-skills && ln -s /tmp/claude-skills/skills/sql-pro ~/.claude/skills/sql-pro
```

## Links

- HTML page: https://omgskills.com/skills/jeffallan/claude-skills/sql-pro/
- GitHub: https://github.com/Jeffallan/claude-skills
- Author: [@jeffallan](https://omgskills.com/library/jeffallan/index.md)

## More from this repo

- [django-storages-s3](https://omgskills.com/skills/jeffallan/claude-skills/skills/django-storages-s3/index.md) — Used when configuring Django to store static and media files on AWS S3 with django-storages.
   - [@Jeffallan](https://omgskills.com/library/jeffallan/index.md) · 12k stars
- [rag-architect](https://omgskills.com/skills/jeffallan/claude-skills/skills/rag-architect/index.md) — Designs and implements production-grade RAG systems by chunking documents, generating embeddings, configuring vector...
   - [@Jeffallan](https://omgskills.com/library/jeffallan/index.md) · 11k stars
- [terraform-engineer](https://omgskills.com/skills/jeffallan/claude-skills/skills/terraform-engineer/index.md) — Used when implementing infrastructure as code with Terraform across AWS, Azure, or GCP.
   - [@Jeffallan](https://omgskills.com/library/jeffallan/index.md) · 11k stars