x=hub

your toolset

    build deployment
    sign in

    mcp-server-motherduck

    mcpkey · package
    io.github.motherduckdb/mcp-server-motherduck · v1.1.0
    deploy just this

    SQL analytics and data engineering for AI Assistants and IDEs

    run it

    on your own machines, one way per deploy method
    generated from the record, not tested yet
    # once, as root:
# as_mcp DIR COMMAND...: runs COMMAND as the mcp user in DIR, its home, sandboxed as the
# units are: a package's install scripts can write to DIR only, as the server later can
as_mcp() {
  local dir="$1"; shift
  systemd-run --quiet --wait --pipe --collect --uid=mcp --gid=mcp \
    -p WorkingDirectory="$dir" -p Environment=HOME="$dir" -p ReadWritePaths="$dir" \
    -p NoNewPrivileges=true -p ProtectSystem=strict -p ProtectHome=true -p PrivateTmp=true \
    -- "$@" </dev/null
}
install -d -m 0750 -o mcp -g mcp /var/lib/mcp/motherduck
# motherduck: its packages, installed whole before its unit starts (no session installs)
systemctl stop mcp-my-agent-motherduck.service 2>/dev/null || true
as_mcp /var/lib/mcp/motherduck uv tool install mcp-server-motherduck==1.1.0
as_mcp /var/lib/mcp/motherduck uv tool install mcp-proxy

#!/usr/bin/env bash
# motherduck (io.github.motherduckdb/mcp-server-motherduck), recipe baremetal (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-motherduck.service.
set -euo pipefail
export HOST=127.0.0.1 PORT=8101
exec uvx mcp-proxy --host 127.0.0.1 --port 8101 --pass-environment -- uvx mcp-server-motherduck==1.1.0

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

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

[Install]
WantedBy=multi-user.target
    generated from the record, not tested yet
    docker run --rm -p 127.0.0.1:8101:8000 -e motherduck_token -e MOTHERDUCK_TOKEN -e HOME -e AWS_ACCESS_KEY_ID -e AWS_SECRET_ACCESS_KEY -e AWS_SESSION_TOKEN -e AWS_DEFAULT_REGION -e AWS_ENDPOINT ghcr.io/astral-sh/uv:python3.12-bookworm-slim sh -c 'uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx mcp-server-motherduck==1.1.0'
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-19T00:50:34+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:
  motherduck:
    image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
    command:
    - sh
    - -c
    - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx mcp-server-motherduck==1.1.0
    ports:
    - 127.0.0.1:8101:8000
    volumes:
    - uv-cache:/root/.cache/uv
    healthcheck:
      test:
      - CMD
      - python3
      - -c
      - import urllib.request; urllib.request.urlopen('http://127.0.0.1:8000/status')
      interval: 30s
      timeout: 5s
      retries: 5
      start_period: 2m
    restart: unless-stopped
    environment:
      motherduck_token: ${motherduck_token}
      MOTHERDUCK_TOKEN: ${MOTHERDUCK_TOKEN}
      HOME: ${HOME}
      AWS_ACCESS_KEY_ID: ${AWS_ACCESS_KEY_ID}
      AWS_SECRET_ACCESS_KEY: ${AWS_SECRET_ACCESS_KEY}
      AWS_SESSION_TOKEN: ${AWS_SESSION_TOKEN}
      AWS_DEFAULT_REGION: ${AWS_DEFAULT_REGION}
      AWS_ENDPOINT: ${AWS_ENDPOINT}
volumes:
  npm-cache: {}
  uv-cache: {}
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-19T00:50:34+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: motherduck
  namespace: mcp
  labels: &id001
    app: motherduck
spec:
  replicas: 1
  selector:
    matchLabels: *id001
  template:
    metadata:
      labels: *id001
    spec:
      containers:
      - name: motherduck
        image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
        ports:
        - containerPort: 8000
          name: http
        env:
        - name: motherduck_token
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: motherduck_token
        - name: MOTHERDUCK_TOKEN
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MOTHERDUCK_TOKEN
        - name: HOME
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: HOME
        - name: AWS_ACCESS_KEY_ID
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: AWS_ACCESS_KEY_ID
        - name: AWS_SECRET_ACCESS_KEY
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: AWS_SECRET_ACCESS_KEY
        - name: AWS_SESSION_TOKEN
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: AWS_SESSION_TOKEN
        - name: AWS_DEFAULT_REGION
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: AWS_DEFAULT_REGION
        - name: AWS_ENDPOINT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: AWS_ENDPOINT
        args:
        - sh
        - -c
        - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx mcp-server-motherduck==1.1.0
        readinessProbe:
          httpGet:
            path: /status
            port: http
          initialDelaySeconds: 10
---
apiVersion: v1
kind: Service
metadata:
  name: motherduck
  namespace: mcp
spec:
  selector:
    app: motherduck
  ports:
  - port: 8000
    targetPort: http
    name: http
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-19T00:50:34+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:
  motherduck:
    enabled: true
    replicas: 1
    port: 8000
    path: /mcp
    container:
      name: motherduck
      image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
      ports:
      - containerPort: 8000
        name: http
      env:
      - name: motherduck_token
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: motherduck_token
      - name: MOTHERDUCK_TOKEN
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MOTHERDUCK_TOKEN
      - name: HOME
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: HOME
      - name: AWS_ACCESS_KEY_ID
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: AWS_ACCESS_KEY_ID
      - name: AWS_SECRET_ACCESS_KEY
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: AWS_SECRET_ACCESS_KEY
      - name: AWS_SESSION_TOKEN
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: AWS_SESSION_TOKEN
      - name: AWS_DEFAULT_REGION
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: AWS_DEFAULT_REGION
      - name: AWS_ENDPOINT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: AWS_ENDPOINT
      args:
      - sh
      - -c
      - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx mcp-server-motherduck==1.1.0
      readinessProbe:
        httpGet:
          path: /status
          port: http
        initialDelaySeconds: 10

