Find your next open-source project

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

database-optimizer

Analyze slow PostgreSQL or MySQL queries and produce index, query, and config changes with before/after metrics.

When to use it

You have a slow query or execution plan and need to find the bottleneck and a concrete fix.

For example

You say

Use the database-optimizer skill on this PostgreSQL query: SELECT o.id, c.name FROM orders o JOIN customers c ON c.id = o.customer_id WHERE o.status = 'pending' AND o.created_at > now() - interval '7 days'. It takes 4 seconds; help me speed it up.

You get
  • EXPLAIN baseline analysis
  • Covering index SQL
  • Before/after validation queries

How it works

  • Requires a measured EXPLAIN (ANALYZE, BUFFERS) baseline before any change.
  • Changes are applied one at a time so each impact can be attributed.
  • PostgreSQL indexes are created with CONCURRENTLY to avoid table locks.