dvcrn Index Suggester
Your queries are slow but you're not sure what to index. This tool analyzes your query files and tells you exactly what indexes to create.
One command. Zero config. Just works.
Quick Start
npx @lxgicstudios/ai-index ./src/queries/
What It Does
- Analyzes your query files for patterns
- Identifies missing indexes
- Suggests composite indexes for complex queries
- Explains why each index helps
Usage Examples
# Analyze all query files
npx @lxgicstudios/ai-index ./src/queries/
# Single file
npx @lxgicstudios/ai-index ./src/queries/users.ts -o indexes.sql
# Prisma queries
npx @lxgicstudios/ai-index ./prisma/
Best Practices
- Don't over-index - indexes slow down writes
- Consider query frequency - index hot paths first
- Use composite indexes wisely - column order matters
- Test before deploying - indexes can change query plans
When to Use This
- Query performance is degrading
- Adding new queries to an app
- Database audit and optimization
- Learning about indexing strategies
Part of the LXGIC Dev Toolkit
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:
- GitHub: https://github.com/LXGIC-Studios
- Twitter: https://x.com/lxgicstudios
- Substack: https://lxgicstudios.substack.com
- Website: https://lxgicstudios.com
Requirements
No install needed. Just run with npx. Node.js 18+ recommended. Needs OPENAI_API_KEY environment variable.
npx @lxgicstudios/ai-index --help
How It Works
Reads your query files, extracts WHERE clauses and JOIN conditions, then determines what indexes would speed up those queries. The AI considers selectivity and query patterns to prioritize suggestions.
License
MIT. Free forever. Use it however you want.