PostgreSQL (hardened, read-only)
Read-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction.
Open the source (opens github.com) https://github.com/eszetael/postgres-mcp-hardened
Before you use it
- Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
- Needs credentials: DATABASE_URL. Use a key with the least access you can.
What it is
MCP servers from io.github.Eszetael.
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
npm package (stdio)
postgres-mcp-hardened@0.1.10
From the server's entry in the official MCP Registry
oci package (streamable-http)
ghcr.io/eszetael/postgres-mcp-hardened:0.1.10
From the server's entry in the official MCP Registry
Settings it asks for
DATABASE_URLsecret required · Connection string for the role the server connects as. Use a role that cannot write — the server refuses writes twice, but a read-only role is the layer that…MCP_STATEMENT_TIMEOUT· Server-side statement timeout, e.g. `5s`. A question that would pin the database is cancelled by PostgreSQL, not by hope.MCP_ALLOW_TABLES· Comma-separated allowlist. A table off the list is refused by name, and hiding it inside a CTE, a view or a join does not help.MCP_AUDIT_LOG· Path to the tamper-evident audit log. Entries are chained by hash and survive a restart; `--verify-audit` checks the chain against an off-host anchor.DATABASE_URLsecret required · Connection string for a role that cannot write.MCP_ADDR· Address to bind, default 127.0.0.1:8080.
Related
-
PostgreSQL Performance (read-only)
MCP serversRead-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions
ghcr.io/gouranshul/pg-perf-mcp:0.1.0 -
Sezzlee PostgreSQL
MCP serversExplore and query PostgreSQL read-only: catalogue search, schema introspection and bounded queries.
@sezzlee/postgres-mcp@0.2.1 -
mcp-filesystem
MCP serversHardened filesystem for AI agents — jailed root, read-only default, traversal/symlink-safe.
@infoinlet/mcp-filesystem@0.1.1 -
Vericto Proxy mode (local, PostgreSQL and MySQL)
MCP serversRead-only PostgreSQL and MySQL for AI agents: every statement is checked before it runs. No account.
docker.io/vericto/vericto-proxy:5.2.0@sha256:0fa68edbf196818ed43cca4c2c381e1913c39c9cc84fa63f7321b7358d4dded1 -
read-only-local-postgres-mcp-server
MCP serversMCP server for read-only PostgreSQL database queries in Claude Desktop
@hovecapital/read-only-postgres-mcp-server@0.1.0 -
Halfnine
MCP serversPostgreSQL through Halfnine: describe, read-only queries, and changes you approve in the app.
https://github.com/notinferred/halfnine/releases/download/v0.3.0/halfnine-0.3.0.mcpb