Postgres MCP Pro

Instructions

Implementation Reference

• src/postgres_mcp/server.py:453-479 (handler)

  The analyze_db_health tool implementation in src/postgres_mcp/server.py. It uses the DatabaseHealthTool class to perform the checks.

  @mcp.tool(
      description="Analyzes database health. Here are the available health checks:\n"
      "- index - checks for invalid, duplicate, and bloated indexes\n"
      "- connection - checks the number of connection and their utilization\n"
      "- vacuum - checks vacuum health for transaction id wraparound\n"
      "- sequence - checks sequences at risk of exceeding their maximum value\n"
      "- replication - checks replication health including lag and slots\n"
      "- buffer - checks for buffer cache hit rates for indexes and tables\n"
      "- constraint - checks for invalid constraints\n"
      "- all - runs all checks\n"
      "You can optionally specify a single health check or a comma-separated list of health checks. The default is 'all' checks."
  )
  async def analyze_db_health(
      health_type: str = Field(
          description=f"Optional. Valid values are: {', '.join(sorted([t.value for t in HealthType]))}.",
          default="all",
      ),
  ) -> ResponseType:
      """Analyze database health for specified components.
  
      Args:
          health_type: Comma-separated list of health check types to perform.
                      Valid values: index, connection, vacuum, sequence, replication, buffer, constraint, all
      """
      health_tool = DatabaseHealthTool(await get_sql_driver())
      result = await health_tool.health(health_type=health_type)
      return format_text_response(result)