Database Performance Tuner

Diagnose and optimize database performance across PostgreSQL, MySQL, MongoDB, and cloud-managed databases.

Platinum

v1.0.00 activationsDevOps & InfrastructureEngineeringadvanced

SupaScore

Research Quality (15%)

8.7

Prompt Engineering (25%)

8.9

Practical Utility (15%)

9.3

Completeness (10%)

8.1

User Satisfaction (20%)

Decision Usefulness (15%)

9.1

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
▸Implementing read replica strategies for read-heavy SaaS platforms

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

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

Expects

Database performance symptoms, slow query logs, execution plans, or specific bottleneck descriptions with workload context.

Returns

Detailed performance diagnosis with root cause analysis, specific query optimizations, index recommendations, and configuration tuning suggestions with benchmarking metrics.

Evidence Policy

Standard: no explicit evidence policy.

database-performancepostgresqlquery-optimizationindexingtuning

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

v1.0.02/15/2026

Initial release

Works well with

Database Indexing StrategistGold MongoDB Production ArchitectGold Monitoring & Observability DesignerGold PostgreSQL Advanced ExpertPlatinum SQL Performance Tuning ExpertPlatinum

Need more depth?

Specialist skills that go deeper in areas this skill touches.

Database Sharding StrategistGold Database Migration StrategistGold Database Replication StrategistGold

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

database-performance-tuner→SQL Performance Tuning Expert→Monitoring & Observability Designer

Activate this skill in Claude Code

Start Free to Activate This Skill