pgEdge Postgres

listing.by

Query PostgreSQL databases from MCP clients with read-only SQL, hybrid pgvector and BM25 search, and a natural language agent.

state.local.longlisting.badge.runs_with

listing.install

listing.local.explain

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

listing.local.needs listing.local.note

act.add_to act.add_to

listing.about

Connects MCP-compatible clients to PostgreSQL 14 and higher. It runs SQL in read-only transactions by default, analyzes schemas, generates embeddings and offers hybrid search that combines pgvector, BM25 and MMR. A Natural Language Agent CLI and a React web UI let you ask questions in plain language.

Runs locally over stdio from the Docker image ghcr.io/pgedge/postgres-mcp, or from source with Go. An HTTP/HTTPS mode supports user and token authentication and TLS. You supply connection details for your own PostgreSQL database. It gives the model read access to the whole schema and data, so it suits internal and developer use rather than public-facing apps.

listing.can

Run SQL queries in read-only transactions
Analyze database schemas
Hybrid search with pgvector, BM25 and MMR
Generate embeddings
Read PostgreSQL statistics as resources
Use guided prompts for database exploration and query diagnostics
Chat with the database via CLI or web UI

listing.tools

listing.notools.local

listing.prompts

Show me the tables in my database and how they relate
Which customers placed the most orders last month?
Search my documents table for entries about refund policy
Help me diagnose why this query is slow

listing.setup.h

listing.setup.local

Claude Code

Run this in a terminal, in your project folder:

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

Start Claude Code and type /mcp. pgedge-postgres should show as connected.

Add --scope user to make it available in every project.

Claude Desktop

Open Settings → Developer → Edit Config. It opens claude_desktop_config.json. Add:

claude_desktop_config.json

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

Save the file and restart Claude Desktop.

Needs Docker on your computer. The file lives in ~/Library/Application Support/Claude/ on macOS and %APPDATA%\Claude\ on Windows.

Cursor

Add to Cursor a11y.new_tab

Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):

mcp.json

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

Needs Docker on your computer.

VS Code

Install in VS Code a11y.new_tab

Or from a terminal:

code --add-mcp '{"name":"pgedge-postgres","type":"stdio","command":"docker","args":["run","-i","--rm","ghcr.io/pgedge/postgres-mcp:latest"]}'

Or commit it to the repo in .vscode/mcp.json:

.vscode/mcp.json

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

Needs Docker on your computer.

Devin Desktop

Add it to ~/.config/devin/mcp_config.json (macOS and Linux) or %APPDATA%\devin\mcp_config.json (Windows):

mcp_config.json

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

Refresh the MCP server list in Cascade.

Devin Desktop is the new name for Windsurf.

Codex

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

Or edit ~/.codex/config.toml directly:

config.toml

[mcp_servers.pgedge-postgres]
command = "docker"
args = ["run", "-i", "--rm", "ghcr.io/pgedge/postgres-mcp:latest"]

Needs Docker on your computer.

Gemini CLI

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

This adds it to the current project. Add -s user to use it everywhere.

Any client

Most clients that start local servers accept this shape:

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

Zed puts servers under context_servers in its settings, with the same command, args and env fields.

Needs Docker on your computer.

listing.faq

Can I paste mcp.tc/i/pgedge-postgres into my MCP client?

No. pgEdge Postgres runs on your own computer, started by your client, so it has no web address to connect to. The quick link is the page to share; the install command is docker run -i --rm ghcr.io/pgedge/postgres-mcp:latest.

Does pgEdge Postgres need an API key?

No. It doesn't declare any keys or environment variables. It runs with your user account's permissions, so check what its tools can reach.

Is pgEdge Postgres a remote or a local server?

Local. Your client starts it as a process on your computer with docker run -i --rm ghcr.io/pgedge/postgres-mcp:latest, which needs Docker.

What can pgEdge Postgres do?

You can run SQL queries in read-only transactions, analyze database schemas and hybrid search with pgvector, BM25 and MMR.

Which clients can use it?

Any client that starts local servers: Claude Code, Claude Desktop, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. claude.ai and ChatGPT only connect to remote servers.

Who wrote this page?

mcp.tc's robot read pgEdge Postgres's public metadata (its package and repository pages), and an AI model drafted the text from it. A person reviews anything the checks can't confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.

listing.em.h

listing.em.lead_local listing.em.how

listing.em.badge

Markdown

[![pgEdge Postgres on mcp.tc](https://mcp.tc/i/pgedge-postgres/badge.svg)](https://mcp.tc/i/pgedge-postgres)

HTML

<a href="https://mcp.tc/i/pgedge-postgres"><img src="https://mcp.tc/i/pgedge-postgres/badge.svg" alt="pgEdge Postgres on mcp.tc" height="20"></a>

listing.em.badge_note

listing.em.widget

HTML

<script src="https://mcp.tc/w/pgedge-postgres.js" async></script>

listing.em.widget_note

iframe

HTML

<iframe src="https://mcp.tc/embed/pgedge-postgres" title="pgEdge Postgres on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>

listing.em.iframe_note