analyze_db_health

Check and optimize PostgreSQL database performance with health assessments for indexes, connections, vacuum, sequences, replication, buffer cache, and constraints. Specify individual checks or run all by default.

Instructions

Analyzes database health. Here are the available health checks:

index - checks for invalid, duplicate, and bloated indexes
connection - checks the number of connection and their utilization
vacuum - checks vacuum health for transaction id wraparound
sequence - checks sequences at risk of exceeding their maximum value
replication - checks replication health including lag and slots
buffer - checks for buffer cache hit rates for indexes and tables
constraint - checks for invalid constraints
all - runs all checks You can optionally specify a single health check or a comma-separated list of health checks. The default is 'all' checks.

Input Schema

Name	Required	Description	Default
`health_type`	No	Optional. Valid values are: all, buffer, connection, constraint, index, replication, sequence, vacuum.	all

Input Schema (JSON Schema)

{
  "properties": {
    "health_type": {
      "default": "all",
      "description": "Optional. Valid values are: all, buffer, connection, constraint, index, replication, sequence, vacuum.",
      "title": "Health Type",
      "type": "string"
    }
  },
  "title": "analyze_db_healthArguments",
  "type": "object"
}

Postgres MCP

analyze_db_health

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Postgres MCP

Related Tools