Postgres (read Only)
Read-only Postgres access with schema discovery, safe SQL queries, and editable table context for MCP clients.
Install Postgres (read Only)
Pick your client, then add it in one click or paste the config.
~/Library/Application Support/Claude/claude_desktop_config.json{
"mcpServers": {
"postgres-read-only": {
"command": "npx",
"args": [
"-y",
"@contextflo/postgres-mcp"
],
"env": {
"DATABASE_URL": "YOUR_VALUE_HERE"
}
}
}
}
Settings → Developer → Edit Config, merge this into mcpServers, then fully quit and reopen Claude Desktop.
Values are written into the snippet above so you can paste it as is. They never leave your browser.
We couldn’t confirm it starts correctly
The install command started, but didn't respond the way we expected when we tried to talk to it.
npx -y @contextflo/postgres-mcpinitialize succeeded but no response to tools/list.
This is an experimental automated check and can have false negatives — missing environment variables, a slow cold install, etc. It doesn’t necessarily mean something’s wrong. Last checked .
Overview
Use cases
- Query analytics data without permitting writes
- Discover readable tables and schema relationships
- Give agents curated business definitions for database fields
- Record undocumented table and column behavior
- Inspect PostgreSQL metadata with generated SQL
Key features
- Read-only SELECT, EXPLAIN, SHOW, and CTE queries
- Table listing with name and description matching
- Schema context with keys, types, enums, and foreign keys
- Editable Markdown context file
- Read-only transaction and parser validation
- PostgreSQL schema resources
Tools4
What Postgres (read Only) lets your agent do. Expand a tool for its parameters.
Security & health
What it can reach and how reliably it runs — from our own checks, not the maintainer’s claims.
Recent health check succeeded.
Supply-chain signal
No high-severity advisories surfaced by our automated scan.
Scanned 8d ago via OSV.dev · @contextflo/postgres-mcp (npm)
Adoption & maintenance
Factual signals from GitHub, npm, and our automated checks — not a rating.
How Postgres (read Only) works
Written by AllMCPs with AI assistance from the project’s README and listing data. How we build listings
Reviews
No reviews yet — be the first to share how it worked for you.
Frequently Asked Questions about Postgres (read Only)
Related MCP servers
Add a badge to your READMEShow it’s listed — live SVG, Markdown or HTML.
AllMCPs Directory Badge
Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.
[](https://allmcps.com/mcp/postgres-read-only)<a href="https://allmcps.com/mcp/postgres-read-only"><img src="https://allmcps.com/api/badge/postgres-read-only?style=directory" alt="Postgres (read Only) on AllMCPs" /></a>