pg_monitor_database

Monitor PostgreSQL databases in real-time, track queries, locks, replication, and set alert thresholds for connection usage, long-running queries, cache hit ratio, dead tuples, and vacuum age.

Instructions

Get real-time monitoring information for a PostgreSQL database

Input Schema

Name	Required	Description
`alertThresholds`	No	Alert thresholds
`connectionString`	No
`includeLocks`	No
`includeQueries`	No
`includeReplication`	No
`includeTables`	No

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "alertThresholds": {
      "additionalProperties": false,
      "description": "Alert thresholds",
      "properties": {
        "cacheHitRatio": {
          "description": "Cache hit ratio threshold",
          "maximum": 1,
          "minimum": 0,
          "type": "number"
        },
        "connectionPercentage": {
          "description": "Connection usage percentage threshold",
          "maximum": 100,
          "minimum": 0,
          "type": "number"
        },
        "deadTuplesPercentage": {
          "description": "Dead tuples percentage threshold",
          "maximum": 100,
          "minimum": 0,
          "type": "number"
        },
        "longRunningQuerySeconds": {
          "description": "Long-running query threshold in seconds",
          "exclusiveMinimum": 0,
          "type": "number"
        },
        "vacuumAge": {
          "description": "Vacuum age threshold in days",
          "exclusiveMinimum": 0,
          "type": "integer"
        }
      },
      "type": "object"
    },
    "connectionString": {
      "type": "string"
    },
    "includeLocks": {
      "default": false,
      "type": "boolean"
    },
    "includeQueries": {
      "default": false,
      "type": "boolean"
    },
    "includeReplication": {
      "default": false,
      "type": "boolean"
    },
    "includeTables": {
      "default": false,
      "type": "boolean"
    }
  },
  "type": "object"
}

PostgreSQL MCP Server

pg_monitor_database

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from PostgreSQL MCP Server

Related Tools

MCP directory API