$ timeahead.in

mcp/pg-mcp-server/install

install pg-mcp-server

pick your MCP client below. snippets, file paths and reload steps included.

source: extracted from upstream README — github.com/ericzakariasson/pg-mcp-server

paste into

macos: ~/Library/Application Support/Claude/claude_desktop_config.json

windows: %APPDATA%\Claude\claude_desktop_config.json

linux: ~/.config/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "--yes",
        "pg-mcp-server",
        "--transport",
        "stdio"
      ],
      "env": {
        "DATABASE_URL": "postgresql://postgres:postgres@localhost:5432/postgres"
      }
    }
  }
}

then: Quit Claude Desktop completely (Cmd/Ctrl+Q) and reopen it.

prefer a direct link? /mcp/pg-mcp-server/install/claude-desktop →

← back to pg-mcp-server