Find your next open-source project

Search by name, purpose, or keyword — or paste a GitHub repository URL
All skills

sql-pro

Rewrite slow SQL queries and add indexes, backed by execution plan analysis.

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.