pgEdge Postgres
MCP server by pgEdge
Query PostgreSQL databases from MCP clients with read-only SQL, hybrid pgvector and BM25 search, and a natural language agent.
Install pgEdge Postgres
Runs on your machine. Your client starts it with this command:
Needs Docker on your computer. The setup steps below show where the command goes in each client.
Share this server
Opens this page, with the install command and setup steps.
mcp.tc/i/pgedge-postgresAbout
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.
What you can do
- 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
Tools
Local servers list their tools once they’re running, and this one doesn’t publish its list in advance. Your client shows them after you add it.
Example 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
Set up
Every client starts pgEdge Postgres on your machine with the same command. Pick yours; the page remembers your choice.
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:
{
"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 (opens in a new tab)
Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):
{
"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 (opens in a 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:
{
"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):
{
"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:latestOr edit ~/.codex/config.toml directly:
[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:latestThis 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.
Embed
Show pgEdge Postgres in a README or on your site. Each embed links to this page, uses the server’s own install command, and sets no cookies. How embeds work
The card, the iframe and the JSON are in English. Add ?lang=it, fr, de or es to their address for another language.
README badge
[](https://mcp.tc/i/pgedge-postgres)<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>It follows the reader’s light or dark mode. Add ?theme=light or ?theme=dark to fix it, or ?style=compact to show the mark without the word.
Website card
<script src="https://mcp.tc/w/pgedge-postgres.js" async></script>The card appears where the tag is. Add data-theme="dark" or data-size="compact" to the tag to change it. The file holds everything it needs, so it makes no other requests and sets no cookies.
iframe
<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>Use it on pages that don’t allow scripts. Add ?theme=light or ?theme=dark to the address to fix the colors.
JSON
The listing as data for your own pages and tools: name, tagline, install command, tools and the “Add to” links. Any site can read it (CORS is open).
https://mcp.tc/i/pgedge-postgres.jsonAI prompt
Paste this into an AI coding assistant, such as Claude Code or Cursor, and it adds the pgEdge Postgres card to your site.
Add the mcp.tc card for pgEdge Postgres, an MCP server, to my website. It is one static script: no build step, no package to install, no cookies.
Put this tag where the card should appear. The card renders right before it:
```html
<script src="https://mcp.tc/w/pgedge-postgres.js" async></script>
```
To show the card somewhere else, put this placeholder there and load the same script once, for example before `</body>`. Keep the link inside: visitors without JavaScript see it.
```html
<div data-mcptc="pgedge-postgres"><a href="https://mcp.tc/i/pgedge-postgres">pgEdge Postgres on mcp.tc</a></div>
```
Options:
- `data-theme="light"` or `"dark"` on the tag or the placeholder fixes the colors. Without it, the card follows the visitor’s light or dark mode.
- `data-size="compact"` gives a smaller card without the tagline.
- The CSS variable `--mcptc-max-width` on the placeholder or a parent sets the width (default `520px`).
- `?lang=` on the script URL sets the card’s language: `en`, `it`, `fr`, `de` or `es`.
If the site has a Content Security Policy, allow `script-src https://mcp.tc` and `img-src data:` (the icon is inline).
For a README or other Markdown docs, use the badge instead:
```markdown
[](https://mcp.tc/i/pgedge-postgres)
```
Reference: https://mcp.tc/embedChange history
It runs on your computer and has no package we can follow. Edits by its owner show up here.
Nothing recorded yet. Edits by the server’s owner will show up here.
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.
Does mcp.tc track changes to pgEdge Postgres?
Partly. pgEdge Postgres runs on your computer and has no package we can follow, so its History tab shows only edits by its owner. Follow the listing to get an email when it changes.
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.
mcp.tc isn’t affiliated with pgEdge. This page was built from pgEdge Postgres’s public metadata, last checked on 4 Oct 2026, and an AI model wrote the description, so it can be wrong. Names and marks belong to their owners. Something off? Report this listing.