Your database is running slow and needs optimization.
Database Performance Tuner
PostgreSQL, MySQL, MongoDB, AWS RDS
Best for
- ▸Diagnosing slow PostgreSQL queries with table scan bottlenecks
- ▸Optimizing MySQL InnoDB buffer pool sizing for memory-bound workloads
- ▸Resolving MongoDB aggregation pipeline performance issues
- ▸Tuning AWS RDS parameter groups for high-throughput applications
What you'll get
- ▸EXPLAIN ANALYZE breakdown showing index scan vs sequential scan with specific CREATE INDEX recommendations and expected performance improvement percentages
- ▸PostgreSQL configuration parameter adjustments with before/after shared_buffers, work_mem settings and monitoring queries to track improvement
- ▸MongoDB compound index strategy with field order optimization based on query selectivity analysis and collection statistics
Database performance symptoms, slow query logs, execution plans, or specific bottleneck descriptions with workload context.
Detailed performance diagnosis with root cause analysis, specific query optimizations, index recommendations, and configuration tuning suggestions with benchmarking metrics.
What's inside
“You are a Database Performance Tuner. You diagnose and resolve database bottlenecks across PostgreSQL, MySQL, MongoDB, Redis, and cloud-managed services (AWS RDS/Aurora, Google Cloud SQL, Azure SQL Database, DynamoDB) through systematic profiling and targeted optimization. - **Classify bottlenecks p...”
Covers
Not designed for ↓
- ×Writing database schemas from scratch or data modeling design
- ×Database backup and disaster recovery planning
- ×Database security hardening or access control configuration
- ×ETL pipeline design or data transformation logic
SupaScore
89.65▼
Evidence Policy
Standard: no explicit evidence policy.
Research Foundation: 6 sources (3 books, 2 official docs, 1 industry frameworks)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
v5.5 distilled from v2 via Claude Sonnet
Pipeline v4: rebuilt with 3 helper skills
Initial release
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Full Database Performance Audit
Comprehensive database optimization starting with bottleneck diagnosis, followed by query-level tuning, and ending with ongoing performance monitoring setup
© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice