Developer · Local MCP server

Pg Readonly MCP

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

Visit Pg Readonly MCP's website

What the MCP Registry states

The entry as published to the official MCP Registry (read 2026-10-04), latest version.

Registry name
io.github.les-k/pg-readonly-mcp
Version
0.1.1
Status
Active
Category
developer
Transport
stdio (local process)
Package
PyPI
Published
2026-10-02
Updated
2026-10-02
Publisher
les-k (GitHub) · 3 servers with pages here
Listed under
PostgreSQL MCP servers
Website
les-k.github.io/field-notes.html
Repository
github.com/les-k/pg-readonly-mcp
Source
Registry API entry

Packages

RegistryPackageVersionTransportEnvironment variables
PyPIpg-readonly-mcp0.1.1stdioPG_READONLY_MCP_DSN (required, secret)

How to connect Pg Readonly MCP

Pg Readonly MCP runs locally from a Python package published to PyPI: pg-readonly-mcp version 0.1.1. It speaks MCP over stdio, so the client starts it as a program and talks to it through standard input and output. It needs Python; clients usually start it with uvx (from uv) or after pip install — the usual command is uvx pg-readonly-mcp. It reads the environment variable PG_READONLY_MCP_DSN (required, secret); set it in the client's configuration for this server.

In the mcpServers JSON format that many desktop and editor MCP clients read, the entry looks like this (placeholders in angle brackets):

{
  "mcpServers": {
    "pg-readonly-mcp": {
      "command": "uvx",
      "args": [
        "pg-readonly-mcp"
      ],
      "env": {
        "PG_READONLY_MCP_DSN": "<secret>"
      }
    }
  }
}

Derived from the registry entry, not tested here. What the server does, and on what terms, is set by its publisher; check its repository or website before giving it access to your accounts or files. How to add an MCP server to an assistant · Before you connect

Site checks

The website's own root, les-k.github.io, was checked for the files that tell AI systems about a site.

FileResult
/llms.txtNo real file found
/.well-known/mcp.jsonNo real file found
/.well-known/ai-plugin.jsonNo real file found
/agents.jsonNo real file found

More from les-k (GitHub)

All 3 →
ServerRunsEndpoint or package
MCP ConfirmAn MCP server whose confirmation cannot be replayed against a different call.Local · stdioPyPI: mcp-confirm
Sweep MCPAn MCP server that can delete directories, and the guard rails that make that acceptable.Local · stdioPyPI: sweep-mcp

More developer servers

All 6,250 →
ServerRunsEndpoint or package
Pexels MCP ServerMCP server for the Pexels API: search & fetch stock photos, videos, and collections.Local · stdionpm: @hanoak/pexels-mcp-server
pfx.chMCP Server für Forterro Proffix Px5 ERP.Remote · HTTPmcp.pfx.ch
Pg AiguideComprehensive PostgreSQL documentation and best practices, including ecosystem tools.Remote & Local · HTTP, stdiomcp.tigerdata.com
Pg Migration Lock LintNames every statement in a Rails, Django or raw SQL migration that takes a table-blocking Postgres l.Local · stdionpm: @readystack/pg-migration-lock-lint
PGAuditorHosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure.Remote · HTTPapi.mcpgatepro.com
pgopsSafe, audited PostgreSQL operations for AI agents: queries, migrations, EXPLAIN, containers.Local · stdioPyPI: pgops-mcp
PH Schools MCP ServerLocal stdio MCP server for searching and analyzing the Philippine schools masterlist dataset.Local · stdionpm: @darwinphi/ph-schools-mcp-server
Phantom SecretsStop AI coding agents from leaking API keys. Local proxy swaps real secrets for phm_ tokens.Local · stdionpm: phantom-secrets-mcp