Agent skill · data analytics · aj-geddes
database-query-optimization
Improve database query performance through indexing, query optimization, and execution plan analysis. Reduce response times and database load.
Why this skill is useful
Provides specific query optimization techniques and execution plan analysis that the AI wouldn't 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 Query Optimization Table of Contents Overview When to Use Quick Start Reference Guides 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 Query Analysis Indexing Strategy Indexing Strategy Query Optimization Techniques Query Optimization Techniques Optimization Checklist 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
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aj-geddes/database-query-optimization