Skip to main content
affpapa.org
RU EN
skill

sql-pro · davila7 — Claude Code skill: SQL tuning and query plans

A skill that turns the agent into a SQL specialist: writes tricky queries, reads execution plans, picks indexes. Useful when a query is slow and the reason is not obvious.

Install into Claude Code · claude-code-templates All methods and platforms ↓ 
npx claude-code-templates@latest --skill database/sql-pro
Open on GitHub

What sql-pro does

The skill frames the agent as a database expert. It walks the schema, statistics and access paths first, then rewrites the query and checks the result with EXPLAIN. Window functions, recursive CTEs, JSON handling and partitioning each get their own coverage.

The workflow is spelled out in four steps: pin down goals and constraints, inspect schema and statistics, optimize and validate against the plan, then confirm correctness under load. A safety section sits alongside it. Heavy queries against production without safeguards are called out, and read replicas or LIMIT are the suggested route for exploratory work.

Three cases fall outside its scope: you only want ORM-level advice, the store is not SQL or is document-only, or you have no access to query plans and schema details. That last one matters most. Without plans the whole exercise turns into guesswork, so check that you can pull them before installing.

What it helps with

  • read an execution plan and locate the bottleneck
  • rewrite a slow analytical query
  • choose indexes that match real access patterns
  • design a schema for OLTP or OLAP workloads
  • validate a query against realistic data volumes

Example prompts for the agent

  • Look at this query plan and tell me what is slowing it down
  • Rewrite this query using window functions instead of the self-join
  • Suggest indexes for this schema and explain the trade-offs

How to install sql-pro

1claude-code-templates

npx claude-code-templates@latest --skill database/sql-pro

2Skills CLI (Vercel)

npx skills add davila7/claude-code-templates --skill sql-pro -a claude-code

3Manually: put the files in place

~/.claude/skills/sql-pro/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/sql-pro/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about sql-pro

How do I install sql-pro in Claude Code?

Use the templates CLI: npx claude-code-templates@latest --skill database/sql-pro. Or install through the skills CLI: npx skills add davila7/claude-code-templates --skill sql-pro -a claude-code.

What does sql-pro do?

It helps write and tune SQL: inspects schema and statistics, rewrites queries, validates them with EXPLAIN and picks indexes. Data modeling for OLTP and OLAP is covered too.

When is sql-pro the wrong tool?

When you only need ORM-level guidance, when the system is not SQL or is document-only, or when query plans and schema details are out of reach.

Similar skills

All skills for Data and databases →

sql-pro by other authors comes first.

sql-pro https://github.com/Jeffallan Optimizes slow SQL queries, designs database schemas, and fixes performance bottlenecks. Built for EXPLAIN plan tuning and cross-dialect migrations. CX Codex +1 6,400installs sql-best-practices Mindrally SQL guidelines for coding agents: covers query formatting, indexing, explicit joins, and injection defenses for database workflows. CX Codex +1 790installs sql-optimization-patterns Seth Hobson This skill helps inspect slow SQL, EXPLAIN plans, and index choices. Use it when a query scans too much data, JOINs poorly, or causes N+1 calls. CX Codex 19,717installs sql-query-optimization aj-geddes This skill digs into slow SQL queries on PostgreSQL and MySQL: execution plans, indexes, rewriting. Useful when a query drags and you can't tell why. CX Codex +1 520installs mysql-best-practices Mindrally A skill that gives the agent rules for MySQL schema design, indexing and query optimization. Useful when it writes migrations or debugs a slow query. CX Codex +1 2,700installs database-query-optimization aj-geddes A skill that walks your agent through slow SQL: execution plans, indexes, and where the time actually goes. Useful when the database drags. CX Codex +1 586installs mongodb-query-optimizer mongodb This skill digs into slow MongoDB queries and suggests indexes. Handy when explain() shows a COLLSCAN and your database drags. CX Codex +1 7,100installs

From the same set495

The whole set →
create-jtbd Generates a Jobs-to-be-Done analysis document for product features without technical implementation notes or time estimates. 290installs database-optimizer A Claude skill that digs into database bottlenecks: execution plans, indexes, N+1, caching and partitioning. Useful when queries are slow and the reason isn't obvious. 286installs sprint-planning This command builds a sprint plan from Linear or GitHub data, covering capacity, priorities, dependencies, and risks. 282installs husky Runs lint, build, types and tests step by step, fixing failures until the repo works again. Handy before you commit. 282installs exploratory-data-analysis A Claude skill that identifies a scientific file's format and writes a markdown report on its structure, quality and next analysis steps. 279installs env-file-protection This hook stops Write calls aimed at .env* files, so an agent cannot overwrite your secrets by accident. One command adds it to Claude settings. 279installs slack-notifications Posts a Slack message when Claude finishes working or a subagent completes its task. Useful when you step away from the terminal and want to know the run is done. 279installs setup-monitoring-observability This command inspects a project and guides setup for metrics, logs, tracing, and alerts. Choose one area or request the full observability stack. 279installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor