pg-performance-baseline

PostgreSQL Performance Baseline

This skill guides creation of a comprehensive performance baseline report for a PostgreSQL database, intended for comparison before and after making configuration changes, schema modifications, or infrastructure upgrades.

When to Use This Skill

Use this skill when the user:

• Is about to make database configuration changes and wants a "before" snapshot
• Wants to document current database performance for reference
• Needs to compare performance across time periods
• Asks "how is my database performing?" or "give me a performance report"
• Is planning a migration and needs to capture current metrics
• Wants to establish SLAs or performance targets based on current state

MCP Resources Available

• pgtuner://docs/tools -- Tool reference for parameter details
• pgtuner://docs/prompts -- Available prompt templates
• pgtuner://settings/{category} -- Settings by category (use for structured capture: memory, checkpoint, wal, autovacuum, connections)
• pgtuner://health/{check_type} -- Targeted health metrics by type
• pgtuner://table/{schema}/{table_name}/stats -- Quick per-table stats

Related MCP Prompt

This skill corresponds to the performance_baseline MCP Prompt. If the user triggers that prompt, follow this skill's workflow.

Prerequisites

• The pgtuner-mcp server must be connected with a valid DATABASE_URI
• Required: pg_stat_statements extension (for query workload data)
• Recommended: pgstattuple extension (for bloat measurements)
• Recommended: Sufficient uptime since last pg_stat_statements reset for meaningful workload data

Agent Decision Logic

Before starting:
  |
  +--> Is this a "before" baseline (pre-change)?
  |    --> Collect all 8 steps, save results systematically
  |    --> Tell user: "Baseline collected. After making changes, ask me to
  |        collect another baseline and I will generate a comparison."
  |
  +--> Is this an "after" baseline (post-change)?
  |    --> Collect all 8 steps with identical parameters
  |    --> Generate the Comparison Template with before/after diff
  |
  +--> Is this a standalone performance report?
       --> Collect all 8 steps
       --> Include recommendations inline (not just metrics)