Skills
.Work. You
Rest

advanced-database-tuning

Community

Maximize DB performance with expert tuning.

Software Engineering#database#postgresql#mysql#tuning#pgbouncer#vacuum#slow-queries
Authorivanuser
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Database deployments often suffer from latent queries, bloated maintenance tasks, and suboptimal pool configurations that degrade performance. Advanced Database Tuning provides structured guidance to analyze, tune, and validate changes to restore responsiveness and stability.

Core Features & Use Cases

  • Slow Query Analysis: identify and optimize expensive queries to reduce latency.
  • Vacuum & Analyze Strategy: optimize autovacuum and ANALYZE to maintain up-to-date statistics.
  • Connection Pooling: configure and tune PgBouncer/ProxySQL for scalable concurrency.
  • Index Tuning Workflow: guide for safe index creation and impact assessment.
  • Baseline Validation: establish benchmarks before and after tuning to confirm gains.

Quick Start

Apply baseline tuning steps to your production database during a maintenance window to observe performance improvements.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: advanced-database-tuning
Download link: https://github.com/ivanuser/cortex-server-skills/archive/main.zip#advanced-database-tuning

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.