PGAuditor for VS Code

com.mcpgatepro/pgauditor

Hosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure.

client:VS Code transport:streamable-http

Install PGAuditor in VS Code

.vscode/mcp.json

{
  "servers": {
    "pgauditor": {
      "type": "http",
      "url": "https://api.mcpgatepro.com/mcp/pgauditor"
    }
  }
}

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