InnerVault

pgops

Stale Official MCP Registry, io.github.arzharch

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

Open the source (opens github.com) https://github.com/arzharch/pgops-mcp

Before you use it

  • Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
  • Needs credentials: PGOPS_DSN, PGOPS_READONLY_DSN. Use a key with the least access you can.

What it is

MCP servers from io.github.arzharch.

The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.

How to get it

pypi package (stdio)

pgops-mcp@0.1.9

From the server's entry in the official MCP Registry

oci package (stdio)

ghcr.io/arzharch/pgops-mcp:0.1.9

From the server's entry in the official MCP Registry

Settings it asks for

  • PGOPS_DSN secret required · 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.
  • PGOPS_DSN secret required · PostgreSQL connection string. From inside a container, localhost is the container itself — use host.docker.internal or the compose service name.
  • PGOPS_READ_ONLY · Set to 1 to withhold every mutating tool.
  • PGOPS_AUDIT_LOG · Path to the audit log inside the container. Mount a volume at this path or the log dies with the container.

Related

  1. GitHub MCP server

    MCP servers

    GitHub's official MCP server. It lets an agent read and work with repositories, issues and pull requests.

    Hand-checked InnerVault (hand-checked), GitHub 34.3k ★MIT

    https://api.githubcopilot.com/mcp/
  2. Apify MCP server

    MCP servers

    Lets an agent run Apify's ready-made scrapers to pull data from websites, search engines, maps and social platforms.

    Hand-checked InnerVault (hand-checked), Apify 16.0k ★MIT

  3. Official MCP Registry

    MCP servers

    The MCP project's own registry of public MCP servers, so you can look for a connector before building one.

    Hand-checked InnerVault (hand-checked), MCP project Moving from MIT to Apache-2.0

  4. MCP reference servers

    MCP servers

    Small example servers from the MCP project (filesystem, git, fetch, memory and more) that show how MCP works.

    Hand-checked InnerVault (hand-checked), MCP project Moving from MIT to Apache-2.0

  5. Anthropic's guide to adding MCP servers to Claude Code, with examples of local and remote servers.

    Hand-checked InnerVault (hand-checked), Anthropic Anthropic documentation

  6. Playwright MCP

    MCP servers

    Lets an agent drive a real browser: open pages, click, fill in forms and read what's on screen.

    Hand-checked InnerVault (hand-checked), Microsoft Apache-2.0

    claude mcp add playwright npx @playwright/mcp@latest