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