PluginBench
MCP Server
Active
MIT

Postgres (read-only) MCP Server

io.github.contextflo/postgres-mcp

RepositoryRegistry
How to choose

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 Postgres (read-only) MCP server?

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

How to install Postgres (read-only)

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • DATABASE_URL
    required
    secret

    Postgres connection string. Use a read-only role.

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@contextflo/postgres-mcp"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>"
      }
    }
  }
}

Related MCP servers

Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.

View repository →

Semantic search knowledge base with serverless LanceDB. Zero setup, 100% local, 25+ file types

MCP server for CostKits: live healthcare procedure cost estimates and provider pricing.

0
JavaScript
MIT
View repository →

Connect AI agents to Couchbase clusters for natural language data exploration, querying, and management.

32
Python
Apache-2.0
View repository →

Your team's knowledge, always in context. SOPs, coding standards, and workflows for Claude.

View repository →

Persistent memory and millisecond code search for AI agents across sessions.

43
Rust
MIT
View repository →