Skip to content
mcp/harbor
VS Code

Postgres DBA MCP for VS Code

io.github.a-lafon/postgres-dba-mcp

Bounded, read-only PostgreSQL access for AI assistants: nine DBA tools, compact CSV output

client:VS Code transport:stdio runtime:oci

Install Postgres DBA MCP in VS Code

.vscode/mcp.json 

{
  "inputs": [
    {
      "type": "promptString",
      "id": "database-uri",
      "description": "DATABASE_URI",
      "password": true
    }
  ],
  "servers": {
    "postgres-dba-mcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/a-lafon/postgres-dba-mcp:0.3.3"
      ],
      "env": {
        "DATABASE_URI": "${input:database-uri}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

Postgres DBA MCP in other clients

Postgres DBA MCP MCP server