Postgres AIops for VS Code

io.github.aiops-tools/postgres-aiops

Governed PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 35 MCP tools.

client:VS Code transport:stdio runtime:pypi

Install Postgres AIops in VS Code

.vscode/mcp.json

{
  "servers": {
    "postgres-aiops": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "postgres-aiops"
      ]
    }
  }
}

Requires agent mode. MCP: Open User Configuration puts the same block in every workspace. VS Code docs