MySQL Legacy MCP
mcpkey · packageInspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.
run it
on your own machines, one way per deploy method#!/usr/bin/env bash # mysql-legacy (io.github.Rufflet/mysql-legacy-mcp), recipe baremetal (generated). # Generated by Hub for toolset "my-agent"; started by mcp-my-agent-mysql-legacy.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 mysql-legacy (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-legacy WorkingDirectory=/var/lib/mcp/mysql-legacy ExecStart=/opt/mcp/my-agent/bin/mysql-legacy.sh Restart=on-failure RestartSec=5 NoNewPrivileges=true ProtectSystem=strict ProtectHome=true PrivateTmp=true ReadWritePaths=/var/lib/mcp/mysql-legacy [Install] WantedBy=multi-user.target
docker run --rm -p 127.0.0.1:8101:8000 -e MYSQL_LEGACY_HOST -e MYSQL_LEGACY_USER -e MYSQL_LEGACY_PASSWORD -e MYSQL_LEGACY_PORT -e MYSQL_LEGACY_DATABASE -e MYSQL_LEGACY_HIDE_SYSTEM_DATABASES -e MYSQL_LEGACY_QUERY_TIMEOUT -e MYSQL_LEGACY_MAX_ROWS -e MYSQL_LEGACY_MAX_RESULT_BYTES -e MYSQL_LEGACY_CONNECT_TIMEOUT -e MYSQL_LEGACY_POOL_SIZE -e MYSQL_LEGACY_ALLOW_INSERT -e MYSQL_LEGACY_ALLOW_UPDATE -e MYSQL_LEGACY_ALLOW_DELETE -e MYSQL_LEGACY_ALLOW_DDL -e MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS 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 by Hub for toolset "my-agent" (2026-10-18T03:53:04+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-legacy:
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:
MYSQL_LEGACY_HOST: ${MYSQL_LEGACY_HOST}
MYSQL_LEGACY_USER: ${MYSQL_LEGACY_USER}
MYSQL_LEGACY_PASSWORD: ${MYSQL_LEGACY_PASSWORD}
MYSQL_LEGACY_PORT: ${MYSQL_LEGACY_PORT}
MYSQL_LEGACY_DATABASE: ${MYSQL_LEGACY_DATABASE}
MYSQL_LEGACY_HIDE_SYSTEM_DATABASES: ${MYSQL_LEGACY_HIDE_SYSTEM_DATABASES}
MYSQL_LEGACY_QUERY_TIMEOUT: ${MYSQL_LEGACY_QUERY_TIMEOUT}
MYSQL_LEGACY_MAX_ROWS: ${MYSQL_LEGACY_MAX_ROWS}
MYSQL_LEGACY_MAX_RESULT_BYTES: ${MYSQL_LEGACY_MAX_RESULT_BYTES}
MYSQL_LEGACY_CONNECT_TIMEOUT: ${MYSQL_LEGACY_CONNECT_TIMEOUT}
MYSQL_LEGACY_POOL_SIZE: ${MYSQL_LEGACY_POOL_SIZE}
MYSQL_LEGACY_ALLOW_INSERT: ${MYSQL_LEGACY_ALLOW_INSERT}
MYSQL_LEGACY_ALLOW_UPDATE: ${MYSQL_LEGACY_ALLOW_UPDATE}
MYSQL_LEGACY_ALLOW_DELETE: ${MYSQL_LEGACY_ALLOW_DELETE}
MYSQL_LEGACY_ALLOW_DDL: ${MYSQL_LEGACY_ALLOW_DDL}
MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS: ${MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS}
volumes:
npm-cache: {}
uv-cache: {}
# Generated by Hub for toolset "my-agent" (2026-10-18T03:53:04+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-legacy
namespace: mcp
labels: &id001
app: mysql-legacy
spec:
replicas: 1
selector:
matchLabels: *id001
template:
metadata:
labels: *id001
spec:
containers:
- name: mysql-legacy
image: node:22-alpine
ports:
- containerPort: 8000
name: http
env:
- name: MYSQL_LEGACY_HOST
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_HOST
- name: MYSQL_LEGACY_USER
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_USER
- name: MYSQL_LEGACY_PASSWORD
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_PASSWORD
- name: MYSQL_LEGACY_PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_PORT
- name: MYSQL_LEGACY_DATABASE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_DATABASE
- name: MYSQL_LEGACY_HIDE_SYSTEM_DATABASES
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_HIDE_SYSTEM_DATABASES
- name: MYSQL_LEGACY_QUERY_TIMEOUT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_QUERY_TIMEOUT
- name: MYSQL_LEGACY_MAX_ROWS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_MAX_ROWS
- name: MYSQL_LEGACY_MAX_RESULT_BYTES
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_MAX_RESULT_BYTES
- name: MYSQL_LEGACY_CONNECT_TIMEOUT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_CONNECT_TIMEOUT
- name: MYSQL_LEGACY_POOL_SIZE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_POOL_SIZE
- name: MYSQL_LEGACY_ALLOW_INSERT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_ALLOW_INSERT
- name: MYSQL_LEGACY_ALLOW_UPDATE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_ALLOW_UPDATE
- name: MYSQL_LEGACY_ALLOW_DELETE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_ALLOW_DELETE
- name: MYSQL_LEGACY_ALLOW_DDL
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_ALLOW_DDL
- name: MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS
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: mysql-legacy
namespace: mcp
spec:
selector:
app: mysql-legacy
ports:
- port: 8000
targetPort: http
name: http
# Generated by Hub for toolset "my-agent" (2026-10-18T03:53:04+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-legacy:
enabled: true
replicas: 1
port: 8000
path: /mcp
container:
name: mysql-legacy
image: node:22-alpine
ports:
- containerPort: 8000
name: http
env:
- name: MYSQL_LEGACY_HOST
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_HOST
- name: MYSQL_LEGACY_USER
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_USER
- name: MYSQL_LEGACY_PASSWORD
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_PASSWORD
- name: MYSQL_LEGACY_PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_PORT
- name: MYSQL_LEGACY_DATABASE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_DATABASE
- name: MYSQL_LEGACY_HIDE_SYSTEM_DATABASES
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_HIDE_SYSTEM_DATABASES
- name: MYSQL_LEGACY_QUERY_TIMEOUT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_QUERY_TIMEOUT
- name: MYSQL_LEGACY_MAX_ROWS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_MAX_ROWS
- name: MYSQL_LEGACY_MAX_RESULT_BYTES
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_MAX_RESULT_BYTES
- name: MYSQL_LEGACY_CONNECT_TIMEOUT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_CONNECT_TIMEOUT
- name: MYSQL_LEGACY_POOL_SIZE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_POOL_SIZE
- name: MYSQL_LEGACY_ALLOW_INSERT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_ALLOW_INSERT
- name: MYSQL_LEGACY_ALLOW_UPDATE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_ALLOW_UPDATE
- name: MYSQL_LEGACY_ALLOW_DELETE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_ALLOW_DELETE
- name: MYSQL_LEGACY_ALLOW_DDL
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_ALLOW_DDL
- name: MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS
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
-
The form opens with CHANGE_ME for each value you supply: MYSQL_LEGACY_HOST, MYSQL_LEGACY_USER, MYSQL_LEGACY_PASSWORD, MYSQL_LEGACY_PORT, MYSQL_LEGACY_DATABASE, MYSQL_LEGACY_HIDE_SYSTEM_DATABASES, MYSQL_LEGACY_QUERY_TIMEOUT, MYSQL_LEGACY_MAX_ROWS, MYSQL_LEGACY_MAX_RESULT_BYTES, MYSQL_LEGACY_CONNECT_TIMEOUT, MYSQL_LEGACY_POOL_SIZE, MYSQL_LEGACY_ALLOW_INSERT, MYSQL_LEGACY_ALLOW_UPDATE, MYSQL_LEGACY_ALLOW_DELETE, MYSQL_LEGACY_ALLOW_DDL, MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS. 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 needsnpx -y [email protected] # env: MYSQL_LEGACY_HOST, MYSQL_LEGACY_USER, MYSQL_LEGACY_PASSWORD, MYSQL_LEGACY_PORT, MYSQL_LEGACY_DATABASE, MYSQL_LEGACY_HIDE_SYSTEM_DATABASES, MYSQL_LEGACY_QUERY_TIMEOUT, MYSQL_LEGACY_MAX_ROWS, MYSQL_LEGACY_MAX_RESULT_BYTES, MYSQL_LEGACY_CONNECT_TIMEOUT, MYSQL_LEGACY_POOL_SIZE, MYSQL_LEGACY_ALLOW_INSERT, MYSQL_LEGACY_ALLOW_UPDATE, MYSQL_LEGACY_ALLOW_DELETE, MYSQL_LEGACY_ALLOW_DDL, MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS
{
"mcpServers": {
"mysql-legacy": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"MYSQL_LEGACY_HOST": "${MYSQL_LEGACY_HOST}",
"MYSQL_LEGACY_USER": "${MYSQL_LEGACY_USER}",
"MYSQL_LEGACY_PASSWORD": "${MYSQL_LEGACY_PASSWORD}",
"MYSQL_LEGACY_PORT": "${MYSQL_LEGACY_PORT}",
"MYSQL_LEGACY_DATABASE": "${MYSQL_LEGACY_DATABASE}",
"MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "${MYSQL_LEGACY_HIDE_SYSTEM_DATABASES}",
"MYSQL_LEGACY_QUERY_TIMEOUT": "${MYSQL_LEGACY_QUERY_TIMEOUT}",
"MYSQL_LEGACY_MAX_ROWS": "${MYSQL_LEGACY_MAX_ROWS}",
"MYSQL_LEGACY_MAX_RESULT_BYTES": "${MYSQL_LEGACY_MAX_RESULT_BYTES}",
"MYSQL_LEGACY_CONNECT_TIMEOUT": "${MYSQL_LEGACY_CONNECT_TIMEOUT}",
"MYSQL_LEGACY_POOL_SIZE": "${MYSQL_LEGACY_POOL_SIZE}",
"MYSQL_LEGACY_ALLOW_INSERT": "${MYSQL_LEGACY_ALLOW_INSERT}",
"MYSQL_LEGACY_ALLOW_UPDATE": "${MYSQL_LEGACY_ALLOW_UPDATE}",
"MYSQL_LEGACY_ALLOW_DELETE": "${MYSQL_LEGACY_ALLOW_DELETE}",
"MYSQL_LEGACY_ALLOW_DDL": "${MYSQL_LEGACY_ALLOW_DDL}",
"MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "${MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS}"
}
}
}
}
#!/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-legacy -e "MYSQL_LEGACY_HOST=${MYSQL_LEGACY_HOST}" -e "MYSQL_LEGACY_USER=${MYSQL_LEGACY_USER}" -e "MYSQL_LEGACY_PASSWORD=${MYSQL_LEGACY_PASSWORD}" -e "MYSQL_LEGACY_PORT=${MYSQL_LEGACY_PORT}" -e "MYSQL_LEGACY_DATABASE=${MYSQL_LEGACY_DATABASE}" -e "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES=${MYSQL_LEGACY_HIDE_SYSTEM_DATABASES}" -e "MYSQL_LEGACY_QUERY_TIMEOUT=${MYSQL_LEGACY_QUERY_TIMEOUT}" -e "MYSQL_LEGACY_MAX_ROWS=${MYSQL_LEGACY_MAX_ROWS}" -e "MYSQL_LEGACY_MAX_RESULT_BYTES=${MYSQL_LEGACY_MAX_RESULT_BYTES}" -e "MYSQL_LEGACY_CONNECT_TIMEOUT=${MYSQL_LEGACY_CONNECT_TIMEOUT}" -e "MYSQL_LEGACY_POOL_SIZE=${MYSQL_LEGACY_POOL_SIZE}" -e "MYSQL_LEGACY_ALLOW_INSERT=${MYSQL_LEGACY_ALLOW_INSERT}" -e "MYSQL_LEGACY_ALLOW_UPDATE=${MYSQL_LEGACY_ALLOW_UPDATE}" -e "MYSQL_LEGACY_ALLOW_DELETE=${MYSQL_LEGACY_ALLOW_DELETE}" -e "MYSQL_LEGACY_ALLOW_DDL=${MYSQL_LEGACY_ALLOW_DDL}" -e "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS=${MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS}" -- npx -y [email protected]
{
"mcpServers": {
"mysql-legacy": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"MYSQL_LEGACY_HOST": "${MYSQL_LEGACY_HOST}",
"MYSQL_LEGACY_USER": "${MYSQL_LEGACY_USER}",
"MYSQL_LEGACY_PASSWORD": "${MYSQL_LEGACY_PASSWORD}",
"MYSQL_LEGACY_PORT": "${MYSQL_LEGACY_PORT}",
"MYSQL_LEGACY_DATABASE": "${MYSQL_LEGACY_DATABASE}",
"MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "${MYSQL_LEGACY_HIDE_SYSTEM_DATABASES}",
"MYSQL_LEGACY_QUERY_TIMEOUT": "${MYSQL_LEGACY_QUERY_TIMEOUT}",
"MYSQL_LEGACY_MAX_ROWS": "${MYSQL_LEGACY_MAX_ROWS}",
"MYSQL_LEGACY_MAX_RESULT_BYTES": "${MYSQL_LEGACY_MAX_RESULT_BYTES}",
"MYSQL_LEGACY_CONNECT_TIMEOUT": "${MYSQL_LEGACY_CONNECT_TIMEOUT}",
"MYSQL_LEGACY_POOL_SIZE": "${MYSQL_LEGACY_POOL_SIZE}",
"MYSQL_LEGACY_ALLOW_INSERT": "${MYSQL_LEGACY_ALLOW_INSERT}",
"MYSQL_LEGACY_ALLOW_UPDATE": "${MYSQL_LEGACY_ALLOW_UPDATE}",
"MYSQL_LEGACY_ALLOW_DELETE": "${MYSQL_LEGACY_ALLOW_DELETE}",
"MYSQL_LEGACY_ALLOW_DDL": "${MYSQL_LEGACY_ALLOW_DDL}",
"MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "${MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS}"
}
}
}
}
{
"servers": {
"mysql-legacy": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"MYSQL_LEGACY_HOST": "${MYSQL_LEGACY_HOST}",
"MYSQL_LEGACY_USER": "${MYSQL_LEGACY_USER}",
"MYSQL_LEGACY_PASSWORD": "${MYSQL_LEGACY_PASSWORD}",
"MYSQL_LEGACY_PORT": "${MYSQL_LEGACY_PORT}",
"MYSQL_LEGACY_DATABASE": "${MYSQL_LEGACY_DATABASE}",
"MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "${MYSQL_LEGACY_HIDE_SYSTEM_DATABASES}",
"MYSQL_LEGACY_QUERY_TIMEOUT": "${MYSQL_LEGACY_QUERY_TIMEOUT}",
"MYSQL_LEGACY_MAX_ROWS": "${MYSQL_LEGACY_MAX_ROWS}",
"MYSQL_LEGACY_MAX_RESULT_BYTES": "${MYSQL_LEGACY_MAX_RESULT_BYTES}",
"MYSQL_LEGACY_CONNECT_TIMEOUT": "${MYSQL_LEGACY_CONNECT_TIMEOUT}",
"MYSQL_LEGACY_POOL_SIZE": "${MYSQL_LEGACY_POOL_SIZE}",
"MYSQL_LEGACY_ALLOW_INSERT": "${MYSQL_LEGACY_ALLOW_INSERT}",
"MYSQL_LEGACY_ALLOW_UPDATE": "${MYSQL_LEGACY_ALLOW_UPDATE}",
"MYSQL_LEGACY_ALLOW_DELETE": "${MYSQL_LEGACY_ALLOW_DELETE}",
"MYSQL_LEGACY_ALLOW_DDL": "${MYSQL_LEGACY_ALLOW_DDL}",
"MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "${MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.Rufflet/mysql-legacy-mcp
- not probed yet: tools unpinned, ingest lists them