Keyflow
Contact

Search Keyflow

Find a shortcut, workflow, MCP server or skill

postgres-mcp

local MCP server

postgres-mcp is a local MCP server: Enterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI. Install it from oci as ghcr.io/pgedge/postgres-mcp:latest.

Installation

Terminal

claude mcp add io-github-pgedge-postgres-mcp -- docker run -i --rm ghcr.io/pgedge/postgres-mcp:latest

Run in your project folder. Add --scope user to use it everywhere.

Claude Desktop, Cursor & other clients

Add to claude_desktop_config.json or .cursor/mcp.json.

{
  "mcpServers": {
    "io-github-pgedge-postgres-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/pgedge/postgres-mcp:latest"
      ]
    }
  }
}

What you need

  • Runtime: Docker.
  • MCP client: Claude Code, Codex, Antigravity, Claude Desktop, Cursor or any other client that speaks MCP over stdio.

Summary

Enterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI

postgres-mcp vs similar servers

ServerStarsTypeAPI keyRuntime
postgres-mcp230LocalNooci
Firecrawl MCP Server7,526LocalYesnpm
DBHub3,574LocalYesnpm
socraticode3,322LocalYesnpm
mcp-sap-docs233LocalNonpm

Questions

No. The registry entry lists no keys or environment variables.

Docker, plus an MCP client such as Claude Code, Codex, Claude Desktop or Cursor.

postgres-mcp is a local MCP server distributed as the oci package ghcr.io/pgedge/postgres-mcp:latest.

Run: claude mcp add io-github-pgedge-postgres-mcp -- docker run -i --rm ghcr.io/pgedge/postgres-mcp:latest

Run: codex mcp add io-github-pgedge-postgres-mcp -- docker run -i --rm ghcr.io/pgedge/postgres-mcp:latest

Similar MCP servers

NameStars
  1. Firecrawl MCP Serverio.github.firecrawl/firecrawl-mcp-server7,526
  2. DBHubio.github.bytebase/dbhub3,574
  3. socraticodeio.github.giancarloerra/socraticode3,322
  4. mcp-sap-docsio.github.marianfoo/mcp-sap-docs233
  5. shodanio.github.BurtTheCoder/shodan173
  6. shodanio.github.w0h1v/shodan173
  7. minirag-mcpio.github.sfrangulov/minirag-mcp67
  8. Vault Cortexio.github.aliasunder/vault-cortex21