x=hub

your toolset

    build deployment
    sign in

    DBeast PostgreSQL MCP

    mcpother
    io.github.snss10/dbeast · v2.0.2
    deploy just this

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

    run it

    on your own machines, one way per deploy method
    generated from the record, not tested yet
    CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
    #!/usr/bin/env bash
# dbeast (io.github.snss10/dbeast), recipe docker (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-dbeast.service.
set -euo pipefail
export HOST=127.0.0.1 PORT=8101
exec docker run --rm --name mcp-my-agent-dbeast -p 127.0.0.1:${PORT}:8000 --env-file /etc/mcp/my-agent.env ghcr.io/snss10/dbeast:2.0.2

[Unit]
Description=MCP server dbeast (toolset my-agent), generated by Hub
After=network-online.target docker.service
Wants=network-online.target

[Service]
Type=simple
User=mcp
Group=mcp
SupplementaryGroups=docker
EnvironmentFile=/etc/mcp/my-agent.env
Environment=HOME=/var/lib/mcp/dbeast
WorkingDirectory=/var/lib/mcp/dbeast
ExecStart=/opt/mcp/my-agent/bin/dbeast.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/dbeast

[Install]
WantedBy=multi-user.target
    generated from the record, not tested yet
    CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
    docker run --rm -p 127.0.0.1:8101:8000 -e DATABASE_URL -e DB_HOST -e DB_PORT -e DB_USER -e DB_PASSWORD -e DB_NAME -e AWS_SECRET_NAME -e AWS_REGION ghcr.io/snss10/dbeast:2.0.2
    generated from the record, not tested yet
    CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
    # Generated by Hub for toolset "my-agent" (2026-10-18T00:54:57+00:00).
# Each package server runs behind a stdio->HTTP bridge and listens on localhost only.
#   cp .env.example .env    # fill the ${VAR}s
#   docker compose up -d && bash smoke.sh
# Remote servers are not here: clients reach them directly (see clients/).
name: mcp-my-agent
services:
  dbeast:
    image: ghcr.io/snss10/dbeast:2.0.2
    ports:
    - 127.0.0.1:8101:8000
    restart: unless-stopped
    x-note: 'CHANGE_ME: check the image''s README for its transport and port; this assumes streamable
      HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command
      instead.'
    environment:
      DATABASE_URL: ${DATABASE_URL}
      DB_HOST: ${DB_HOST}
      DB_PORT: ${DB_PORT}
      DB_USER: ${DB_USER}
      DB_PASSWORD: ${DB_PASSWORD}
      DB_NAME: ${DB_NAME}
      AWS_SECRET_NAME: ${AWS_SECRET_NAME}
      AWS_REGION: ${AWS_REGION}
volumes:
  npm-cache: {}
  uv-cache: {}
    generated from the record, not tested yet
    CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
    # Generated by Hub for toolset "my-agent" (2026-10-18T00:54:57+00:00).
#   kubectl create namespace mcp
#   kubectl -n mcp create secret generic mcp-credentials --from-env-file=.env
#   kubectl apply -f kubernetes.yaml
# Services are cluster-internal: <name>.mcp.svc.cluster.local:8000/mcp. Put an ingress
# with auth in front before exposing any of them.
apiVersion: v1
kind: Namespace
metadata:
  name: mcp
---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: dbeast
  namespace: mcp
  labels: &id001
    app: dbeast
spec:
  replicas: 1
  selector:
    matchLabels: *id001
  template:
    metadata:
      labels: *id001
    spec:
      containers:
      - name: dbeast
        image: ghcr.io/snss10/dbeast:2.0.2
        ports:
        - containerPort: 8000
          name: http
        env:
        - name: DATABASE_URL
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DATABASE_URL
        - name: DB_HOST
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_HOST
        - name: DB_PORT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_PORT
        - name: DB_USER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_USER
        - name: DB_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_PASSWORD
        - name: DB_NAME
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_NAME
        - name: AWS_SECRET_NAME
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: AWS_SECRET_NAME
        - name: AWS_REGION
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: AWS_REGION
---
apiVersion: v1
kind: Service
metadata:
  name: dbeast
  namespace: mcp
spec:
  selector:
    app: dbeast
  ports:
  - port: 8000
    targetPort: http
    name: http
    generated from the record, not tested yet
    CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
    # Generated by Hub for toolset "my-agent" (2026-10-18T00:54:57+00:00).
# Credentials come from the Secret 'mcp-credentials' (kubectl create secret generic ... --from-env-file=.env).
# Each server under `servers` is one Deployment + Service; the keys after it configure
# upstream charts a worker verified.
servers:
  dbeast:
    enabled: true
    replicas: 1
    port: 8000
    path: /mcp
    container:
      name: dbeast
      image: ghcr.io/snss10/dbeast:2.0.2
      ports:
      - containerPort: 8000
        name: http
      env:
      - name: DATABASE_URL
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DATABASE_URL
      - name: DB_HOST
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_HOST
      - name: DB_PORT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_PORT
      - name: DB_USER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_USER
      - name: DB_PASSWORD
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_PASSWORD
      - name: DB_NAME
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_NAME
      - name: AWS_SECRET_NAME
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: AWS_SECRET_NAME
      - name: AWS_REGION
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: AWS_REGION

