All skills
sql-pro
Rewrite slow SQL queries and add indexes, backed by execution plan analysis.
- Part of Jeffallan/claude-skills
- 6.9k installs
- Developer Tools · Backend
When to use it
You have a query that runs slowly on a large table and need to know why and how to fix it.
For example
You say
Use sql-pro to speed up this PostgreSQL query that joins orders and order_items and takes 8 seconds on 5 million rows.
You get
- Optimized query with comments
- Covering index with rationale
- Before/after EXPLAIN analysis
How it works
- Checks EXPLAIN ANALYZE output for sequential scans and estimate mismatches before suggesting changes.
- Targets a sub-100ms goal and iterates on indexes or rewrites if the query misses it.
- Notes dialect differences across PostgreSQL, MySQL, SQL Server, and Oracle.
More Backend skills
See all- cuopt-routing-api-python2.3kBuilds and solves vehicle routing, traveling salesman, and pickup-delivery problems in Python with cuOpt.
- cuopt-server-api-python2.2kStarts the cuOpt REST server and calls its endpoints from Python or curl.
- clickhouse-migrations266Writes and modifies ClickHouse database migrations following project rules.
- django-migrations252Guides safe Django and Postgres migration work, including non-blocking schema changes, backfills and model deletions.
Also in this pack
- golang-pro19.8kWrites concurrent Go services with goroutines, channels, gRPC or REST, and profiles performance.
- php-pro16.4kBuilds modern PHP applications with strict typing, Laravel or Symfony, tests and REST or GraphQL APIs.
- typescript-pro15kBuilds advanced TypeScript types and end-to-end type-safe APIs with tRPC.
- flutter-expert14.9kBuilds cross-platform Flutter apps with widgets, Riverpod or Bloc state, navigation and performance tuning.