x=hub

your toolset

    build deployment
    sign in

    MySQL MCP Server

    mcpkey · package
    io.github.musaddiq-dev/mysql-mcp-server · v0.1.2
    deploy just this

    Python MCP server for MySQL database inspection and querying

    run it

    on your own machines, one way per deploy method
    generated from the record, not tested yet
    #!/usr/bin/env bash
    # mysql (io.github.musaddiq-dev/mysql-mcp-server), recipe baremetal (generated).
    # Generated by Hub for toolset "my-agent"; started by mcp-my-agent-mysql.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 mdev-mysql-mcp-server==0.1.2
    
    [Unit]
    Description=MCP server mysql (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/mysql
    WorkingDirectory=/var/lib/mcp/mysql
    ExecStart=/opt/mcp/my-agent/bin/mysql.sh
    Restart=on-failure
    RestartSec=5
    NoNewPrivileges=true
    ProtectSystem=strict
    ProtectHome=true
    PrivateTmp=true
    ReadWritePaths=/var/lib/mcp/mysql
    
    [Install]
    WantedBy=multi-user.target
    
    generated from the record, not tested yet
    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_POOL_SIZE -e LOG_LEVEL -e MYSQL_READ_QUERY_LIMIT ghcr.io/astral-sh/uv:python3.12-bookworm-slim sh -c 'uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx mdev-mysql-mcp-server==0.1.2'
    
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T04:22:20+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:
        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 mdev-mysql-mcp-server==0.1.2
        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:
          MYSQL_HOST: ${MYSQL_HOST}
          MYSQL_PORT: ${MYSQL_PORT}
          MYSQL_USER: ${MYSQL_USER}
          MYSQL_PASSWORD: ${MYSQL_PASSWORD}
          MYSQL_DATABASE: ${MYSQL_DATABASE}
          MYSQL_POOL_SIZE: ${MYSQL_POOL_SIZE}
          LOG_LEVEL: ${LOG_LEVEL}
          MYSQL_READ_QUERY_LIMIT: ${MYSQL_READ_QUERY_LIMIT}
    volumes:
      npm-cache: {}
      uv-cache: {}
    
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T04:22:20+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
      namespace: mcp
      labels: &id001
        app: mysql
    spec:
      replicas: 1
      selector:
        matchLabels: *id001
      template:
        metadata:
          labels: *id001
        spec:
          containers:
          - name: mysql
            image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
            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_POOL_SIZE
              valueFrom:
                secretKeyRef:
                  name: mcp-credentials
                  key: MYSQL_POOL_SIZE
            - name: LOG_LEVEL
              valueFrom:
                secretKeyRef:
                  name: mcp-credentials
                  key: LOG_LEVEL
            - name: MYSQL_READ_QUERY_LIMIT
              valueFrom:
                secretKeyRef:
                  name: mcp-credentials
                  key: MYSQL_READ_QUERY_LIMIT
            command:
            - sh
            - -c
            - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx mdev-mysql-mcp-server==0.1.2
            readinessProbe:
              httpGet:
                path: /status
                port: http
              initialDelaySeconds: 10
    ---
    apiVersion: v1
    kind: Service
    metadata:
      name: mysql
      namespace: mcp
    spec:
      selector:
        app: mysql
      ports:
      - port: 8000
        targetPort: http
        name: http
    
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T04:22:20+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:
        enabled: true
        replicas: 1
        port: 8000
        path: /mcp
        container:
          name: mysql
          image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
          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_POOL_SIZE
            valueFrom:
              secretKeyRef:
                name: mcp-credentials
                key: MYSQL_POOL_SIZE
          - name: LOG_LEVEL
            valueFrom:
              secretKeyRef:
                name: mcp-credentials
                key: LOG_LEVEL
          - name: MYSQL_READ_QUERY_LIMIT
            valueFrom:
              secretKeyRef:
                name: mcp-credentials
                key: MYSQL_READ_QUERY_LIMIT
          command:
          - sh
          - -c
          - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx mdev-mysql-mcp-server==0.1.2
          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

    The form opens with CHANGE_ME for each value you supply: MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, MYSQL_POOL_SIZE, LOG_LEVEL, MYSQL_READ_QUERY_LIMIT. Fill them in before you deploy.

    Clients connect to the service's https://…koyeb.app address plus /mcp.

    azure

    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 mdev-mysql-mcp-server==0.1.2
    # env: MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, MYSQL_POOL_SIZE, LOG_LEVEL, MYSQL_READ_QUERY_LIMIT
    {
      "mcpServers": {
        "mysql": {
          "command": "uvx",
          "args": [
            "mdev-mysql-mcp-server==0.1.2"
          ],
          "env": {
            "MYSQL_HOST": "${MYSQL_HOST}",
            "MYSQL_PORT": "${MYSQL_PORT}",
            "MYSQL_USER": "${MYSQL_USER}",
            "MYSQL_PASSWORD": "${MYSQL_PASSWORD}",
            "MYSQL_DATABASE": "${MYSQL_DATABASE}",
            "MYSQL_POOL_SIZE": "${MYSQL_POOL_SIZE}",
            "LOG_LEVEL": "${LOG_LEVEL}",
            "MYSQL_READ_QUERY_LIMIT": "${MYSQL_READ_QUERY_LIMIT}"
          }
        }
      }
    }
    #!/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 mysql -e "MYSQL_HOST=${MYSQL_HOST}" -e "MYSQL_PORT=${MYSQL_PORT}" -e "MYSQL_USER=${MYSQL_USER}" -e "MYSQL_PASSWORD=${MYSQL_PASSWORD}" -e "MYSQL_DATABASE=${MYSQL_DATABASE}" -e "MYSQL_POOL_SIZE=${MYSQL_POOL_SIZE}" -e "LOG_LEVEL=${LOG_LEVEL}" -e "MYSQL_READ_QUERY_LIMIT=${MYSQL_READ_QUERY_LIMIT}" -- uvx mdev-mysql-mcp-server==0.1.2
    
    {
      "mcpServers": {
        "mysql": {
          "command": "uvx",
          "args": [
            "mdev-mysql-mcp-server==0.1.2"
          ],
          "env": {
            "MYSQL_HOST": "${MYSQL_HOST}",
            "MYSQL_PORT": "${MYSQL_PORT}",
            "MYSQL_USER": "${MYSQL_USER}",
            "MYSQL_PASSWORD": "${MYSQL_PASSWORD}",
            "MYSQL_DATABASE": "${MYSQL_DATABASE}",
            "MYSQL_POOL_SIZE": "${MYSQL_POOL_SIZE}",
            "LOG_LEVEL": "${LOG_LEVEL}",
            "MYSQL_READ_QUERY_LIMIT": "${MYSQL_READ_QUERY_LIMIT}"
          }
        }
      }
    }
    {
      "servers": {
        "mysql": {
          "type": "stdio",
          "command": "uvx",
          "args": [
            "mdev-mysql-mcp-server==0.1.2"
          ],
          "env": {
            "MYSQL_HOST": "${MYSQL_HOST}",
            "MYSQL_PORT": "${MYSQL_PORT}",
            "MYSQL_USER": "${MYSQL_USER}",
            "MYSQL_PASSWORD": "${MYSQL_PASSWORD}",
            "MYSQL_DATABASE": "${MYSQL_DATABASE}",
            "MYSQL_POOL_SIZE": "${MYSQL_POOL_SIZE}",
            "LOG_LEVEL": "${LOG_LEVEL}",
            "MYSQL_READ_QUERY_LIMIT": "${MYSQL_READ_QUERY_LIMIT}"
          }
        }
      }
    }
    name: my-agent
    target: local
    servers:
    - hub: io.github.musaddiq-dev/mysql-mcp-server
    
    • 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.