Postgres (read-only)
CommunityMCP server by contextflo · updated · ★ 4 · 71 downloads a week
Read-only Postgres: drop-in for the archived server-postgres, with schema context. Postgres (read-only) is a community project by contextflo, not verified by a company domain.
Last commit 25 days ago
MIT: permissive, fine for commercial use
Clear description, published package or server URL, original repository
No risky patterns in the files we checked
What you need
| Setting | Needed | What it is |
|---|---|---|
DATABASE_Environment variable, secret | Required | Postgres connection string. Use a read-only role. |
From the publisher's entry in the official MCP Registry. Required settings are already in the install config below as placeholders.
Install Postgres (read-only)
Built from the published package, never by AIclaude mcp add postgres-read-only -e DATABASE_URL=YOUR_DATABASE_URL -- npx -y @contextflo/postgres-mcpRun in your terminal. Add --scope user to use it in every project.
{
"mcpServers": {
"postgres-read-only": {
"command": "npx",
"args": [
"-y",
"@contextflo/postgres-mcp"
],
"env": {
"DATABASE_URL": "YOUR_DATABASE_URL"
}
}
}
}Settings, Developer, Edit config. Paste into claude_desktop_config.json and restart.
Step-by-step: install Postgres (read-only) in Claude Desktop
{
"mcpServers": {
"postgres-read-only": {
"command": "npx",
"args": [
"-y",
"@contextflo/postgres-mcp"
],
"env": {
"DATABASE_URL": "YOUR_DATABASE_URL"
}
}
}
}Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project).
{
"servers": {
"postgres-read-only": {
"command": "npx",
"args": [
"-y",
"@contextflo/postgres-mcp"
],
"env": {
"DATABASE_URL": "YOUR_DATABASE_URL"
}
}
}
}Add to .vscode/mcp.json. VS Code uses "servers", not "mcpServers".
codex mcp add postgres-read-only --env DATABASE_URL=YOUR_DATABASE_URL -- npx -y @contextflo/postgres-mcp{
"mcpServers": {
"postgres-read-only": {
"command": "npx",
"args": [
"-y",
"@contextflo/postgres-mcp"
],
"env": {
"DATABASE_URL": "YOUR_DATABASE_URL"
}
}
}
}Add to ~/.gemini/config/mcp_config.json (all projects) or .agents/mcp_config.json (this project).
Step-by-step: install Postgres (read-only) in Antigravity CLI
gemini mcp add postgres-read-only npx -y @contextflo/postgres-mcpGemini CLI was replaced by Antigravity CLI in June 2026 and remains only for enterprise licences and paid API keys.
MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the postgres-read-only block.
Weekly newsletter
Like Postgres (read-only)? Get the best new MCP servers every week
The best new tools, security warnings before you install something risky, and one practical tip. Free, three minute read.
Security check
ANo download-and-run commands, hidden instructions or signs of sending keys out were found.
Checked automatically: README.md, package.json. This looks for known risky patterns and is not a full audit. How grades work
Alternatives to Postgres (read-only)
All alternatives →MCP server for interacting with the Supabase platform
Built-in MCP server for ArcadeDB multi-model database (graph, document, vector, time-series)
MCP Toolbox for Databases enables your agent to connect to your database.
MCP Toolbox for Databases enables your agent to connect to your database.
Real-time Kubernetes network traffic visibility and API analysis for HTTP, gRPC, Redis, Kafka, DNS.
Self-learning vector database for Node.js — hybrid search, Graph RAG, FlashAttention-3, HNSW, 50+ attention mechanisms
Postgres (read-only): common questions
How do I install Postgres (read-only)?
In Claude Code run claude mcp add postgres-read-only -e DATABASE_URL=YOUR_DATABASE_URL -- npx -y @contextflo/postgres-mcp. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.
Is Postgres (read-only) the official server?
Postgres (read-only) is a community project by contextflo, not verified by a company domain.
Is Postgres (read-only) free?
The code is published under the MIT licence. The service it connects to may have its own pricing.
Is Postgres (read-only) safe to use?
It scores 73 of 100. Grades: maintenance A, licence A, quality C. Security check: grade A, no risky patterns found in the files checked. Review the code before you install. How grades work.
What are alternatives to Postgres (read-only)?
Similar MCP servers: Supabase, ArcadeDB MCP Server, MCP Toolbox for Databases, MCP Toolbox for Databases.
Does Postgres (read-only) work with ChatGPT?
Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.
