Pg Readonly MCP Server

by les-k Your server? Claim it

local only

Pg Readonly MCP runs on your own machine — the client starts it, so there is no endpoint to ping. 159 installs a week from pypi. Last commit 2 Oct 2026.

A read-only Postgres MCP server that parses SQL rather than pattern-matching it.

Installs per day peak 620 · avg 31 · -80% w/w

a month agotoday

159

Installs / week

pypi · pg-readonly-mcp

Stars

0 open issues

2 Oct 2026

Last commit

from GitHub

MIT

License

Python

Nothing serious here today

Today is the operative word: we check Pg Readonly MCP every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

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 pg-readonly-mcp -- uvx pg-readonly-mcp

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

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

~/.codex/config.toml

[mcp_servers.pg-readonly-mcp]
command = "uvx"
args = ["pg-readonly-mcp"]

.cursor/mcp.json

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

.vscode/mcp.json

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

This one needs environment variables set before it will start: PG_READONLY_MCP_DSN (Postgres connection string for a role that holds only SELECT. The server refuses to start otherwise.). The author declared them in the registry entry; get the values from the project itself.

Alternatives to Pg Readonly MCP

same job, measured the same way

PostgreSQL (hardened, read-only)

by eszetael

Read-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction.

98 installs/wk local only

Data

by thinair

PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.

answering

AI2SQL

by ai2sql

Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema

answering

Read Only Local Postgres MCP Server

by hove

MCP server for read-only PostgreSQL database queries in Claude Desktop

109 installs/wk local only

pgtriage

by pgtriage

Read-only MCP server for evidence-based PostgreSQL performance auditing.

412 installs/wk local only

Postgres (read-only)

by contextflo

Read-only Postgres: drop-in for the archived server-postgres, with schema context.

118 installs/wk local only

JDBC MCP Server

by igorolv

Read-only SQL, plans, schema for AI agents: PostgreSQL, Oracle, SQL Server, Firebird, SQLite, JDBC

local only

SQL Safe MCP

by proprock

Minimal, read-only, PII-safe MCP server for SQL databases.

768 installs/wk local only

Pg Readonly MCP — questions

Answers built from our own checks of this server.

Why is there no uptime for Pg Readonly MCP?

Pg Readonly MCP 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 pg-readonly-mcp was installed 159 times last week.

How do I connect Pg Readonly MCP?

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 pg-readonly-mcp straight from pypi; nothing to host, nothing to sign up for.

How many people use Pg Readonly MCP?

The pypi package pg-readonly-mcp was installed 159 times in the last week. Week over week that is -80%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.

Is Pg Readonly MCP 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.