PostgreSQL (hardened, read-only)

Install PostgreSQL (hardened, read-only) for Claude Desktop

Claude Desktop reads mcpServers from claude_desktop_config.json. Restart the app after saving.

1. Open ~/Library/Application Support/Claude/claude_desktop_config.json on macOS, %APPDATA%\Claude\claude_desktop_config.json on Windows, or ~/.config/Claude/claude_desktop_config.json on Linux.
2. Paste the JSON config below.
3. Replace placeholder secrets, then restart the client if it does not reload on its own.

{
  "mcpServers": {
    "eszetael-postgres-mcp-hardened": {
      "command": "npx",
      "args": [
        "-y",
        "postgres-mcp-hardened@0.1.10"
      ],
      "env": {
        "DATABASE_URL": "YOUR_DATABASE_URL",
        "MCP_STATEMENT_TIMEOUT": "",
        "MCP_ALLOW_TABLES": "",
        "MCP_AUDIT_LOG": ""
      }
    }
  }
}

Official Claude Desktop docs