isdaniel/pgtuner_mcp
11 skills
$npx skills add isdaniel/pgtuner_mcpSkillInstalls
pg-bloat-analysisDetects and remediates table and index bloat in PostgreSQL using pgstattuple analysis.pg-config-tuningGuides PostgreSQL configuration tuning based on hardware profile, workload type, and current settings.pg-connection-analysisAnalyzes PostgreSQL connection utilization patterns including active, idle, and idle-in-transaction sessions.pg-health-checkPerforms comprehensive PostgreSQL database health assessments covering connections, cache performance, locks, replication, wait events, active queries, and…pg-index-optimizationPerforms comprehensive PostgreSQL index optimization including unused index cleanup, duplicate detection, missing index recommendations, and hypothetical index…pg-io-deep-diveDeep-dive investigation of PostgreSQL I/O patterns using targeted analysis types (buffer pool, tables, indexes, temp files, checkpoints).pg-lock-diagnosisDiagnoses PostgreSQL lock contention including blocking lock chains, deadlock patterns, idle-in-transaction problems, and wait event analysis.pg-performance-baselineGenerates a comprehensive PostgreSQL performance baseline report capturing health metrics, query workload patterns, table statistics, configuration settings,…pg-query-rewriteGuides SQL query optimization through execution plan analysis and common rewrite patterns.pg-slow-query-diagnosisDiagnoses slow PostgreSQL queries by analyzing pg_stat_statements, execution plans, index opportunities, and table statistics.pg-vacuum-tuningMonitors and tunes PostgreSQL vacuum operations including autovacuum configuration, vacuum progress tracking, wraparound prevention, and per-table vacuum…