pgops
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_DSNsecret required · PostgreSQL connection string for the database to operate on.PGOPS_READONLY_DSNsecret · 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_DSNsecret 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
-
GitHub MCP server
MCP serversGitHub's official MCP server. It lets an agent read and work with repositories, issues and pull requests.
https://api.githubcopilot.com/mcp/ -
Apify MCP server
MCP serversLets an agent run Apify's ready-made scrapers to pull data from websites, search engines, maps and social platforms.
-
Official MCP Registry
MCP serversThe MCP project's own registry of public MCP servers, so you can look for a connector before building one.
-
MCP reference servers
MCP serversSmall example servers from the MCP project (filesystem, git, fetch, memory and more) that show how MCP works.
-
Connect MCP servers to Claude Code
MCP serversAnthropic's guide to adding MCP servers to Claude Code, with examples of local and remote servers.
-
Playwright MCP
MCP serversLets an agent drive a real browser: open pages, click, fill in forms and read what's on screen.
claude mcp add playwright npx @playwright/mcp@latest