pgops MCP Server

by arzharch Your server? Claim it

local only

pgops runs on your own machine — the client starts it, so there is no endpoint to ping. 2 482 installs a week from pypi. Last commit 28 Aug 2026.

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

2 482

Installs / week

pypi · pgops-mcp

Stars

0 open issues

28 Aug 2026

Last commit

0 releases in 90 days

MIT

License

Python

What the code does

We read the source, 13 h ago · rules 3dff92dd89df

Capabilities

What this server is able to do. For an MCP server this is often the job itself — a terminal server runs commands because that is what it is for. Listed so you know what you are plugging in, not as an accusation.

Builds a database query by concatenation .github/workflows/publish.yml:126

      - name: Create or update the release
        env:
          GH_TOKEN: ${{ secrets.GITHUB_TOKEN }}

Is this your server and something here is wrong? Tell us — corrections are free and do not require a plan.

This code can reach further than it looks

We found places where it runs commands, builds paths or queries from values it is given. None of that is a flaw by itself — it becomes one when the code changes, and code changes quietly between releases. We re-read it on every one.

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 Code Claude Desktop Codex Cursor VS Code

run in your terminal

claude mcp add pgops-mcp -- uvx pgops-mcp

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

{
  "mcpServers": {
    "pgops-mcp": {
      "args": [
        "pgops-mcp"
      ],
      "command": "uvx"
    }
  }
}

~/.codex/config.toml

[mcp_servers.pgops-mcp]
command = "uvx"
args = ["pgops-mcp"]

.cursor/mcp.json

{
  "mcpServers": {
    "pgops-mcp": {
      "args": [
        "pgops-mcp"
      ],
      "command": "uvx"
    }
  }
}

.vscode/mcp.json

{
  "mcpServers": {
    "pgops-mcp": {
      "args": [
        "pgops-mcp"
      ],
      "command": "uvx"
    }
  }
}

Alternatives to pgops

same job, measured the same way

Locksmith

by cxk280

Lints PostgreSQL migrations for dangerous locking operations and suggests safe rewrites.

44 installs/wk local only

QueryBear

by spencerpauly

Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.

answering

Dataxplan MCP

by arikanatakan

Read PostgreSQL EXPLAIN plans for AI agents: bottlenecks, estimation errors, fixes, charts.

51 installs/wk local only

Midplane

by midplane

Safe-by-default SQL guardrails for AI agents: AST-checked queries, per-table policy, audit log.

387 installs/wk local only

nlqdb — analytical memory for AI agents

by nlqdb

Analytical memory for AI agents: a real Postgres queried in plain English over MCP. One command.

answering

Postgres MCP

by yawlabs

PostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants

7 139 installs/wk local only

PGAuditor

by mcpgatepro

Hosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure.

answering

Berth

by seayniclabs

Database management — query, schema inspection, migrations for PostgreSQL, MySQL, SQLite.

65 installs/wk local only

pgops — questions

Answers built from our own checks of this server.

Why is there no uptime for pgops?

pgops runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the pypi package pgops-mcp was installed 2 482 times last week.

How do I connect pgops?

Copy the ready config from this page — we generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each with the file path that client actually reads. It runs locally, so the command pulls pgops-mcp straight from pypi; nothing to host, nothing to sign up for.

How many people use pgops?

The pypi package pgops-mcp was installed 2 482 times in the last week. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.

Is pgops open source?

Yes — it is published under the MIT licence, written in Python and 0 stars on GitHub. The source link is on this page, so you can read exactly what it does with your data before you connect it.