Postgres (read-only)

MCP server · by contextflo

Databases npm v0.1.4

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

View source ↗ Website ↗ Generate config for multiple servers More servers

Install

Pin version registry version 0.1.4

npm
npx -y @contextflo/postgres-mcp

npm
npx -y @contextflo/postgres-mcp@0.1.4

Setup by client

Pick your client — the config below is generated for this server (local stdio). Copy respects the “Pin version” switch above.

claude_desktop_config.json

{
  "mcpServers": {
    "postgres-mcp-2": {
      "command": "npx",
      "args": [
        "-y",
        "@contextflo/postgres-mcp"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>"
      }
    }
  }
}

{
  "mcpServers": {
    "postgres-mcp-2": {
      "command": "npx",
      "args": [
        "-y",
        "@contextflo/postgres-mcp@0.1.4"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>"
      }
    }
  }
}

Format verified against the official Claude Desktop docs ↗.

terminal

claude mcp add --env DATABASE_URL=<YOUR_DATABASE_URL> postgres-mcp-2 -- npx -y @contextflo/postgres-mcp

claude mcp add --env DATABASE_URL=<YOUR_DATABASE_URL> postgres-mcp-2 -- npx -y @contextflo/postgres-mcp@0.1.4

Format verified against the official Claude Code docs ↗.

.cursor/mcp.json

{
  "mcpServers": {
    "postgres-mcp-2": {
      "command": "npx",
      "args": [
        "-y",
        "@contextflo/postgres-mcp"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>"
      }
    }
  }
}

{
  "mcpServers": {
    "postgres-mcp-2": {
      "command": "npx",
      "args": [
        "-y",
        "@contextflo/postgres-mcp@0.1.4"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>"
      }
    }
  }
}

Format verified against the official Cursor docs ↗.

.vscode/mcp.json

{
  "servers": {
    "postgres-mcp-2": {
      "command": "npx",
      "args": [
        "-y",
        "@contextflo/postgres-mcp"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>"
      }
    }
  }
}

{
  "servers": {
    "postgres-mcp-2": {
      "command": "npx",
      "args": [
        "-y",
        "@contextflo/postgres-mcp@0.1.4"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>"
      }
    }
  }
}

Format verified against the official VS Code docs ↗.

mcp_config.json

{
  "mcpServers": {
    "postgres-mcp-2": {
      "command": "npx",
      "args": [
        "-y",
        "@contextflo/postgres-mcp"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>"
      }
    }
  }
}

{
  "mcpServers": {
    "postgres-mcp-2": {
      "command": "npx",
      "args": [
        "-y",
        "@contextflo/postgres-mcp@0.1.4"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>"
      }
    }
  }
}

Format verified against the official Windsurf docs ↗.

Environment variables

Defined in the server's official registry manifest. Required secrets are shown as <YOUR_…> placeholders in the configs above.

DATABASE_URL required secret — Postgres connection string. Use a read-only role.

GitHub

⭐ 4 stars · 最近更新于 45 天前 · MIT license

About this server

@contextflo/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. Built and maintained by Contextflo. A drop in replacement for the archived @modelcontextprotocol/server postgr…

Summary from the project README — github.com/contextflo/postgres-mcp

Distributed as npm, listed under Databases. Review our MCP security guide before granting access to real data.

Frequently asked questions

What does the Postgres (read-only) MCP server do?

How do I install Postgres (read-only)?

Run the install command shown above, then paste the config for your client (Claude Desktop, Claude Code, Cursor, VS Code or Windsurf) into its MCP settings and restart the client.

Is Postgres (read-only) free to use?

The MCP server itself is free to install. The source is public on https://github.com/contextflo/postgres-mcp. Any third-party service it calls may require its own API key and account.

Which clients support Postgres (read-only)?

Any MCP-compatible client can use it, including Claude Desktop, Claude Code, Cursor, VS Code, Windsurf and custom agents.

Add this badge

Publish this server? Link back with a badge on your README or site — copy either snippet.

Markdown

[![Listed on MCPNav](https://mcpnav.net/badge/postgres-mcp-2.svg)](https://mcpnav.net/server/postgres-mcp-2/)

HTML

<a href="https://mcpnav.net/server/postgres-mcp-2/"><img src="https://mcpnav.net/badge/postgres-mcp-2.svg" alt="Listed on MCPNav" height="20"></a>