Design comprehensive indexing strategies to improve query performance, reduce lock contention, and maintain data integrity. Covers index types, design patterns, and maintenance procedures.
Works with
AI-first code editor with Composer
Before installing skills in Cursor, ensure your development environment meets these requirements:
node --versiondatabase-indexing-strategyExecute the skills CLI command in your project's root directory to begin installation:
Fetches database-indexing-strategy from aj-geddes/useful-ai-prompts and configures it for Cursor.
The CLI shows a list of agents. Use arrow keys and space to select Cursor:
Confirm successful installation by checking the skill directory location:
Restart Cursor to activate database-indexing-strategy. Access via /database-indexing-strategy in your agent's command palette.
We perform automated surface-level scans (Gen AI Scanner, Socket, Snyk) during installation. These checks detect common vulnerabilities but do not guarantee complete security. Always review skill source code and verify the publisher's reputation before production use.
Skills execute code in your environment. Always review source, verify the publisher, and test in isolation before production.
Submit your Claude Code skill and start earning
Create detailed user stories, acceptance criteria, and feature specs
Example
Generate user stories for 'password reset feature' with acceptance criteria, edge cases, and test scenarios
Reduce spec writing time by 50%, ensure comprehensive coverage
Research competitors, compare features, identify gaps
Example
Analyze 5 competitor products, create feature comparison matrix, suggest differentiation opportunities
Complete competitive research in 2 hours instead of 2 days
Evaluate features using frameworks (RICE, ICE, Kano) and create prioritized backlogs
Example
Score 20 feature ideas using RICE framework, generate prioritized roadmap with rationale
0
total installs
0
this week
161
GitHub stars
0
upvotes
Run in your terminal
0
installs
0
this week
161
stars
Design comprehensive indexing strategies to improve query performance, reduce lock contention, and maintain data integrity. Covers index types, design patterns, and maintenance procedures.
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;
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 |
Make data-driven prioritization decisions faster
Draft PRDs, status updates, and stakeholder presentations
Example
Create executive summary of Q3 roadmap, monthly progress report, feature launch announcement
Save 3-5 hours/week on communication overhead
Prerequisites
Time Estimate
30-60 minutes to see productivity improvements
Steps
Common Pitfalls
✓ Do
✗ Don't
💡 Pro Tips
✓ Use when
Use for user story writing, competitive research, roadmap prioritization, stakeholder communication, and PRD drafting. Best for reducing repetitive documentation and research work.
✗ Avoid when
Avoid for strategic product vision (requires deep customer empathy), pricing decisions (needs market and financial expertise), or when face-to-face customer discovery is more valuable than speed.
mattpocock/skills
parcadei/continuous-claude-v3
cursor/plugins
ailabs-393/ai-labs-claude-skills
ailabs-393/ai-labs-claude-skills
pproenca/dot-skills
Solid pick for teams standardizing on skills: database-indexing-strategy is focused, and the summary matches what you get after install.
database-indexing-strategy fits our agent workflows well — practical, well scoped, and easy to wire into existing repos.
database-indexing-strategy reduced setup friction for our internal harness; good balance of opinion and flexibility.
Useful defaults in database-indexing-strategy — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.
We added database-indexing-strategy from the explainx registry; install was straightforward and the SKILL.md answered most questions upfront.
We added database-indexing-strategy from the explainx registry; install was straightforward and the SKILL.md answered most questions upfront.
database-indexing-strategy reduced setup friction for our internal harness; good balance of opinion and flexibility.
database-indexing-strategy reduced setup friction for our internal harness; good balance of opinion and flexibility.
Solid pick for teams standardizing on skills: database-indexing-strategy is focused, and the summary matches what you get after install.
Registry listing for database-indexing-strategy matched our evaluation — installs cleanly and behaves as described in the markdown.
showing 1-10 of 56