Developer · Local MCP server
Pg Readonly MCP
A read-only Postgres MCP server that parses SQL rather than pattern-matching it.
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
- Namespace
- Namespace verified by the MCP Registry via GitHub (github.com/les-k) · how
- 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
| Registry | Package | Version | Transport |
|---|---|---|---|
| PyPI | pg-readonly-mcp | 0.1.1 | stdio |
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.
| File | Result |
|---|---|
/llms.txt | No real file found |
/.well-known/mcp.json | No real file found |
/.well-known/ai-plugin.json | No real file found |
/agents.json | No real file found |
More from les-k (GitHub)
| Server | Runs |
|---|---|
| MCP ConfirmAn MCP server whose confirmation cannot be replayed against a different call. | Local · stdio |
| Sweep MCPAn MCP server that can delete directories, and the guard rails that make that acceptable. | Local · stdio |
More developer servers
| Server | Runs |
|---|---|
| PetsonalityAn MBTI-powered terminal pet companion for Claude Code and OpenClaw. | Local · stdio |
| Petstore MCP ServerSwagger Petstore API (v1.0.27) as MCP for testing and prototyping powered by the HAPI MCP server. | Remote · HTTPLive check: ✗ no handshake |
| Pg AiguideComprehensive PostgreSQL documentation and best practices, including ecosystem tools. | Remote & Local · HTTP, stdioLive check: ✓ handshake |
| Pg Migration Lock LintNames every statement in a Rails, Django or raw SQL migration that takes a table-blocking Postgres l. | Local · stdio |
| PGAuditorHosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure. | Remote · HTTPLive check: ✗ no handshake |
| pgmcpRead-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health. | Local · stdio |
| pgopsSafe, audited PostgreSQL operations for AI agents: queries, migrations, EXPLAIN, containers. | Local · stdio |
| pgvectorSimilarity search, hybrid search, and index management for pgvector-backed PostgreSQL tables. | Local · stdio |