PostgreSQL MCP Server

Install in Claude Code

claude mcp add mdev-postgresql -e POSTGRES_HOST=localhost -e POSTGRES_PORT=5432 -e POSTGRES_USER='<postgres-user>' -e POSTGRES_PASSWORD='<postgres-password>' -e POSTGRES_DB='<postgres-db>' -- uvx mdev-postgresql-mcp-server

Install in Cursor

{
  "mcpServers": {
    "mdev-postgresql": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "<postgres-user>",
        "POSTGRES_PASSWORD": "<postgres-password>",
        "POSTGRES_DB": "<postgres-db>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

Install in Claude Desktop

{
  "mcpServers": {
    "mdev-postgresql": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "<postgres-user>",
        "POSTGRES_PASSWORD": "<postgres-password>",
        "POSTGRES_DB": "<postgres-db>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

Install in VS Code

{
  "servers": {
    "mdev-postgresql": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "<postgres-user>",
        "POSTGRES_PASSWORD": "<postgres-password>",
        "POSTGRES_DB": "<postgres-db>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

Install in Windsurf

{
  "mcpServers": {
    "mdev-postgresql": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "<postgres-user>",
        "POSTGRES_PASSWORD": "<postgres-password>",
        "POSTGRES_DB": "<postgres-db>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.