sql-pro — Skills — getagentictools

What it does

Seq Scan on large table → add or fix an index

actual rows ≫ estimated rows → run ANALYZE <table> to refresh statistics

Buffers: shared hit vs read → high read count signals missing cache / index

Analyze execution plans before recommending optimizations

Use set-based operations over row-by-row processing

Apply filtering early in query execution (before joins where possible)

Use EXISTS over COUNT for existence checks

sql pro

Source

Repository: https://github.com/jeffallan/claude-skills

sql-pro FAQ

What does the sql-pro skill do?

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). Seq Scan on large table → add or fix an index actual rows ≫ estimated rows → run ANALYZE <table> to refresh statistics

How do I install sql-pro?

Run: npx -y skills add https://github.com/jeffallan/claude-skills --skill sql-pro --agent claude-code — the source lives at github.com/jeffallan/claude-skills.

Maintain sql-pro?

Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.

[sql-pro on getagentictools](https://getagentictools.com/skills/jeffallan-claude-skills-sql-pro?ref=badge)

npx agentictools info skills/jeffallan-claude-skills-sql-pro

The second line is the CLI lookup for this page — handy in READMEs and docs.