Postgres (read-only) MCP Server

by contextflo Your server? Claim it

local only

Postgres (read-only) runs on your own machine — the client starts it, so there is no endpoint to ping. 130 installs a week from npm. Last commit 28 Sep 2026.

Read-only Postgres: drop-in for the archived server-postgres, with schema context.

Installs per day peak 420 · avg 32 · -79% w/w

a month agotoday

130

Installs / week

npm · @contextflo/postgres-mcp

Stars

0 open issues

28 Sep 2026

Last commit

4 releases in 90 days

MIT

License

TypeScript

Nothing serious here today

Today is the operative word: we check Postgres (read-only) every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

Claude Code Claude Desktop Codex Cursor VS Code

run in your terminal

claude mcp add postgres-mcp -- npx -y @contextflo/postgres-mcp

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgres-mcp": {
      "args": [
        "-y",
        "@contextflo/postgres-mcp"
      ],
      "command": "npx"
    }
  }
}

~/.codex/config.toml

[mcp_servers.postgres-mcp]
command = "npx"
args = ["-y", "@contextflo/postgres-mcp"]

.cursor/mcp.json

{
  "mcpServers": {
    "postgres-mcp": {
      "args": [
        "-y",
        "@contextflo/postgres-mcp"
      ],
      "command": "npx"
    }
  }
}

.vscode/mcp.json

{
  "mcpServers": {
    "postgres-mcp": {
      "args": [
        "-y",
        "@contextflo/postgres-mcp"
      ],
      "command": "npx"
    }
  }
}

This one needs environment variables set before it will start: DATABASE_URL (Postgres connection string. Use a read-only role.). The author declared them in the registry entry; get the values from the project itself.

Alternatives to Postgres (read-only)

same job, measured the same way

AI2SQL

by ai2sql

Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema

answering

Ainative Postgres MCP

by ainative-studio

Zero-config Postgres MCP with auto-provisioning — drop-in for server-postgres.

109 installs/wk local only

Read Only Local Postgres MCP Server

by hove

MCP server for read-only PostgreSQL database queries in Claude Desktop

107 installs/wk local only

MCP Postgres Nl Query

by infoinlet-marketplace

RLS/tenant-aware Postgres for AI agents — schema, read-only SQL, NL→SQL with safety rails.

26 installs/wk local only

SQL

by abhishekkumar2021

Read-only SQL querying + schema introspection over Postgres & SQLite, with a gated write mode.

33 installs/wk local only

Archery MCP

by itzhouq

Read-only MCP server for the Archery SQL audit platform: production schema and release SQL checks

1 127 installs/wk local only

JDBC MCP Server

by igorolv

Read-only SQL, plans, schema for AI agents: PostgreSQL, Oracle, SQL Server, Firebird, SQLite, JDBC

local only

Data

by thinair

PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.

answering

Postgres (read-only) — questions

Answers built from our own checks of this server.

Why is there no uptime for Postgres (read-only)?

Postgres (read-only) runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the npm package @contextflo/postgres-mcp was installed 130 times last week.

How do I connect Postgres (read-only)?

Copy the ready config from this page — we generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each with the file path that client actually reads. It runs locally, so the command pulls @contextflo/postgres-mcp straight from npm; nothing to host, nothing to sign up for.

How many people use Postgres (read-only)?

The npm package @contextflo/postgres-mcp was installed 130 times in the last week. Week over week that is -79%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.

Is Postgres (read-only) open source?

Yes — it is published under the MIT licence, written in TypeScript and 4 stars on GitHub. The source link is on this page, so you can read exactly what it does with your data before you connect it.