x=hub

your toolset

    build deployment
    sign in

    Databases (read-only, switchable)

    mcpkey · package
    io.github.shibbirweb/mcp-db-read-only · v1.1.0
    deploy just this

    Read-only SQL, MongoDB, Redis and Elasticsearch access, switchable mid-conversation.

    run it

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

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

[Install]
WantedBy=multi-user.target
    generated from the record, not tested yet
    docker run --rm -p 127.0.0.1:8101:8000 -e DB_URL -e DB_PASSWORD -e DB_PROFILES -e DB_DEFAULT_PROFILE -e DB_CONNECT_TIMEOUT_MS -e DB_QUERY_TIMEOUT_MS -e DB_LOG -e DB_LOG_FILE -e DB_LOG_DIR -e DB_LOG_FORMAT -e DB_LOG_PORT -e DB_LOG_HISTORY -e MYSQL_HOST -e MYSQL_USER -e MYSQL_PASSWORD -e MYSQL_DATABASE node:22-alpine sh -c 'npx -y supergateway@4 --stdio '"'"'npx -y @shibbirweb/[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:49: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:
  db-read-only:
    image: node:22-alpine
    command:
    - sh
    - -c
    - npx -y supergateway@4 --stdio 'npx -y @shibbirweb/[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:
      DB_URL: ${DB_URL}
      DB_PASSWORD: ${DB_PASSWORD}
      DB_PROFILES: ${DB_PROFILES}
      DB_DEFAULT_PROFILE: ${DB_DEFAULT_PROFILE}
      DB_CONNECT_TIMEOUT_MS: ${DB_CONNECT_TIMEOUT_MS}
      DB_QUERY_TIMEOUT_MS: ${DB_QUERY_TIMEOUT_MS}
      DB_LOG: ${DB_LOG}
      DB_LOG_FILE: ${DB_LOG_FILE}
      DB_LOG_DIR: ${DB_LOG_DIR}
      DB_LOG_FORMAT: ${DB_LOG_FORMAT}
      DB_LOG_PORT: ${DB_LOG_PORT}
      DB_LOG_HISTORY: ${DB_LOG_HISTORY}
      MYSQL_HOST: ${MYSQL_HOST}
      MYSQL_USER: ${MYSQL_USER}
      MYSQL_PASSWORD: ${MYSQL_PASSWORD}
      MYSQL_DATABASE: ${MYSQL_DATABASE}
volumes:
  npm-cache: {}
  uv-cache: {}
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T13:49: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: db-read-only
  namespace: mcp
  labels: &id001
    app: db-read-only
spec:
  replicas: 1
  selector:
    matchLabels: *id001
  template:
    metadata:
      labels: *id001
    spec:
      containers:
      - name: db-read-only
        image: node:22-alpine
        ports:
        - containerPort: 8000
          name: http
        env:
        - name: DB_URL
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_URL
        - name: DB_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_PASSWORD
        - name: DB_PROFILES
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_PROFILES
        - name: DB_DEFAULT_PROFILE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_DEFAULT_PROFILE
        - name: DB_CONNECT_TIMEOUT_MS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_CONNECT_TIMEOUT_MS
        - name: DB_QUERY_TIMEOUT_MS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_QUERY_TIMEOUT_MS
        - name: DB_LOG
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_LOG
        - name: DB_LOG_FILE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_LOG_FILE
        - name: DB_LOG_DIR
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_LOG_DIR
        - name: DB_LOG_FORMAT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_LOG_FORMAT
        - name: DB_LOG_PORT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_LOG_PORT
        - name: DB_LOG_HISTORY
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: DB_LOG_HISTORY
        - name: MYSQL_HOST
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MYSQL_HOST
        - name: MYSQL_USER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MYSQL_USER
        - name: MYSQL_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MYSQL_PASSWORD
        - name: MYSQL_DATABASE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MYSQL_DATABASE
        command:
        - sh
        - -c
        - npx -y supergateway@4 --stdio 'npx -y @shibbirweb/[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: db-read-only
  namespace: mcp
