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.

index-suggester