database-query-optimization
Improve database query performance through indexing, query optimization, and execution plan analysis. Reduce response times and database load.
By aj-geddes · 566 installs
npx skills add aj-geddes/useful-ai-prompts --skill database-query-optimization
Source repository · Upstream listing
Database Query Optimization
Table of Contents
[Overview]( overview)
[When to Use]( when to use)
[Quick Start]( quick start)
[Reference Guides]( reference guides)
[Best Practices]( best practices)
Overview
Slow database queries are a common performance bottleneck. Optimization through indexing, efficient queries, and caching dramatically improves application performance.
When to Use
Slow response times
High database CPU usage
Performance regression
New feature deployment
Regular maintenance
Quick Start
Minimal working example:
Reference Guides
Detailed implementations in the references/ directory:
Guide Contents
[Query Analysis](references/query analysis.md) Query Analysis
[Indexing Strategy](references/indexing strategy.md) Indexing Strategy
[Query Optimization Techniques](references/query optimization techniques.md) Query Optimization Techniques
[Optimization Checklist](references/optimization checklist.md) Optimization Checklist
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