Skip to content
VS Code

DBeast PostgreSQL MCP for VS Code

io.github.snss10/dbeast

PostgreSQL MCP server for schema, query, health, security, and performance analysis.

client:VS Code transport:stdio runtime:oci

Install DBeast PostgreSQL MCP in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "database-url",
      "description": "DATABASE_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-host",
      "description": "DB_HOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-port",
      "description": "DB_PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-user",
      "description": "DB_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-password",
      "description": "DB_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-name",
      "description": "DB_NAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "aws-secret-name",
      "description": "AWS_SECRET_NAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "aws-region",
      "description": "AWS_REGION",
      "password": true
    }
  ],
  "servers": {
    "dbeast": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/snss10/dbeast:2.0.2"
      ],
      "env": {
        "DATABASE_URL": "${input:database-url}",
        "DB_HOST": "${input:db-host}",
        "DB_PORT": "${input:db-port}",
        "DB_USER": "${input:db-user}",
        "DB_PASSWORD": "${input:db-password}",
        "DB_NAME": "${input:db-name}",
        "AWS_SECRET_NAME": "${input:aws-secret-name}",
        "AWS_REGION": "${input:aws-region}"
      }
    }
  }
}

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

DBeast PostgreSQL MCP in other clients