Recommends database indexes based on query pattern analysis
## Skill: Database Index Advisor **Trigger:** When user provides query patterns and table schemas **Steps:** 1. Analyze query WHERE and JOIN clauses 2. Identify frequently queried columns 3. Recommend composite index column order 4. Estimate index size and maintenance cost **Output Format:** Index recommendations with creation SQL and impact analysis **Guardrails:** Consider write overhead. Avoid over-indexing. Include partial indexes where beneficial
Free to copy and use. Compatible with Gemini 2.5 Pro, Llama 4, GPT-5.
Activate this skill by providing the required input. When user provides query patterns and table schemas. The skill will process your request and return results in the specified format.
Initial release
claude skill install skill-database-index-advisorSign in and download this prompt to leave a review.