pgops MCP Server

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

claude mcp add pgops-mcp -e 'PGOPS_DSN=<PGOPS_DSN>' -- uvx pgops-mcp

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<PGOPS_DSN>"
      }
    }
  }
}

[mcp_servers.pgops-mcp]
command = "uvx"
args = ["pgops-mcp"]
env = { PGOPS_DSN = "<PGOPS_DSN>" }

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<PGOPS_DSN>"
      }
    }
  }
}

{
  "servers": {
    "pgops-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<PGOPS_DSN>"
      }
    }
  }
}

Put your own value in place of <PGOPS_DSN> (PostgreSQL connection string for the database to operate on). The author’s registry entry marks it as required.

Optional settings from the registry entry, left out of the block above: PGOPS_READONLY_DSN (Optional separate DSN for the read-only pool. Use a role with no write grants to enforce read-only at the database rather than only in the server), PGOPS_READ_ONLY (Set to 1 to withhold every mutating tool. Write tools are not registered at all, so an agent cannot call them), PGOPS_APPROVAL_MODE (Set to 1 to register container.restart and container.exec. Off by default: Docker socket access is root-equivalent on the host), PGOPS_AUDIT_LOG (Path to the append-only JSONL audit log), PGOPS_DEFAULT_TIMEOUT_MS (Statement timeout applied to every query unless a tool call overrides it), PGOPS_MAX_TIMEOUT_MS (Ceiling a caller-supplied timeout is clamped to), PGOPS_DEFAULT_ROW_LIMIT (Rows returned by query.read when the caller does not specify a limit).