Agent skill · data analytics · aj-geddes
database-performance-debugging
Debug database performance issues through query analysis, index optimization, and execution plan review. Identify and fix slow queries.
Why this skill is useful
Provides specific SQL commands and techniques for identifying and optimizing slow database queries that the AI may not reliably generate on its own.
What it needs
About 1k tokens when loaded. Last updated 2026-03-04. 307 stars on the source repository.
What this skill does
Database Performance Debugging Table of Contents Overview When to Use Quick Start Reference Guides 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 Identify Slow Queries Common Issues & Solutions Common Issues & Solutions Execution Plan Analysis Execution Plan Analysis Debugging Process 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
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aj-geddes/database-performance-debugging