spec:
  selector:
    app: db-read-only
  ports:
  - port: 8000
    targetPort: http
    name: http
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T13:49: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:
  db-read-only:
    enabled: true
    replicas: 1
    port: 8000
    path: /mcp
    container:
      name: db-read-only
      image: node:22-alpine
      ports:
      - containerPort: 8000
        name: http
      env:
      - name: DB_URL
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_URL
      - name: DB_PASSWORD
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_PASSWORD
      - name: DB_PROFILES
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_PROFILES
      - name: DB_DEFAULT_PROFILE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_DEFAULT_PROFILE
      - name: DB_CONNECT_TIMEOUT_MS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_CONNECT_TIMEOUT_MS
      - name: DB_QUERY_TIMEOUT_MS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_QUERY_TIMEOUT_MS
      - name: DB_LOG
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_LOG
      - name: DB_LOG_FILE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_LOG_FILE
      - name: DB_LOG_DIR
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_LOG_DIR
      - name: DB_LOG_FORMAT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_LOG_FORMAT
      - name: DB_LOG_PORT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_LOG_PORT
      - name: DB_LOG_HISTORY
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: DB_LOG_HISTORY
      - name: MYSQL_HOST
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MYSQL_HOST
      - name: MYSQL_USER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MYSQL_USER
      - name: MYSQL_PASSWORD
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MYSQL_PASSWORD
      - name: MYSQL_DATABASE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MYSQL_DATABASE
      command:
      - sh
      - -c
      - npx -y supergateway@4 --stdio 'npx -y @shibbirweb/[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: DB_URL, DB_PASSWORD, DB_PROFILES, DB_DEFAULT_PROFILE, DB_CONNECT_TIMEOUT_MS, DB_QUERY_TIMEOUT_MS, DB_LOG, DB_LOG_FILE, DB_LOG_DIR, DB_LOG_FORMAT, DB_LOG_PORT, DB_LOG_HISTORY, MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE. 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 @shibbirweb/[email protected]
