x=hub

your toolset

    build deployment
    sign in

    IBM Db2 for i

    mcpkey · package
    io.github.Strom-Capital/mcp-server-db2i · v3.8.1
    deploy just this

    Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).

    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/db2i
# db2i: its packages, installed whole before its unit starts (no session installs)
# npx takes a half-installed tree for installed: a rerun starts them afresh
systemctl stop mcp-my-agent-db2i.service 2>/dev/null || true
as_mcp /var/lib/mcp/db2i rm -rf /var/lib/mcp/db2i/.npm/_npx
as_mcp /var/lib/mcp/db2i npx --yes [email protected] -- true
as_mcp /var/lib/mcp/db2i npx --yes --package=supergateway@4 -- true

#!/usr/bin/env bash
# db2i (io.github.Strom-Capital/mcp-server-db2i), recipe baremetal (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-db2i.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 db2i (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/db2i
WorkingDirectory=/var/lib/mcp/db2i
ExecStart=/opt/mcp/my-agent/bin/db2i.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/db2i

[Install]
WantedBy=multi-user.target
    generated from the record, not tested yet
    docker run --rm -p 127.0.0.1:8101:8000 -e DB2I_HOSTNAME -e DB2I_USERNAME -e DB2I_PASSWORD -e DB2I_SCHEMA -e DB2I_PROFILES -e QUERY_ALLOWED_SCHEMAS -e DB2I_DRIVER -e DB2I_JDBC_OPTIONS -e DB2I_ODBC_OPTIONS -e DB2I_MAPEPIRE_OPTIONS 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-18T17:56:41+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:
  db2i:
    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:
      DB2I_HOSTNAME: ${DB2I_HOSTNAME}
      DB2I_USERNAME: ${DB2I_USERNAME}
      DB2I_PASSWORD: ${DB2I_PASSWORD}
      DB2I_SCHEMA: ${DB2I_SCHEMA}
      DB2I_PROFILES: ${DB2I_PROFILES}
      QUERY_ALLOWED_SCHEMAS: ${QUERY_ALLOWED_SCHEMAS}
      DB2I_DRIVER: ${DB2I_DRIVER}
      DB2I_JDBC_OPTIONS: ${DB2I_JDBC_OPTIONS}
      DB2I_ODBC_OPTIONS: ${DB2I_ODBC_OPTIONS}
      DB2I_MAPEPIRE_OPTIONS: ${DB2I_MAPEPIRE_OPTIONS}
volumes:
  npm-cache: {}
  uv-cache: {}
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T17:56:41+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: db2i
  namespace: mcp
  labels: &id001
    app: db2i
spec:
  replicas: 1
  selector:
    matchLabels: *id001
  template:
    metadata:
      labels: *id001
    spec:
      containers:
      - name: db2i
        image: node:22-alpine
        ports:
        - containerPort: 8000
          name: http
        env:
        - name: DB2I_HOSTNAME
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB2I_HOSTNAME
        - name: DB2I_USERNAME
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB2I_USERNAME
        - name: DB2I_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB2I_PASSWORD
        - name: DB2I_SCHEMA
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB2I_SCHEMA
        - name: DB2I_PROFILES
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB2I_PROFILES
        - name: QUERY_ALLOWED_SCHEMAS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: QUERY_ALLOWED_SCHEMAS
        - name: DB2I_DRIVER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB2I_DRIVER
        - name: DB2I_JDBC_OPTIONS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB2I_JDBC_OPTIONS
        - name: DB2I_ODBC_OPTIONS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB2I_ODBC_OPTIONS
        - name: DB2I_MAPEPIRE_OPTIONS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB2I_MAPEPIRE_OPTIONS
        args:
        - 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: db2i
  namespace: mcp
