pgops MCP Server

io.github.arzharch/pgops-mcp

Repository Registry

What is the pgops MCP server?

Safe, audited PostgreSQL operations for AI agents: queries, migrations, EXPLAIN, containers

How to install pgops

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

PGOPS_DSN
required
secret
PostgreSQL connection string for the database to operate on.
PGOPS_READONLY_DSN
secret
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.

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<YOUR_PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<YOUR_PGOPS_READONLY_DSN>",
        "PGOPS_READ_ONLY": "<YOUR_PGOPS_READ_ONLY>",
        "PGOPS_APPROVAL_MODE": "<YOUR_PGOPS_APPROVAL_MODE>",
        "PGOPS_AUDIT_LOG": "<YOUR_PGOPS_AUDIT_LOG>",
        "PGOPS_DEFAULT_TIMEOUT_MS": "<YOUR_PGOPS_DEFAULT_TIMEOUT_MS>",
        "PGOPS_MAX_TIMEOUT_MS": "<YOUR_PGOPS_MAX_TIMEOUT_MS>",
        "PGOPS_DEFAULT_ROW_LIMIT": "<YOUR_PGOPS_DEFAULT_ROW_LIMIT>"
      }
    }
  }
}

Related MCP servers

io.github.asadullokhn/teztun

Maintained

Manage TezTun tunnels, subdomains, and service tokens from any MCP-compatible AI client.

JavaScript

MIT

View repository →

Renology Renovation Cost Data

Maintained

Read-only 2026 city renovation cost ranges with sources, limitations, and citation guidance.

JavaScript

MIT

View repository →

Leteo

Active

Persistent memory for AI coding agents: one Rust binary, one local SQLite database.

Rust

MIT

View repository →

io.github.asaraog/mcp-cricket

Active

Live cricket incl. US Minor League, Kalshi prices, and a win model fitted on 10,847 matches.

BSD-3-Clause

View repository →

Bay Area Mobile Dog Wash Booking

Active

Check prices by dog size, see openings, and book a mobile dog wash in San Jose + South Bay

View repository →

Well Prepped Life Booking

Active

Check availability and book a free consult for Bay Area senior/disabled meal-prep delivery

View repository →