# env: DB_URL, DB_PASSWORD, DB_PROFILES, DB_DEFAULT_PROFILE, DB_CONNECT_TIMEOUT_MS, DB_QUERY_TIMEOUT_MS, DB_LOG, DB_LOG_FILE, DB_LOG_DIR, DB_LOG_FORMAT, DB_LOG_PORT, DB_LOG_HISTORY, MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE
    {
  "mcpServers": {
    "db-read-only": {
      "command": "npx",
      "args": [
        "-y",
        "@shibbirweb/[email protected]"
      ],
      "env": {
        "DB_URL": "${DB_URL}",
        "DB_PASSWORD": "${DB_PASSWORD}",
        "DB_PROFILES": "${DB_PROFILES}",
        "DB_DEFAULT_PROFILE": "${DB_DEFAULT_PROFILE}",
        "DB_CONNECT_TIMEOUT_MS": "${DB_CONNECT_TIMEOUT_MS}",
        "DB_QUERY_TIMEOUT_MS": "${DB_QUERY_TIMEOUT_MS}",
        "DB_LOG": "${DB_LOG}",
        "DB_LOG_FILE": "${DB_LOG_FILE}",
        "DB_LOG_DIR": "${DB_LOG_DIR}",
        "DB_LOG_FORMAT": "${DB_LOG_FORMAT}",
        "DB_LOG_PORT": "${DB_LOG_PORT}",
        "DB_LOG_HISTORY": "${DB_LOG_HISTORY}",
        "MYSQL_HOST": "${MYSQL_HOST}",
        "MYSQL_USER": "${MYSQL_USER}",
        "MYSQL_PASSWORD": "${MYSQL_PASSWORD}",
        "MYSQL_DATABASE": "${MYSQL_DATABASE}"
      }
    }
  }
}
    #!/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 db-read-only -e "DB_URL=${DB_URL}" -e "DB_PASSWORD=${DB_PASSWORD}" -e "DB_PROFILES=${DB_PROFILES}" -e "DB_DEFAULT_PROFILE=${DB_DEFAULT_PROFILE}" -e "DB_CONNECT_TIMEOUT_MS=${DB_CONNECT_TIMEOUT_MS}" -e "DB_QUERY_TIMEOUT_MS=${DB_QUERY_TIMEOUT_MS}" -e "DB_LOG=${DB_LOG}" -e "DB_LOG_FILE=${DB_LOG_FILE}" -e "DB_LOG_DIR=${DB_LOG_DIR}" -e "DB_LOG_FORMAT=${DB_LOG_FORMAT}" -e "DB_LOG_PORT=${DB_LOG_PORT}" -e "DB_LOG_HISTORY=${DB_LOG_HISTORY}" -e "MYSQL_HOST=${MYSQL_HOST}" -e "MYSQL_USER=${MYSQL_USER}" -e "MYSQL_PASSWORD=${MYSQL_PASSWORD}" -e "MYSQL_DATABASE=${MYSQL_DATABASE}" -- npx -y @shibbirweb/[email protected]

    {
  "mcpServers": {
    "db-read-only": {
      "command": "npx",
      "args": [
        "-y",
        "@shibbirweb/[email protected]"
      ],
      "env": {
        "DB_URL": "${DB_URL}",
        "DB_PASSWORD": "${DB_PASSWORD}",
        "DB_PROFILES": "${DB_PROFILES}",
        "DB_DEFAULT_PROFILE": "${DB_DEFAULT_PROFILE}",
        "DB_CONNECT_TIMEOUT_MS": "${DB_CONNECT_TIMEOUT_MS}",
        "DB_QUERY_TIMEOUT_MS": "${DB_QUERY_TIMEOUT_MS}",
        "DB_LOG": "${DB_LOG}",
        "DB_LOG_FILE": "${DB_LOG_FILE}",
        "DB_LOG_DIR": "${DB_LOG_DIR}",
        "DB_LOG_FORMAT": "${DB_LOG_FORMAT}",
        "DB_LOG_PORT": "${DB_LOG_PORT}",
        "DB_LOG_HISTORY": "${DB_LOG_HISTORY}",
        "MYSQL_HOST": "${MYSQL_HOST}",
        "MYSQL_USER": "${MYSQL_USER}",
        "MYSQL_PASSWORD": "${MYSQL_PASSWORD}",
        "MYSQL_DATABASE": "${MYSQL_DATABASE}"
      }
    }
  }
}
    {
  "servers": {
    "db-read-only": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@shibbirweb/[email protected]"
      ],
      "env": {
        "DB_URL": "${DB_URL}",
        "DB_PASSWORD": "${DB_PASSWORD}",
        "DB_PROFILES": "${DB_PROFILES}",
        "DB_DEFAULT_PROFILE": "${DB_DEFAULT_PROFILE}",
        "DB_CONNECT_TIMEOUT_MS": "${DB_CONNECT_TIMEOUT_MS}",
        "DB_QUERY_TIMEOUT_MS": "${DB_QUERY_TIMEOUT_MS}",
        "DB_LOG": "${DB_LOG}",
        "DB_LOG_FILE": "${DB_LOG_FILE}",
        "DB_LOG_DIR": "${DB_LOG_DIR}",
        "DB_LOG_FORMAT": "${DB_LOG_FORMAT}",
        "DB_LOG_PORT": "${DB_LOG_PORT}",
        "DB_LOG_HISTORY": "${DB_LOG_HISTORY}",
        "MYSQL_HOST": "${MYSQL_HOST}",
        "MYSQL_USER": "${MYSQL_USER}",
        "MYSQL_PASSWORD": "${MYSQL_PASSWORD}",
        "MYSQL_DATABASE": "${MYSQL_DATABASE}"
      }
    }
  }
}
    name: my-agent
target: local
servers:
- hub: io.github.shibbirweb/mcp-db-read-only
    • 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.