PostgreSQL MCP Legacy

If you specifically require the legacy Python version, clone the repository directly. No PyPI package is available for the legacy version. Be aware that this version receives no updates or security patches.

git clone https://github.com/neverinfamous/postgres-mcp-legacy.git
cd postgres-mcp-legacy
pip install -r requirements.txt

Install the actively maintained successor package using Docker or npm. The TypeScript version supports stdio and HTTP/SSE transport, OAuth 2.1, 203 tools, 20 resources, and 19 prompts.

# Docker (recommended)
docker pull writenotenow/postgres-mcp:latest

# npm global install
npm install -g @neverinfamous/postgres-mcp

# or use npx without installing
npx @neverinfamous/postgres-mcp

Set the PostgreSQL connection string as an environment variable. The server uses the standard libpq connection URI format including host, port, database name, user, and password.

export DATABASE_URL="postgresql://username:password@localhost:5432/mydb"

Update your Claude Desktop config file to include the postgresql-mcp server. On macOS the config is at ~/Library/Application Support/Claude/claude_desktop_config.json.

{
  "mcpServers": {
    "postgresql": {
      "command": "npx",
      "args": ["-y", "@neverinfamous/postgres-mcp"],
      "env": {
        "DATABASE_URL": "postgresql://username:password@localhost:5432/mydb"
      }
    }
  }
}

Restart Claude Desktop and ask Claude to list tables in the connected database. If the server connects successfully, Claude will describe the schema of your PostgreSQL instance.