📡 MCP Radar

contextflo/postgres-mcp

Read-only Postgres MCP server: a drop-in replacement for the archived server-postgres, with schema context for correct answers.

⭐ 4 stars
⑂ 0 forks
TypeScript
momentum ▲ 8.0
created 2026-09-26
on radar since 2026-09-29
star trend 3 → 4 since 2026-09-29
mcpmcp-servermodel-context-protocolpostgrespostgresql
View on GitHub ↗Homepage ↗

About postgres-mcp

The analytics MCP server for Postgres. Read-only by construction, with a context file you and the agent both write to, so the model answers the way your team would.

A drop-in replacement for the archived @modelcontextprotocol/server-postgres, which shipped with a SQL injection vulnerability that let COMMIT; DROP SCHEMA public CASCADE walk straight out of its read-only transaction.

Watch the 100-second demo: setup, the agent working out that an events table is not what it looks like and saving that as a note, and a DROP the server refuses.

Read-only that holds up. The archived server enforced read-only as a property of the SQL string. Here it is a property of the wire protocol, the connection, the Postgres parser, and the database role: four independent layers, each of which stops that payload on its own. The exploit is a test case in this repo.

Answers that make sense. A model that does not know fctordersv2 is the table your team actually uses, or that revenue is gross rather than net, writes confident, wrong SQL. .contextflo/context.md is a markdown file you edit and this server hands to the model, with nothing behind it but the file. The agent adds to it too: when it learns something the schema does not say, addtablecontext appends a note, which you review in a diff like any other change.

1. Create a read-only role. Run this as the database owner, in psql or your provider's SQL editor. Use your database name and a real password, and repeat the schema lines for each schema the agent should see:

From the project README.

Maintaining this server?

Add the radar badge to your README — it shows your project was picked up by MCP Radar and links to this page:

[![On MCP Radar](https://mcp.liqiwa.com/badge.svg)](https://mcp.liqiwa.com/s/contextflo--postgres-mcp.html)

Related MCP servers

cristipufu/culprit-sql-studio

Find what's slowing your database down: a free desktop app, CLI and MCP server for SQL Server, PostgreSQL, MySQL and MariaDB performance (slow queries, execution plans, indexes, blocking, deadlocks).

⭐ 6Rust
soma-intelligence/open-health-sync

Self-hosted, open-source API for wearable and health data, in Go. Syncs Apple Health, Health Connect, Oura, WHOOP, Withings, Strava, Fitbit, Dexcom and more into one model, served over REST, FHIR R4,

⭐ 5Go
systempromptio/systemprompt-demo

AI Governance Infrastructure — open gateway demo. Self-hosted systemprompt.io gateway in a single Rust binary: policy, audit trails, and cost attribution on every AI request, with the Systemprompt Bri

⭐ 3Rust
herry2059/project-os-for-codex

Open-source control plane for Codex projects: Git-backed context, visible agent progress, scoped MCP access, resumable work, and safe handoffs.

⭐ 104TypeScript
Cripacx/mediagen

AI image and video generation skill for Claude Code and other coding agents — Gemini, OpenAI and Kie AI behind one CLI and MCP server, with EU AI Act content marking.

⭐ 56TypeScript
PerryLink/jevcore

TypeSafe Jev for DeepSeek Harness, the Model Context Protocol, and plain Node: typed judgments instead of prose, offline by default.

⭐ 38TypeScript

📬 Get the weekly radar in your inbox

The top new MCP servers of the week, every Monday. No spam, unsubscribe anytime.