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