MySQL (read-only, switchable)

docker run --rm -p 127.0.0.1:8101:8000 -e MYSQL_HOST -e MYSQL_PORT -e MYSQL_USER -e MYSQL_PASSWORD -e MYSQL_DATABASE -e MYSQL_PROFILES -e MYSQL_DEFAULT_PROFILE -e MYSQL_CONNECT_TIMEOUT_MS -e MYSQL_QUERY_TIMEOUT_MS 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 by Hub for toolset "my-agent" (2026-10-18T22:33: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:
  mysql-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:
      MYSQL_HOST: ${MYSQL_HOST}
      MYSQL_PORT: ${MYSQL_PORT}
      MYSQL_USER: ${MYSQL_USER}
      MYSQL_PASSWORD: ${MYSQL_PASSWORD}
      MYSQL_DATABASE: ${MYSQL_DATABASE}
      MYSQL_PROFILES: ${MYSQL_PROFILES}
      MYSQL_DEFAULT_PROFILE: ${MYSQL_DEFAULT_PROFILE}
      MYSQL_CONNECT_TIMEOUT_MS: ${MYSQL_CONNECT_TIMEOUT_MS}
      MYSQL_QUERY_TIMEOUT_MS: ${MYSQL_QUERY_TIMEOUT_MS}
volumes:
  npm-cache: {}
  uv-cache: {}

# Generated by Hub for toolset "my-agent" (2026-10-18T22:33: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: mysql-read-only
  namespace: mcp
  labels: &id001
    app: mysql-read-only
spec:
  replicas: 1
  selector:
    matchLabels: *id001
  template:
    metadata:
      labels: *id001
    spec:
      containers:
      - name: mysql-read-only
        image: node:22-alpine
        ports:
        - containerPort: 8000
          name: http
        env:
        - name: MYSQL_HOST
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MYSQL_HOST
        - name: MYSQL_PORT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MYSQL_PORT
        - 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
        - name: MYSQL_PROFILES
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MYSQL_PROFILES
        - name: MYSQL_DEFAULT_PROFILE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MYSQL_DEFAULT_PROFILE
        - name: MYSQL_CONNECT_TIMEOUT_MS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MYSQL_CONNECT_TIMEOUT_MS
        - name: MYSQL_QUERY_TIMEOUT_MS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: MYSQL_QUERY_TIMEOUT_MS
        args:
        - 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: mysql-read-only
  namespace: mcp
spec:
  selector:
    app: mysql-read-only
  ports:
  - port: 8000
    targetPort: http
    name: http

# Generated by Hub for toolset "my-agent" (2026-10-18T22:33: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:
  mysql-read-only:
    enabled: true
    replicas: 1
    port: 8000
    path: /mcp
    container:
      name: mysql-read-only
      image: node:22-alpine
      ports:
      - containerPort: 8000
        name: http
      env:
      - name: MYSQL_HOST
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MYSQL_HOST
      - name: MYSQL_PORT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MYSQL_PORT
      - 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
      - name: MYSQL_PROFILES
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MYSQL_PROFILES
      - name: MYSQL_DEFAULT_PROFILE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MYSQL_DEFAULT_PROFILE
      - name: MYSQL_CONNECT_TIMEOUT_MS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MYSQL_CONNECT_TIMEOUT_MS
      - name: MYSQL_QUERY_TIMEOUT_MS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: MYSQL_QUERY_TIMEOUT_MS
      args:
      - 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