Postgres Scout MCP Server

Install in Claude Code

claude mcp add postgres-scout -- npx -y postgres-scout-mcp read-only postgresql://localhost:5432/postgres

Install in Cursor

{
  "mcpServers": {
    "postgres-scout": {
      "command": "npx",
      "args": [
        "-y",
        "postgres-scout-mcp",
        "read-only",
        "postgresql://localhost:5432/postgres"
      ]
    }
  }
}

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

Install in Claude Desktop

{
  "mcpServers": {
    "postgres-scout": {
      "command": "npx",
      "args": [
        "-y",
        "postgres-scout-mcp",
        "read-only",
        "postgresql://localhost:5432/postgres"
      ]
    }
  }
}

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

Install in VS Code

{
  "servers": {
    "postgres-scout": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "postgres-scout-mcp",
        "read-only",
        "postgresql://localhost:5432/postgres"
      ]
    }
  }
}

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

Install in Windsurf

{
  "mcpServers": {
    "postgres-scout": {
      "command": "npx",
      "args": [
        "-y",
        "postgres-scout-mcp",
        "read-only",
        "postgresql://localhost:5432/postgres"
      ]
    }
  }
}

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