Postgres MCP Pro

Claude Code

1. Run this in a terminal, in your project folder:

claude mcp add --transport stdio postgres -- uvx postgres-mcp --access-mode=restricted

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

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

Claude Desktop

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

{
  "mcpServers": {
    "postgres": {
      "command": "uvx",
      "args": [
        "postgres-mcp",
        "--access-mode=restricted"
      ]
    }
  }
}

1. Save the file and restart Claude Desktop.

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

Cursor

Zu Cursor hinzufügen (öffnet in einem neuen Tab)

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

{
  "mcpServers": {
    "postgres": {
      "command": "uvx",
      "args": [
        "postgres-mcp",
        "--access-mode=restricted"
      ]
    }
  }
}

Needs uv (Python) on your computer.

VS Code

Install in VS Code (öffnet in einem neuen Tab)

Or from a terminal:

code --add-mcp '{"name":"postgres","type":"stdio","command":"uvx","args":["postgres-mcp","--access-mode=restricted"]}'

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

{
  "servers": {
    "postgres": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "postgres-mcp",
        "--access-mode=restricted"
      ]
    }
  }
}

Needs uv (Python) on your computer.

Devin Desktop

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

{
  "mcpServers": {
    "postgres": {
      "command": "uvx",
      "args": [
        "postgres-mcp",
        "--access-mode=restricted"
      ]
    }
  }
}

1. Refresh the MCP server list in Cascade.

Devin Desktop is the new name for Windsurf.

Codex

codex mcp add postgres -- uvx postgres-mcp --access-mode=restricted

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

[mcp_servers.postgres]
command = "uvx"
args = ["postgres-mcp", "--access-mode=restricted"]

Needs uv (Python) on your computer.

Gemini CLI

gemini mcp add postgres uvx -- postgres-mcp --access-mode=restricted

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": {
    "postgres": {
      "command": "uvx",
      "args": [
        "postgres-mcp",
        "--access-mode=restricted"
      ]
    }
  }
}

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

Needs uv (Python) on your computer.

README-Badge

[![Postgres MCP Pro on mcp.tc](https://mcp.tc/i/postgres/badge.svg)](https://mcp.tc/i/postgres)

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

Es folgt dem hellen oder dunklen Modus der Lesenden. Hänge ?theme=light oder ?theme=dark an, um ihn festzulegen, oder ?style=compact, um das Zeichen ohne Schriftzug zu zeigen.

Website-Karte

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

Die Karte erscheint dort, wo das Tag steht. Füge dem Tag data-theme="dark" oder data-size="compact" hinzu, um sie zu ändern. Die Datei enthält alles, was sie braucht, stellt also keine weiteren Anfragen und setzt keine Cookies.

iframe

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

Nutze es auf Seiten, die keine Skripte erlauben. Hänge ?theme=light oder ?theme=dark an die Adresse an, um die Farben festzulegen.

JSON

Der Eintrag als Daten für deine eigenen Seiten und Tools: Name, Kurzbeschreibung, Installationsbefehl, Tools und die „Add to“-Links. Jede Website kann ihn lesen (CORS ist offen).

https://mcp.tc/i/postgres.json

Was jedes Feld bedeutet