1. Home
  2. Postgres MCP Pro
  3. Postgres MCP Pro for Claude Code: Setup & Config

Data as of

Postgres MCP Pro for Claude Code: Setup & Config

Give Claude Code PostgreSQL schema access, SQL execution, health checks, and performance analysis.

Postgres MCP Pro Claude Code configuration

  1. Choose Claude Code configuration scope

    For Postgres MCP Pro, open Project scope: .mcp.json at the repository root. Project JSON: merge into mcpServers; user scope: use the CLI.

  2. Add Postgres MCP Pro to Claude Code

    Use the postgres-mcp entry below in mcpServers. Keep Postgres MCP Pro's documented stdio connection fields and your other Claude Code entries.

  3. Check Postgres MCP Pro in Claude Code

    Postgres MCP Pro: Inspect claude mcp list and /mcp status.

Config file · Project scope: .mcp.json at the repository root

JSON
{
  "mcpServers": {
    "postgres-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "postgres-mcp",
        "--access-mode=restricted"
      ],
      "env": {
        "DATABASE_URI": "<PostgreSQL connection URI with your database credentials>"
      }
    }
  }
}

CLI (POSIX shell)
claude mcp add-json --scope project 'postgres-mcp' '{"type":"stdio","command":"uvx","args":["postgres-mcp","--access-mode=restricted"],"env":{"DATABASE_URI":"<PostgreSQL connection URI with your database credentials>"}}'

Postgres MCP Pro in Claude Code: stdio checks

  • If Postgres MCP Pro fails to start, check uvx postgres-mcp (from uv, for Python tools), the working directory, and Claude Code's selected scope; inspect claude mcp list and /mcp.
  • Postgres MCP Pro: check DATABASE_URI; keep credentials out of shared .mcp.json.
  • Postgres MCP Pro uses stdio here: Claude Code must keep the configured process running; protocol output belongs on stdout and diagnostics on stderr.
Tools
list_schemas, list_objects, get_object_details

Postgres MCP Pro — details. Claude Code guide

Frequently asked questions

Register Postgres MCP Pro with the displayed claude mcp add-json --scope project command, or merge the JSON into .mcp.json at the repository root.

Claude Code's postgres-mcp example uses stdio.

Postgres MCP Pro's Claude Code configuration invokes uvx postgres-mcp (from uv, for Python tools).

Claude Code's Postgres MCP Pro example references DATABASE_URI. Check these names if startup or authentication fails; the example alone does not distinguish required from optional values.

Postgres MCP Pro's stored list contains 9 tools, including list_schemas, list_objects, get_object_details. Compare those names with Claude Code's connected tool list; the stored list is not a live check.