index-suggester

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.