Database Indexing Strategy

A solid reference for when you're adding indexes to PostgreSQL or MySQL and need to think beyond the defaults. Covers the standard index types (B-tree, Hash, GiST, BRIN), composite indexes, and partial indexes with practical SQL examples. The structure is straightforward: guidance on choosing the right index type, patterns for multi-column scenarios, and maintenance considerations. Most useful when you're optimizing slow queries or designing schemas from scratch and want to avoid the classic mistakes like indexing everything or missing compound index opportunities. The reference guides break down database-specific implementations, which saves you from hunting through docs.

Install to Claude Code

npx -y skills add aj-geddes/useful-ai-prompts --skill database-indexing-strategy --agent claude-code