How do I set up the PostgreSQL MCP server?

Add the PostgreSQL server to your MCP config using the command: npx with the package @modelcontextprotocol/server-postgres. See the full config below.

What does the PostgreSQL MCP server do?

Query and introspect PostgreSQL databases. Connection string is passed as an argument.

PostgreSQL MCP Server — Config Template & Setup Guide

claude_desktop_config.json

{
  "mcpServers": {
    "server-postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/mydb"
      ]
    }
  }
}

Setup Instructions

Ensure Node.js 18+ is installed on your system.
Copy the config block above into your claude_desktop_config.json file (typically at ~/.config/claude/claude_desktop_config.json on macOS/Linux or %APPDATA%\Claude\claude_desktop_config.json on Windows).
Restart your AI client to apply the config.

claude_desktop_config.json

Setup Instructions

Related Servers