Agent skill · data analytics · aiskillstore
database-optimization
SQL query optimization and database performance specialist. Use when
Why this skill is useful
Provides domain-specific knowledge on SQL query optimization techniques and caching strategies that the AI wouldn't reliably generate on its own.
What it needs
About 2k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
Database Optimization This skill optimizes database performance including query optimization, indexing strategies, N+1 problem resolution, and caching implementation. When to Use This Skill When optimizing slow database queries When fixing N+1 query problems When designing indexes When implementing caching strategies When optimizing database migrations When improving database performance What This Skill Does 1. Query Optimization: Analyzes and optimizes SQL queries 2. Index Design: Creates appropriate indexes 3. N+1 Resolution: Fixes N+1 query problems 4. Caching: Implements caching layers (Redis, Memcached) 5. Migration Optimization: Optimizes database migrations 6. Performance Monitoring: Sets up query performance monitoring How to Use Optimize Queries Specific Analysis Optimization Areas Query Optimization Techniques: Use EXPLAIN ANALYZE Optimize JOINs Reduce data scanned Use appropriate indexes Avoid SELECT Index Design Strategies: Index frequently queried columns Composite indexes for multi-column queries Avoid over-indexing Monitor index usage Remove unused indexes N+1 Problem Pattern: Examples Example 1: Query Optimization Input: Optimize slow user query Output: sql SELECT FROM users WHERE email = 'user@example.com'; -- Execution time: 450ms sql -- Add index CREATE INDEX idxusersemail ON users(email); -- Optimized query SELECT id, email, name FROM users WHERE email = 'user@example.com'; -- Execution time: 2ms Best Practices Database Optimization 1. Measure First: Use EXPLAIN ANALYZE 2. Index Strategically: Not every column needs an index 3. Monitor: Track slow query logs 4. Cache: Cache expensive queries 5. Denormalize: When justified by read patterns Reference Files references/querypatterns.md - Common query optimization patterns, anti-patterns, and caching strategies Related Use Cases Query optimization Index design N+1 problem resolution Caching implementation Database performance improvement
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/database-optimization