x=hub

your toolset

    build deployment
    sign in

    warehouse-mcp

    mcpkey · package
    io.github.kalehdoo/warehouse-mcp · v0.4.2
    deploy just this

    Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.

    run it

    on your own machines, one way per deploy method
    generated from the record, not tested yet
    #!/usr/bin/env bash
# warehouse (io.github.kalehdoo/warehouse-mcp), recipe baremetal (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-warehouse.service.
set -euo pipefail
export HOST=127.0.0.1 PORT=8101
exec npx -y supergateway@4 --stdio 'npx -y [email protected]' --outputTransport streamableHttp --stateful --host 127.0.0.1 --port 8101 --streamableHttpPath /mcp --healthEndpoint /healthz

[Unit]
Description=MCP server warehouse (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/warehouse
WorkingDirectory=/var/lib/mcp/warehouse
ExecStart=/opt/mcp/my-agent/bin/warehouse.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/warehouse

[Install]
WantedBy=multi-user.target
    generated from the record, not tested yet
    docker run --rm -p 127.0.0.1:8101:8000 -e MCP_TRANSPORT -e WAREHOUSE_TYPE -e MCP_API_KEYS -e DUCKDB_PATH -e MOTHERDUCK_TOKEN -e PG_HOST -e PG_DATABASE -e PG_USER -e PG_PASSWORD -e ORACLE_USER -e ORACLE_PASSWORD -e ORACLE_CONNECT_STRING -e SNOWFLAKE_ACCOUNT -e SNOWFLAKE_USER -e SNOWFLAKE_PRIVATE_KEY_PATH -e BIGQUERY_PROJECT -e GOOGLE_APPLICATION_CREDENTIALS -e GUARDRAIL_PII_MASK -e MCP_RATE_LIMIT_RPM node:22-alpine sh -c 'npx -y supergateway@4 --stdio '"'"'npx -y [email protected]'"'"' --outputTransport streamableHttp --stateful --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz'
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T13:23:49+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:
  warehouse:
    image: node:22-alpine
    command:
    - sh
    - -c
    - npx -y supergateway@4 --stdio 'npx -y [email protected]' --outputTransport streamableHttp --stateful
      --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz
    ports:
    - 127.0.0.1:8101:8000
    volumes:
    - npm-cache:/root/.npm
    healthcheck:
      test:
      - CMD-SHELL
      - wget -qO- http://127.0.0.1:8000/healthz || exit 1
      interval: 30s
      timeout: 5s
      retries: 5
      start_period: 2m
    restart: unless-stopped
    environment:
      MCP_TRANSPORT: ${MCP_TRANSPORT}
      WAREHOUSE_TYPE: ${WAREHOUSE_TYPE}
      MCP_API_KEYS: ${MCP_API_KEYS}
      DUCKDB_PATH: ${DUCKDB_PATH}
      MOTHERDUCK_TOKEN: ${MOTHERDUCK_TOKEN}
      PG_HOST: ${PG_HOST}
      PG_DATABASE: ${PG_DATABASE}
      PG_USER: ${PG_USER}
      PG_PASSWORD: ${PG_PASSWORD}
      ORACLE_USER: ${ORACLE_USER}
      ORACLE_PASSWORD: ${ORACLE_PASSWORD}
      ORACLE_CONNECT_STRING: ${ORACLE_CONNECT_STRING}
      SNOWFLAKE_ACCOUNT: ${SNOWFLAKE_ACCOUNT}
      SNOWFLAKE_USER: ${SNOWFLAKE_USER}
      SNOWFLAKE_PRIVATE_KEY_PATH: ${SNOWFLAKE_PRIVATE_KEY_PATH}
      BIGQUERY_PROJECT: ${BIGQUERY_PROJECT}
      GOOGLE_APPLICATION_CREDENTIALS: ${GOOGLE_APPLICATION_CREDENTIALS}
      GUARDRAIL_PII_MASK: ${GUARDRAIL_PII_MASK}
      MCP_RATE_LIMIT_RPM: ${MCP_RATE_LIMIT_RPM}
volumes:
  npm-cache: {}
  uv-cache: {}
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T13:23:49+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: warehouse
  namespace: mcp
  labels: &id001
    app: warehouse
spec:
  replicas: 1
  selector:
    matchLabels: *id001
  template:
    metadata:
      labels: *id001
    spec:
      containers:
      - name: warehouse
        image: node:22-alpine
        ports:
        - containerPort: 8000
          name: http
        env:
        - name: MCP_TRANSPORT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MCP_TRANSPORT
        - name: WAREHOUSE_TYPE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: WAREHOUSE_TYPE
        - name: MCP_API_KEYS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MCP_API_KEYS
        - name: DUCKDB_PATH
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DUCKDB_PATH
        - name: MOTHERDUCK_TOKEN
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MOTHERDUCK_TOKEN
        - name: PG_HOST
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: PG_HOST
        - name: PG_DATABASE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: PG_DATABASE
        - name: PG_USER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: PG_USER
        - name: PG_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: PG_PASSWORD
        - name: ORACLE_USER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: ORACLE_USER
        - name: ORACLE_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: ORACLE_PASSWORD
        - name: ORACLE_CONNECT_STRING
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: ORACLE_CONNECT_STRING
        - name: SNOWFLAKE_ACCOUNT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_ACCOUNT
        - name: SNOWFLAKE_USER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_USER
        - name: SNOWFLAKE_PRIVATE_KEY_PATH
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SNOWFLAKE_PRIVATE_KEY_PATH
        - name: BIGQUERY_PROJECT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: BIGQUERY_PROJECT
        - name: GOOGLE_APPLICATION_CREDENTIALS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: GOOGLE_APPLICATION_CREDENTIALS
        - name: GUARDRAIL_PII_MASK
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: GUARDRAIL_PII_MASK
        - name: MCP_RATE_LIMIT_RPM
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MCP_RATE_LIMIT_RPM
        command:
        - sh
        - -c
        - npx -y supergateway@4 --stdio 'npx -y [email protected]' --outputTransport streamableHttp
          --stateful --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz
        readinessProbe:
          httpGet:
            path: /healthz
            port: http
          initialDelaySeconds: 10
---
apiVersion: v1
kind: Service
metadata:
  name: warehouse
  namespace: mcp
spec:
  selector:
    app: warehouse
  ports:
  - port: 8000
    targetPort: http
    name: http
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T13:23:49+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:
  warehouse:
    enabled: true
    replicas: 1
    port: 8000
    path: /mcp
    container:
      name: warehouse
      image: node:22-alpine
      ports:
      - containerPort: 8000
        name: http
      env:
      - name: MCP_TRANSPORT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MCP_TRANSPORT
      - name: WAREHOUSE_TYPE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: WAREHOUSE_TYPE
      - name: MCP_API_KEYS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MCP_API_KEYS
      - name: DUCKDB_PATH
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DUCKDB_PATH
      - name: MOTHERDUCK_TOKEN
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MOTHERDUCK_TOKEN
      - name: PG_HOST
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: PG_HOST
      - name: PG_DATABASE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: PG_DATABASE
      - name: PG_USER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: PG_USER
      - name: PG_PASSWORD
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: PG_PASSWORD
      - name: ORACLE_USER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: ORACLE_USER
      - name: ORACLE_PASSWORD
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: ORACLE_PASSWORD
      - name: ORACLE_CONNECT_STRING
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: ORACLE_CONNECT_STRING
      - name: SNOWFLAKE_ACCOUNT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_ACCOUNT
      - name: SNOWFLAKE_USER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_USER
      - name: SNOWFLAKE_PRIVATE_KEY_PATH
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SNOWFLAKE_PRIVATE_KEY_PATH
      - name: BIGQUERY_PROJECT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: BIGQUERY_PROJECT
      - name: GOOGLE_APPLICATION_CREDENTIALS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: GOOGLE_APPLICATION_CREDENTIALS
      - name: GUARDRAIL_PII_MASK
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: GUARDRAIL_PII_MASK
      - name: MCP_RATE_LIMIT_RPM
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MCP_RATE_LIMIT_RPM
      command:
      - sh
      - -c
      - npx -y supergateway@4 --stdio 'npx -y [email protected]' --outputTransport streamableHttp --stateful
        --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz
      readinessProbe:
        httpGet:
          path: /healthz
          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: MCP_TRANSPORT, WAREHOUSE_TYPE, MCP_API_KEYS, DUCKDB_PATH, MOTHERDUCK_TOKEN, PG_HOST, PG_DATABASE, PG_USER, PG_PASSWORD, ORACLE_USER, ORACLE_PASSWORD, ORACLE_CONNECT_STRING, SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PRIVATE_KEY_PATH, BIGQUERY_PROJECT, GOOGLE_APPLICATION_CREDENTIALS, GUARDRAIL_PII_MASK, MCP_RATE_LIMIT_RPM. 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
    npx -y [email protected]
# env: MCP_TRANSPORT, WAREHOUSE_TYPE, MCP_API_KEYS, DUCKDB_PATH, MOTHERDUCK_TOKEN, PG_HOST, PG_DATABASE, PG_USER, PG_PASSWORD, ORACLE_USER, ORACLE_PASSWORD, ORACLE_CONNECT_STRING, SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PRIVATE_KEY_PATH, BIGQUERY_PROJECT, GOOGLE_APPLICATION_CREDENTIALS, GUARDRAIL_PII_MASK, MCP_RATE_LIMIT_RPM
    {
  "mcpServers": {
    "warehouse": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MCP_TRANSPORT": "${MCP_TRANSPORT}",
        "WAREHOUSE_TYPE": "${WAREHOUSE_TYPE}",
        "MCP_API_KEYS": "${MCP_API_KEYS}",
        "DUCKDB_PATH": "${DUCKDB_PATH}",
        "MOTHERDUCK_TOKEN": "${MOTHERDUCK_TOKEN}",
        "PG_HOST": "${PG_HOST}",
        "PG_DATABASE": "${PG_DATABASE}",
        "PG_USER": "${PG_USER}",
        "PG_PASSWORD": "${PG_PASSWORD}",
        "ORACLE_USER": "${ORACLE_USER}",
        "ORACLE_PASSWORD": "${ORACLE_PASSWORD}",
        "ORACLE_CONNECT_STRING": "${ORACLE_CONNECT_STRING}",
        "SNOWFLAKE_ACCOUNT": "${SNOWFLAKE_ACCOUNT}",
        "SNOWFLAKE_USER": "${SNOWFLAKE_USER}",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "${SNOWFLAKE_PRIVATE_KEY_PATH}",
        "BIGQUERY_PROJECT": "${BIGQUERY_PROJECT}",
        "GOOGLE_APPLICATION_CREDENTIALS": "${GOOGLE_APPLICATION_CREDENTIALS}",
        "GUARDRAIL_PII_MASK": "${GUARDRAIL_PII_MASK}",
        "MCP_RATE_LIMIT_RPM": "${MCP_RATE_LIMIT_RPM}"
      }
    }
  }
}
    #!/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 warehouse -e "MCP_TRANSPORT=${MCP_TRANSPORT}" -e "WAREHOUSE_TYPE=${WAREHOUSE_TYPE}" -e "MCP_API_KEYS=${MCP_API_KEYS}" -e "DUCKDB_PATH=${DUCKDB_PATH}" -e "MOTHERDUCK_TOKEN=${MOTHERDUCK_TOKEN}" -e "PG_HOST=${PG_HOST}" -e "PG_DATABASE=${PG_DATABASE}" -e "PG_USER=${PG_USER}" -e "PG_PASSWORD=${PG_PASSWORD}" -e "ORACLE_USER=${ORACLE_USER}" -e "ORACLE_PASSWORD=${ORACLE_PASSWORD}" -e "ORACLE_CONNECT_STRING=${ORACLE_CONNECT_STRING}" -e "SNOWFLAKE_ACCOUNT=${SNOWFLAKE_ACCOUNT}" -e "SNOWFLAKE_USER=${SNOWFLAKE_USER}" -e "SNOWFLAKE_PRIVATE_KEY_PATH=${SNOWFLAKE_PRIVATE_KEY_PATH}" -e "BIGQUERY_PROJECT=${BIGQUERY_PROJECT}" -e "GOOGLE_APPLICATION_CREDENTIALS=${GOOGLE_APPLICATION_CREDENTIALS}" -e "GUARDRAIL_PII_MASK=${GUARDRAIL_PII_MASK}" -e "MCP_RATE_LIMIT_RPM=${MCP_RATE_LIMIT_RPM}" -- npx -y [email protected]

    {
  "mcpServers": {
    "warehouse": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MCP_TRANSPORT": "${MCP_TRANSPORT}",
        "WAREHOUSE_TYPE": "${WAREHOUSE_TYPE}",
        "MCP_API_KEYS": "${MCP_API_KEYS}",
        "DUCKDB_PATH": "${DUCKDB_PATH}",
        "MOTHERDUCK_TOKEN": "${MOTHERDUCK_TOKEN}",
        "PG_HOST": "${PG_HOST}",
        "PG_DATABASE": "${PG_DATABASE}",
        "PG_USER": "${PG_USER}",
        "PG_PASSWORD": "${PG_PASSWORD}",
        "ORACLE_USER": "${ORACLE_USER}",
        "ORACLE_PASSWORD": "${ORACLE_PASSWORD}",
        "ORACLE_CONNECT_STRING": "${ORACLE_CONNECT_STRING}",
        "SNOWFLAKE_ACCOUNT": "${SNOWFLAKE_ACCOUNT}",
        "SNOWFLAKE_USER": "${SNOWFLAKE_USER}",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "${SNOWFLAKE_PRIVATE_KEY_PATH}",
        "BIGQUERY_PROJECT": "${BIGQUERY_PROJECT}",
        "GOOGLE_APPLICATION_CREDENTIALS": "${GOOGLE_APPLICATION_CREDENTIALS}",
        "GUARDRAIL_PII_MASK": "${GUARDRAIL_PII_MASK}",
        "MCP_RATE_LIMIT_RPM": "${MCP_RATE_LIMIT_RPM}"
      }
    }
  }
}
    {
  "servers": {
    "warehouse": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MCP_TRANSPORT": "${MCP_TRANSPORT}",
        "WAREHOUSE_TYPE": "${WAREHOUSE_TYPE}",
        "MCP_API_KEYS": "${MCP_API_KEYS}",
        "DUCKDB_PATH": "${DUCKDB_PATH}",
        "MOTHERDUCK_TOKEN": "${MOTHERDUCK_TOKEN}",
        "PG_HOST": "${PG_HOST}",
        "PG_DATABASE": "${PG_DATABASE}",
        "PG_USER": "${PG_USER}",
        "PG_PASSWORD": "${PG_PASSWORD}",
        "ORACLE_USER": "${ORACLE_USER}",
        "ORACLE_PASSWORD": "${ORACLE_PASSWORD}",
        "ORACLE_CONNECT_STRING": "${ORACLE_CONNECT_STRING}",
        "SNOWFLAKE_ACCOUNT": "${SNOWFLAKE_ACCOUNT}",
        "SNOWFLAKE_USER": "${SNOWFLAKE_USER}",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "${SNOWFLAKE_PRIVATE_KEY_PATH}",
        "BIGQUERY_PROJECT": "${BIGQUERY_PROJECT}",
        "GOOGLE_APPLICATION_CREDENTIALS": "${GOOGLE_APPLICATION_CREDENTIALS}",
        "GUARDRAIL_PII_MASK": "${GUARDRAIL_PII_MASK}",
        "MCP_RATE_LIMIT_RPM": "${MCP_RATE_LIMIT_RPM}"
      }
    }
  }
}
    name: my-agent
target: local
servers:
- hub: io.github.kalehdoo/warehouse-mcp
    • 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.