database-indexing-strategy▌
aj-geddes/useful-ai-prompts · updated Apr 8, 2026
Design comprehensive indexing strategies to improve query performance, reduce lock contention, and maintain data integrity. Covers index types, design patterns, and maintenance procedures.
Database Indexing Strategy
Table of Contents
Overview
Design comprehensive indexing strategies to improve query performance, reduce lock contention, and maintain data integrity. Covers index types, design patterns, and maintenance procedures.
When to Use
- Index creation and planning
- Query performance optimization through indexing
- Index type selection (B-tree, Hash, GiST, BRIN)
- Composite and partial index design
- Index maintenance and monitoring
- Storage optimization with indexes
- Full-text search index design
Quick Start
B-tree Indexes (Default):
-- Standard equality and range queries
CREATE INDEX idx_users_email ON users(email);
CREATE INDEX idx_orders_created_at ON orders(created_at DESC);
-- Composite indexes for multi-column queries
CREATE INDEX idx_orders_user_status
ON orders(user_id, status)
WHERE cancelled_at IS NULL;
Reference Guides
Detailed implementations in the references/ directory:
| Guide | Contents |
|---|---|
| PostgreSQL Index Types | PostgreSQL Index Types |
| MySQL Index Types | MySQL Index Types |
| Single Column Indexes | Single Column Indexes, Composite Indexes, Partial/Filtered Indexes, Expression Indexes |
Best Practices
✅ DO
- Follow established patterns and conventions
- Write clean, maintainable code
- Add appropriate documentation
- Test thoroughly before deploying
❌ DON'T
- Skip testing or validation
- Ignore error handling
- Hard-code configuration values
Discussion
Product Hunt–style comments (not star reviews)- No comments yet — start the thread.
Ratings
4.6★★★★★56 reviews- ★★★★★Oshnikdeep· Dec 24, 2024
Solid pick for teams standardizing on skills: database-indexing-strategy is focused, and the summary matches what you get after install.
- ★★★★★James Singh· Dec 20, 2024
database-indexing-strategy fits our agent workflows well — practical, well scoped, and easy to wire into existing repos.
- ★★★★★Mateo Mehta· Dec 20, 2024
database-indexing-strategy reduced setup friction for our internal harness; good balance of opinion and flexibility.
- ★★★★★Rahul Santra· Dec 16, 2024
Useful defaults in database-indexing-strategy — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.
- ★★★★★Min Martin· Dec 8, 2024
We added database-indexing-strategy from the explainx registry; install was straightforward and the SKILL.md answered most questions upfront.
- ★★★★★Alexander Bansal· Dec 4, 2024
We added database-indexing-strategy from the explainx registry; install was straightforward and the SKILL.md answered most questions upfront.
- ★★★★★Xiao Ramirez· Nov 27, 2024
database-indexing-strategy reduced setup friction for our internal harness; good balance of opinion and flexibility.
- ★★★★★Alexander Haddad· Nov 23, 2024
database-indexing-strategy reduced setup friction for our internal harness; good balance of opinion and flexibility.
- ★★★★★Daniel Tandon· Nov 23, 2024
Solid pick for teams standardizing on skills: database-indexing-strategy is focused, and the summary matches what you get after install.
- ★★★★★Mateo Menon· Nov 11, 2024
Registry listing for database-indexing-strategy matched our evaluation — installs cleanly and behaves as described in the markdown.
showing 1-10 of 56