PostgreSQL (hardened, read-only) MCP Server
io.github.Eszetael/postgres-mcp-hardened
What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the PostgreSQL (hardened, read-only) MCP server?
Read-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction.
How to install PostgreSQL (hardened, read-only)
Copy-paste configuration for popular MCP clients.
DATABASE_URLrequiredsecretConnection 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 does not depend on us being correct. `--print-setup-sql` prints the SQL that creates one.
MCP_STATEMENT_TIMEOUTServer-side statement timeout, e.g. `5s`. A question that would pin the database is cancelled by PostgreSQL, not by hope.
MCP_ALLOW_TABLESComma-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_LOGPath 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.
MCP_ADDRAddress to bind, default 127.0.0.1:8080.
{
"mcpServers": {
"postgres-mcp-hardened": {
"command": "npx",
"args": [
"-y",
"postgres-mcp-hardened",
"--stdio"
],
"env": {
"DATABASE_URL": "<YOUR_DATABASE_URL>",
"MCP_STATEMENT_TIMEOUT": "<YOUR_MCP_STATEMENT_TIMEOUT>",
"MCP_ALLOW_TABLES": "<YOUR_MCP_ALLOW_TABLES>",
"MCP_AUDIT_LOG": "<YOUR_MCP_AUDIT_LOG>",
"MCP_ADDR": "<YOUR_MCP_ADDR>"
}
}
}
}Related MCP servers

EvidInvest
SEC filings and financial data for AI agents: 59 tools for statements, valuation and supply chains.
Premium agentic endpoint for accounts-receivable-ledger-mcp.
Premium agentic endpoint for actuarial-life-table-mcp.
Premium agentic endpoint for afforestation-satellite-mcp.

Eterna MCP
No-KYC managed MCP for AI agents: sandboxed TypeScript trading SDK, isolated sub-accounts, futures.

ApplyGenie
Autonomous job application copilot, ATS form filler, and AI mock interview engine.