Install pgops for Claude Desktop
Claude Desktop reads mcpServers from claude_desktop_config.json. Restart the app after saving.
- 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.
- Paste the JSON config below.
- Replace placeholder secrets, then restart the client if it does not reload on its own.
~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"arzharch-pgops-mcp": {
"command": "uvx",
"args": [
"pgops-mcp"
],
"env": {
"PGOPS_DSN": "YOUR_PGOPS_DSN",
"PGOPS_READONLY_DSN": "YOUR_PGOPS_READONLY_DSN",
"PGOPS_READ_ONLY": "0",
"PGOPS_APPROVAL_MODE": "0",
"PGOPS_AUDIT_LOG": "~/.pgops/audit.jsonl",
"PGOPS_DEFAULT_TIMEOUT_MS": "5000",
"PGOPS_MAX_TIMEOUT_MS": "30000",
"PGOPS_DEFAULT_ROW_LIMIT": "100"
}
}
}
}