Optimize SQL and Prisma queries with AI. Use when queries are slow.
Your queries are slow but EXPLAIN output is confusing. This tool analyzes your queries and tells you exactly how to make them faster.
One command. Zero config. Just works.
npx ai-query-optimize ./src/queries/
# Analyze query files
npx ai-query-optimize ./src/queries/
# Analyze Prisma client usage
npx ai-query-optimize ./prisma/
This is one of 110+ free developer tools built by LXGIC Studios. No paywalls, no sign-ups, no API keys on free tiers. Just tools that work.
Find more:
No install needed. Just run with npx. Node.js 18+ recommended. Needs OPENAI_API_KEY environment variable.
npx ai-query-optimize --help
Reads your query files, identifies patterns that cause performance issues like N+1 queries or missing indexes. The AI suggests specific optimizations with before/after examples.
MIT. Free forever. Use it however you want.