All skills
database-optimizer
Analyze slow PostgreSQL or MySQL queries and produce index, query, and config changes with before/after metrics.
- Part of Jeffallan/claude-skills
- 6.5k installs
- Data · Databases
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.
More Databases skills
See all- wren1.7kPoints the agent to the Wren CLI workflow for querying 22+ databases and setting up connections.
- querying-local-postgres141Runs read-only SQL against the local Postgres database to inspect tables, debug data and analyze query plans.
- generate-mdlExplores an existing database and scaffolds a Wren MDL project with normalized types and YAML definitions.
- plugin-neonManages serverless Postgres projects, branches and queries in your Neon account.
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.