spec:
  selector:
    app: db2i
  ports:
  - port: 8000
    targetPort: http
    name: http
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T17:56:41+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:
  db2i:
    enabled: true
    replicas: 1
    port: 8000
    path: /mcp
    container:
      name: db2i
      image: node:22-alpine
      ports:
      - containerPort: 8000
        name: http
      env:
      - name: DB2I_HOSTNAME
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB2I_HOSTNAME
      - name: DB2I_USERNAME
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB2I_USERNAME
      - name: DB2I_PASSWORD
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB2I_PASSWORD
      - name: DB2I_SCHEMA
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB2I_SCHEMA
      - name: DB2I_PROFILES
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB2I_PROFILES
      - name: QUERY_ALLOWED_SCHEMAS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: QUERY_ALLOWED_SCHEMAS
      - name: DB2I_DRIVER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB2I_DRIVER
      - name: DB2I_JDBC_OPTIONS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB2I_JDBC_OPTIONS
      - name: DB2I_ODBC_OPTIONS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB2I_ODBC_OPTIONS
      - name: DB2I_MAPEPIRE_OPTIONS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB2I_MAPEPIRE_OPTIONS
      args:
      - 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: DB2I_HOSTNAME, DB2I_USERNAME, DB2I_PASSWORD, DB2I_SCHEMA, DB2I_PROFILES, QUERY_ALLOWED_SCHEMAS, DB2I_DRIVER, DB2I_JDBC_OPTIONS, DB2I_ODBC_OPTIONS, DB2I_MAPEPIRE_OPTIONS. 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: DB2I_HOSTNAME, DB2I_USERNAME, DB2I_PASSWORD, DB2I_SCHEMA, DB2I_PROFILES, QUERY_ALLOWED_SCHEMAS, DB2I_DRIVER, DB2I_JDBC_OPTIONS, DB2I_ODBC_OPTIONS, DB2I_MAPEPIRE_OPTIONS
    {
  "mcpServers": {
    "db2i": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "DB2I_HOSTNAME": "${DB2I_HOSTNAME}",
        "DB2I_USERNAME": "${DB2I_USERNAME}",
        "DB2I_PASSWORD": "${DB2I_PASSWORD}",
        "DB2I_SCHEMA": "${DB2I_SCHEMA}",
        "DB2I_PROFILES": "${DB2I_PROFILES}",
        "QUERY_ALLOWED_SCHEMAS": "${QUERY_ALLOWED_SCHEMAS}",
        "DB2I_DRIVER": "${DB2I_DRIVER}",
        "DB2I_JDBC_OPTIONS": "${DB2I_JDBC_OPTIONS}",
        "DB2I_ODBC_OPTIONS": "${DB2I_ODBC_OPTIONS}",
        "DB2I_MAPEPIRE_OPTIONS": "${DB2I_MAPEPIRE_OPTIONS}"
      }
    }
  }
}
    #!/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 db2i -e "DB2I_HOSTNAME=${DB2I_HOSTNAME}" -e "DB2I_USERNAME=${DB2I_USERNAME}" -e "DB2I_PASSWORD=${DB2I_PASSWORD}" -e "DB2I_SCHEMA=${DB2I_SCHEMA}" -e "DB2I_PROFILES=${DB2I_PROFILES}" -e "QUERY_ALLOWED_SCHEMAS=${QUERY_ALLOWED_SCHEMAS}" -e "DB2I_DRIVER=${DB2I_DRIVER}" -e "DB2I_JDBC_OPTIONS=${DB2I_JDBC_OPTIONS}" -e "DB2I_ODBC_OPTIONS=${DB2I_ODBC_OPTIONS}" -e "DB2I_MAPEPIRE_OPTIONS=${DB2I_MAPEPIRE_OPTIONS}" -- npx -y [email protected]

    {
  "mcpServers": {
    "db2i": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "DB2I_HOSTNAME": "${DB2I_HOSTNAME}",
        "DB2I_USERNAME": "${DB2I_USERNAME}",
        "DB2I_PASSWORD": "${DB2I_PASSWORD}",
        "DB2I_SCHEMA": "${DB2I_SCHEMA}",
        "DB2I_PROFILES": "${DB2I_PROFILES}",
        "QUERY_ALLOWED_SCHEMAS": "${QUERY_ALLOWED_SCHEMAS}",
        "DB2I_DRIVER": "${DB2I_DRIVER}",
        "DB2I_JDBC_OPTIONS": "${DB2I_JDBC_OPTIONS}",
        "DB2I_ODBC_OPTIONS": "${DB2I_ODBC_OPTIONS}",
        "DB2I_MAPEPIRE_OPTIONS": "${DB2I_MAPEPIRE_OPTIONS}"
      }
    }
  }
}
    {
  "servers": {
    "db2i": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "DB2I_HOSTNAME": "${DB2I_HOSTNAME}",
        "DB2I_USERNAME": "${DB2I_USERNAME}",
        "DB2I_PASSWORD": "${DB2I_PASSWORD}",
        "DB2I_SCHEMA": "${DB2I_SCHEMA}",
        "DB2I_PROFILES": "${DB2I_PROFILES}",
        "QUERY_ALLOWED_SCHEMAS": "${QUERY_ALLOWED_SCHEMAS}",
        "DB2I_DRIVER": "${DB2I_DRIVER}",
        "DB2I_JDBC_OPTIONS": "${DB2I_JDBC_OPTIONS}",
        "DB2I_ODBC_OPTIONS": "${DB2I_ODBC_OPTIONS}",
        "DB2I_MAPEPIRE_OPTIONS": "${DB2I_MAPEPIRE_OPTIONS}"
      }
    }
  }
}
    name: my-agent
target: local
servers:
- hub: io.github.Strom-Capital/mcp-server-db2i
    • not probed yet: tools unpinned, ingest lists them

    tools

    Probe result: needs authdocker: credentials=placeholder: no MCP server found (:8000/mcp: HTTP 404: MCPError: MCP server process failed; :8000/: HTTP 404: MCPError: Not Found) [supergateway] Modern HTTP adapter error: SdkError: Connection closed before a response was produced | …nent: "systems" [supergateway] Child stderr: [2026-10-18 17:41:23.080] FATAL (mcp-server-db2i): Failed to start MCP server err: { "type": "SystemsError", "message": "DB2I_PROFILES (<secret>): ENOENT: no such file or directory, open '<secret>'", "stack": SystemsError: DB2I_PROFILES (<secret>): ENOENT: no such file or directory, open '<secret>' at loadProfilesFile (file://<path>:126:15) at loadSystems (file://<path>:100:12) at getSystems (file://<path>:69:35) at main (file://<path>:50:25) at file://<path>:211:5 at ModuleJob.run (node:internal/modules/esm/module_job:343:25) at process.processTicksAndRejections (node:internal/process/task_queues:103:5) at async onImport.tracePromise.__proto__ (node:internal/modules/esm/loader:681:26) at async asyncRunEntryPointWithESMLoader (node:internal/modules/run_main:117:5) "name": "SystemsError" } [supergateway] Child exited: code=1, signal=null; 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 17:41 local-mac-vm docker needs auth gvisor docker: credentials=placeholder: no MCP server found (:8000/mcp: HTTP 404: MCPError: MCP server process failed; :8000/: HTTP 404: MCPError: Not Found) [supergat…