# helm install my-agent helm/my-agent -n mcp

    in the cloud

    one click: the provider's deploy form opens filled in, in your own account
    koyeb
    deploy to koyeb

    The form opens with CHANGE_ME for each value you supply: DATABASE_URL, DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, DB_NAME, AWS_SECRET_NAME, AWS_REGION. Fill them in before you deploy.

    Clients connect to the service's https://…koyeb.app address plus /mcp.

    azure
    deploy to azuretemplate

    A Container Apps environment with one app per server, each with HTTPS ingress and one replica. The portal asks for each value you supply as a secure parameter; the deployment's outputs list the endpoints.

    connect to it

    copy what your client needs
    docker run -i --rm -e DATABASE_URL -e DB_HOST -e DB_PORT -e DB_USER -e DB_PASSWORD -e DB_NAME -e AWS_SECRET_NAME -e AWS_REGION ghcr.io/snss10/dbeast:2.0.2
    {
  "mcpServers": {
    "dbeast": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URL",
        "-e",
        "DB_HOST",
        "-e",
        "DB_PORT",
        "-e",
        "DB_USER",
        "-e",
        "DB_PASSWORD",
        "-e",
        "DB_NAME",
        "-e",
        "AWS_SECRET_NAME",
        "-e",
        "AWS_REGION",
        "ghcr.io/snss10/dbeast:2.0.2"
      ],
      "env": {
        "DATABASE_URL": "${DATABASE_URL}",
        "DB_HOST": "${DB_HOST}",
        "DB_PORT": "${DB_PORT}",
        "DB_USER": "${DB_USER}",
        "DB_PASSWORD": "${DB_PASSWORD}",
        "DB_NAME": "${DB_NAME}",
        "AWS_SECRET_NAME": "${AWS_SECRET_NAME}",
        "AWS_REGION": "${AWS_REGION}"
      }
    }
  }
}
    #!/usr/bin/env bash
# Registers every server with Claude Code (run once; `claude mcp list` to check).
set -euo pipefail
set -a; [ -f .env ] && source .env; set +a
claude mcp add dbeast -e "DATABASE_URL=${DATABASE_URL}" -e "DB_HOST=${DB_HOST}" -e "DB_PORT=${DB_PORT}" -e "DB_USER=${DB_USER}" -e "DB_PASSWORD=${DB_PASSWORD}" -e "DB_NAME=${DB_NAME}" -e "AWS_SECRET_NAME=${AWS_SECRET_NAME}" -e "AWS_REGION=${AWS_REGION}" -- docker run -i --rm -e DATABASE_URL -e DB_HOST -e DB_PORT -e DB_USER -e DB_PASSWORD -e DB_NAME -e AWS_SECRET_NAME -e AWS_REGION ghcr.io/snss10/dbeast:2.0.2

    {
  "mcpServers": {
    "dbeast": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URL",
        "-e",
        "DB_HOST",
        "-e",
        "DB_PORT",
        "-e",
        "DB_USER",
        "-e",
        "DB_PASSWORD",
        "-e",
        "DB_NAME",
        "-e",
        "AWS_SECRET_NAME",
        "-e",
        "AWS_REGION",
        "ghcr.io/snss10/dbeast:2.0.2"
      ],
      "env": {
        "DATABASE_URL": "${DATABASE_URL}",
        "DB_HOST": "${DB_HOST}",
        "DB_PORT": "${DB_PORT}",
        "DB_USER": "${DB_USER}",
        "DB_PASSWORD": "${DB_PASSWORD}",
        "DB_NAME": "${DB_NAME}",
        "AWS_SECRET_NAME": "${AWS_SECRET_NAME}",
        "AWS_REGION": "${AWS_REGION}"
      }
    }
  }
}
    {
  "servers": {
    "dbeast": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URL",
        "-e",
        "DB_HOST",
        "-e",
        "DB_PORT",
        "-e",
        "DB_USER",
        "-e",
        "DB_PASSWORD",
        "-e",
        "DB_NAME",
        "-e",
        "AWS_SECRET_NAME",
        "-e",
        "AWS_REGION",
        "ghcr.io/snss10/dbeast:2.0.2"
      ],
      "env": {
        "DATABASE_URL": "${DATABASE_URL}",
        "DB_HOST": "${DB_HOST}",
        "DB_PORT": "${DB_PORT}",
        "DB_USER": "${DB_USER}",
        "DB_PASSWORD": "${DB_PASSWORD}",
        "DB_NAME": "${DB_NAME}",
        "AWS_SECRET_NAME": "${AWS_SECRET_NAME}",
        "AWS_REGION": "${AWS_REGION}"
      }
    }
  }
}
    name: my-agent
target: local
servers:
- hub: io.github.snss10/dbeast
    • not probed yet: tools unpinned, ingest lists them

    tools

    Not probed yetThe tools appear once the hub or its worker has listed this entry. Running it still works: your client lists them on first start.