# 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: motherduck_token, MOTHERDUCK_TOKEN, HOME, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, AWS_DEFAULT_REGION, AWS_ENDPOINT. 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
    uvx mcp-server-motherduck==1.1.0
# env: motherduck_token, MOTHERDUCK_TOKEN, HOME, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, AWS_DEFAULT_REGION, AWS_ENDPOINT
    {
  "mcpServers": {
    "motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck==1.1.0"
      ],
      "env": {
        "motherduck_token": "${motherduck_token}",
        "MOTHERDUCK_TOKEN": "${MOTHERDUCK_TOKEN}",
        "HOME": "${HOME}",
        "AWS_ACCESS_KEY_ID": "${AWS_ACCESS_KEY_ID}",
        "AWS_SECRET_ACCESS_KEY": "${AWS_SECRET_ACCESS_KEY}",
        "AWS_SESSION_TOKEN": "${AWS_SESSION_TOKEN}",
        "AWS_DEFAULT_REGION": "${AWS_DEFAULT_REGION}",
        "AWS_ENDPOINT": "${AWS_ENDPOINT}"
      }
    }
  }
}
    #!/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 motherduck -e "motherduck_token=${motherduck_token}" -e "MOTHERDUCK_TOKEN=${MOTHERDUCK_TOKEN}" -e "HOME=${HOME}" -e "AWS_ACCESS_KEY_ID=${AWS_ACCESS_KEY_ID}" -e "AWS_SECRET_ACCESS_KEY=${AWS_SECRET_ACCESS_KEY}" -e "AWS_SESSION_TOKEN=${AWS_SESSION_TOKEN}" -e "AWS_DEFAULT_REGION=${AWS_DEFAULT_REGION}" -e "AWS_ENDPOINT=${AWS_ENDPOINT}" -- uvx mcp-server-motherduck==1.1.0

    {
  "mcpServers": {
    "motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck==1.1.0"
      ],
      "env": {
        "motherduck_token": "${motherduck_token}",
        "MOTHERDUCK_TOKEN": "${MOTHERDUCK_TOKEN}",
        "HOME": "${HOME}",
        "AWS_ACCESS_KEY_ID": "${AWS_ACCESS_KEY_ID}",
        "AWS_SECRET_ACCESS_KEY": "${AWS_SECRET_ACCESS_KEY}",
        "AWS_SESSION_TOKEN": "${AWS_SESSION_TOKEN}",
        "AWS_DEFAULT_REGION": "${AWS_DEFAULT_REGION}",
        "AWS_ENDPOINT": "${AWS_ENDPOINT}"
      }
    }
  }
}
    {
  "servers": {
    "motherduck": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-motherduck==1.1.0"
      ],
      "env": {
        "motherduck_token": "${motherduck_token}",
        "MOTHERDUCK_TOKEN": "${MOTHERDUCK_TOKEN}",
        "HOME": "${HOME}",
        "AWS_ACCESS_KEY_ID": "${AWS_ACCESS_KEY_ID}",
        "AWS_SECRET_ACCESS_KEY": "${AWS_SECRET_ACCESS_KEY}",
        "AWS_SESSION_TOKEN": "${AWS_SESSION_TOKEN}",
        "AWS_DEFAULT_REGION": "${AWS_DEFAULT_REGION}",
        "AWS_ENDPOINT": "${AWS_ENDPOINT}"
      }
    }
  }
}
    name: my-agent
target: local
servers:
- hub: io.github.motherduckdb/mcp-server-motherduck
    • not probed yet: tools unpinned, ingest lists them

    tools

    Probe result: needs authdocker: credentials=placeholder: the container exited: | Exception Group Traceback (most recent call last): | …lbus-hub-worker-placeholder/.cache/uv/archive-v0/Vu-si0SJYizbOoOWkl1wT/lib/python3.12/site-packages/anyio/_backends/_asyncio.py", line 847, in __aexit__ | raise BaseExceptionGroup( | ExceptionGroup: unhandled errors in a TaskGroup (1 sub-exception) +-+---------------- 1 ---------------- | Traceback (most recent call last): | File "/<secret>/.cache/uv/archive-v0/Vu-si0SJYizbOoOWkl1wT/lib/python3.12/site-packages/mcp_proxy/mcp_server.py", line 194, in run_mcp_server | proxy = await create_proxy_server(session) | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | File "/<secret>/.cache/uv/archive-v0/Vu-si0SJYizbOoOWkl1wT/lib/python3.12/site-packages/mcp_proxy/proxy_server.py", line 19, in create_proxy_server | response = await remote_app.initialize() | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | File "/<secret>/.cache/uv/archive-v0/Vu-si0SJYizbOoOWkl1wT/lib/python3.12/site-packages/mcp/client/session.py", line 183, in initialize | result = await self.send_request( | ^^^^^^^^^^^^^^^^^^^^^^^^ | File "/<secret>/.cache/uv/archive-v0/Vu-si0SJYizbOoOWkl1wT/lib/python3.12/site-packages/mcp/shared/session.py", line 306, in send_request | raise McpError(response_or_error.error) | mcp.shared.exceptions.McpError: Connection closed +------------------------------------; baremetal: same crash as docker

    runs · 1

    the latest tests of this entry by the hub and its workers, newest first
    dateworkermethodstatussandboxreason
    2026-10-18 19:49 local-mac-vm docker needs auth gvisor docker: credentials=placeholder: the container exited: | Exception Group Traceback (most recent call last): | …lbus-hub-worker-placeholder/.cache/uv/archive-v0/…