MySQL MCP Server
mcpkey · packageio.github.musaddiq-dev/mysql-mcp-server · v0.1.2
Python MCP server for MySQL database inspection and querying
run it
on your own machines, one way per deploy methodgenerated 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 needsuvx 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.