database-performance-debugging

Debug database performance issues through query analysis, index optimization, and execution plan review. Identify and fix slow queries.

By aj-geddes · 479 installs

npx skills add aj-geddes/useful-ai-prompts --skill database-performance-debugging

Source repository · Upstream listing

Database Performance Debugging Table of Contents [Overview]( overview) [When to Use]( when to use) [Quick Start]( quick start) [Reference Guides]( reference guides) [Best Practices]( best practices) Overview Database performance issues directly impact application responsiveness. Debugging focuses on identifying slow queries and optimizing execution plans. When to Use Slow application response times High database CPU Slow queries identified Performance regression Under load stress Quick Start Minimal working example: Reference Guides Detailed implementations in the references/ directory: Guide Contents [Identify Slow Queries](references/identify slow queries.md) Identify Slow Queries [Common Issues & Solutions](references/common issues solutions.md) Common Issues & Solutions [Execution Plan Analysis](references/execution plan analysis.md) Execution Plan Analysis [Debugging Process](references/debugging process.md) Debugging Process 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