Postgres Aiops MCP server
{
"mcpServers": {
"aiops-tools-postgres-aiops": {
"command": "uvx",
"args": [
"postgres-aiops"
],
"env": {
"POSTGRES_AIOPS_MASTER_PASSWORD": "postgresql://user:password@host:5432/db"
}
}
}
}{
"mcpServers": {
"aiops-tools-postgres-aiops": {
"command": "uvx",
"args": [
"postgres-aiops"
],
"env": {
"POSTGRES_AIOPS_MASTER_PASSWORD": "postgresql://user:password@host:5432/db"
}
}
}
}{
"mcpServers": {
"aiops-tools-postgres-aiops": {
"command": "uvx",
"args": [
"postgres-aiops"
],
"env": {
"POSTGRES_AIOPS_MASTER_PASSWORD": "postgresql://user:password@host:5432/db"
}
}
}
}{
"servers": {
"aiops-tools-postgres-aiops": {
"command": "uvx",
"args": [
"postgres-aiops"
],
"env": {
"POSTGRES_AIOPS_MASTER_PASSWORD": "${input:postgres_aiops_master_password}"
}
}
},
"inputs": [
{
"id": "postgres_aiops_master_password",
"type": "promptString",
"description": "Postgres aiops master password",
"password": true
}
]
}{
"mcpServers": {
"aiops-tools-postgres-aiops": {
"command": "uvx",
"args": [
"postgres-aiops"
],
"env": {
"POSTGRES_AIOPS_MASTER_PASSWORD": "postgresql://user:password@host:5432/db"
}
}
}
}file .mcp.json (in your project root)file claude_desktop_config.jsonfile ~/.cursor/mcp.jsonfile .vscode/mcp.jsonfile ~/.codeium/windsurf/mcp_config.jsoninstall uvx postgres-aiopsversion 0.9.0
Governed PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 35 MCP tools.
Before you enable it
An MCP server runs with whatever access you give it. Start with a development account rather than production, and check which tools the server exposes before you let an agent call them unattended.