SQL Pro skill: what it does and how to install it
Optimizes SQL queries and database schemas across PostgreSQL, MySQL, SQL Server and Oracle using execution plans, indexes and set-based patterns.
Summary generated from the skill's documentation.
Warning. A security audit flagged this skill with a critical risk warning. Read its SKILL.md and scripts before you install it.
Install
$ npx skills add Jeffallan/claude-skills --skill sql-proRun it in a terminal. If your agent is already running, start a new session so it picks the skill up.
About this skill
What it does. Reviews schemas, query patterns and execution plans, then designs or rewrites SQL using CTEs, window functions, joins and covering indexes. It verifies changes with EXPLAIN ANALYZE, compares performance and documents query, index and dialect-specific recommendations.
When to use it. For slow queries, complex aggregations, query-plan analysis, indexing, schema design or migrations between SQL dialects. It favours set-based operations, early filtering and production-scale testing.
History
Repo stars
11.8k+102 since 5 Oct 2026
Stars are counted for the whole repository, which holds 17 skills.
Show as a table
| Date | Repo stars |
|---|---|
| 12 Oct 2026 | 11,838 |
| 11 Oct 2026 | 11,819 |
| 10 Oct 2026 | 11,806 |
| 9 Oct 2026 | 11,791 |
| 8 Oct 2026 | 11,776 |
| 7 Oct 2026 | 11,756 |
| 6 Oct 2026 | 11,746 |
| 5 Oct 2026 | 11,736 |
Installs
6.1k
Tracking since . A chart appears once there are 7 days of data.
Installs via skills.sh
Similar skills
- SQL OptimizationOptimises SQL queries across MySQL, PostgreSQL, SQL Server and Oracle with execution-plan analysis, indexing and performance tuning guidance.
- PostgreSQL OptimizationOptimises PostgreSQL queries and schemas using advanced data types, indexes, extensions and database performance monitoring.
- SQL Optimization PatternsOptimises SQL queries with execution plans, indexing strategies and database maintenance techniques to reduce latency and load.