Query Optimization · seb1n/awesome-ai-agent-skills

Diagnose and speed up slow SQL queries

Analyzes EXPLAIN/EXPLAIN ANALYZE execution plans to find missing indexes, inefficient scans, and N+1 problems, then rewrites queries and tunes ORM calls, useful when a specific query or performance symptom needs fixing.

Good for

  • Speed up a slow query flagged in production logs
  • Fix an N+1 query problem in a Django or Prisma app
  • Decide which index to add for a slow JOIN
Category
Coding

Open-source skills are maintained by their authors and listed as published, with attribution. Results depend on how well the skill fits your task and material.

A good place to start

Here's a slow query and its EXPLAIN ANALYZE output — help me find the bottleneck and speed it up.

Make your next great thing.

Bring a question, a file, or an idea that’s not quite there yet.