index-suggester

✓Verified·Scanned 2/18/2026

Provides a CLI that analyzes local query files and suggests database indexes using an OpenAI model. It sends local query file contents to OpenAI via openai.chat.completions.create and requires the OPENAI_API_KEY environment variable.

from clawhub.ai·v8fd2125·41.6 KB·0 installs

Scanned from 1.0.1 at 8fd2125 · Transparency log ↗

$ vett add clawhub.ai/lxgicstudios/index-suggester

@lxgicstudios/ai-index

Analyze your query patterns and get smart database index suggestions. Tells you exactly what to create and why.

Install

npm install -g @lxgicstudios/ai-index

Usage

npx @lxgicstudios/ai-index ./src/queries/
# Analyzes all query files and suggests indexes

npx @lxgicstudios/ai-index ./src/queries/users.ts -o indexes.sql
# Single file, saves SQL to file

Setup

export OPENAI_API_KEY=sk-...

Options

-o, --output <path> - Save suggestions to file

License

MIT