DBHub
mcpkey · packageio.github.bytebase/dbhub · v1.5.0
Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite
run it
on your own machines, one way per deploy methodgenerated from the record, not tested yet
#!/usr/bin/env bash # dbhub (io.github.bytebase/dbhub), recipe baremetal (generated). # Generated by Hub for toolset "my-agent"; started by mcp-my-agent-dbhub.service. set -euo pipefail export HOST=127.0.0.1 PORT=8101 exec npx -y supergateway@4 --stdio 'npx -y @bytebase/[email protected]' --outputTransport streamableHttp --stateful --host 127.0.0.1 --port 8101 --streamableHttpPath /mcp --healthEndpoint /healthz [Unit] Description=MCP server dbhub (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/dbhub WorkingDirectory=/var/lib/mcp/dbhub ExecStart=/opt/mcp/my-agent/bin/dbhub.sh Restart=on-failure RestartSec=5 NoNewPrivileges=true ProtectSystem=strict ProtectHome=true PrivateTmp=true ReadWritePaths=/var/lib/mcp/dbhub [Install] WantedBy=multi-user.target
generated from the record, not tested yet
docker run --rm -p 127.0.0.1:8101:8000 -e DSN -e DB_TYPE -e DB_HOST -e DB_PORT -e DB_USER -e DB_PASSWORD -e DB_NAME -e TRANSPORT -e PORT -e ID -e SSH_HOST -e SSH_PORT -e SSH_USER -e SSH_PASSWORD -e SSH_KEY -e SSH_PASSPHRASE -e SSH_AUTH_SOCK node:22-alpine sh -c 'npx -y supergateway@4 --stdio '"'"'npx -y @bytebase/[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-18T00:53:10+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:
dbhub:
image: node:22-alpine
command:
- sh
- -c
- npx -y supergateway@4 --stdio 'npx -y @bytebase/[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:
DSN: ${DSN}
DB_TYPE: ${DB_TYPE}
DB_HOST: ${DB_HOST}
DB_PORT: ${DB_PORT}
DB_USER: ${DB_USER}
DB_PASSWORD: ${DB_PASSWORD}
DB_NAME: ${DB_NAME}
TRANSPORT: ${TRANSPORT}
PORT: ${PORT}
ID: ${ID}
SSH_HOST: ${SSH_HOST}
SSH_PORT: ${SSH_PORT}
SSH_USER: ${SSH_USER}
SSH_PASSWORD: ${SSH_PASSWORD}
SSH_KEY: ${SSH_KEY}
SSH_PASSPHRASE: ${SSH_PASSPHRASE}
SSH_AUTH_SOCK: ${SSH_AUTH_SOCK}
volumes:
npm-cache: {}
uv-cache: {}
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T00:53:10+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: dbhub
namespace: mcp
labels: &id001
app: dbhub
spec:
replicas: 1
selector:
matchLabels: *id001
template:
metadata:
labels: *id001
spec:
containers:
- name: dbhub
image: node:22-alpine
ports:
- containerPort: 8000
name: http
env:
- name: DSN
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DSN
- name: DB_TYPE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_TYPE
- name: DB_HOST
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_HOST
- name: DB_PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_PORT
- name: DB_USER
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_USER
- name: DB_PASSWORD
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_PASSWORD
- name: DB_NAME
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_NAME
- name: TRANSPORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: TRANSPORT
- name: PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: PORT
- name: ID
valueFrom:
secretKeyRef:
name: mcp-credentials
key: ID
- name: SSH_HOST
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_HOST
- name: SSH_PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_PORT
- name: SSH_USER
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_USER
- name: SSH_PASSWORD
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_PASSWORD
- name: SSH_KEY
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_KEY
- name: SSH_PASSPHRASE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_PASSPHRASE
- name: SSH_AUTH_SOCK
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_AUTH_SOCK
command:
- sh
- -c
- npx -y supergateway@4 --stdio 'npx -y @bytebase/[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: dbhub
namespace: mcp
spec:
selector:
app: dbhub
ports:
- port: 8000
targetPort: http
name: http
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T00:53:10+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:
dbhub:
enabled: true
replicas: 1
port: 8000
path: /mcp
container:
name: dbhub
image: node:22-alpine
ports:
- containerPort: 8000
name: http
env:
- name: DSN
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DSN
- name: DB_TYPE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_TYPE
- name: DB_HOST
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_HOST
- name: DB_PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_PORT
- name: DB_USER
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_USER
- name: DB_PASSWORD
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_PASSWORD
- name: DB_NAME
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DB_NAME
- name: TRANSPORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: TRANSPORT
- name: PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: PORT
- name: ID
valueFrom:
secretKeyRef:
name: mcp-credentials
key: ID
- name: SSH_HOST
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_HOST
- name: SSH_PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_PORT
- name: SSH_USER
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_USER
- name: SSH_PASSWORD
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_PASSWORD
- name: SSH_KEY
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_KEY
- name: SSH_PASSPHRASE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_PASSPHRASE
- name: SSH_AUTH_SOCK
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SSH_AUTH_SOCK
command:
- sh
- -c
- npx -y supergateway@4 --stdio 'npx -y @bytebase/[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: DSN, DB_TYPE, DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, DB_NAME, TRANSPORT, PORT, ID, SSH_HOST, SSH_PORT, SSH_USER, SSH_PASSWORD, SSH_KEY, SSH_PASSPHRASE, SSH_AUTH_SOCK. 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 @bytebase/[email protected] # env: DSN, DB_TYPE, DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, DB_NAME, TRANSPORT, PORT, ID, SSH_HOST, SSH_PORT, SSH_USER, SSH_PASSWORD, SSH_KEY, SSH_PASSPHRASE, SSH_AUTH_SOCK
{
"mcpServers": {
"dbhub": {
"command": "npx",
"args": [
"-y",
"@bytebase/[email protected]"
],
"env": {
"DSN": "${DSN}",
"DB_TYPE": "${DB_TYPE}",
"DB_HOST": "${DB_HOST}",
"DB_PORT": "${DB_PORT}",
"DB_USER": "${DB_USER}",
"DB_PASSWORD": "${DB_PASSWORD}",
"DB_NAME": "${DB_NAME}",
"TRANSPORT": "${TRANSPORT}",
"PORT": "${PORT}",
"ID": "${ID}",
"SSH_HOST": "${SSH_HOST}",
"SSH_PORT": "${SSH_PORT}",
"SSH_USER": "${SSH_USER}",
"SSH_PASSWORD": "${SSH_PASSWORD}",
"SSH_KEY": "${SSH_KEY}",
"SSH_PASSPHRASE": "${SSH_PASSPHRASE}",
"SSH_AUTH_SOCK": "${SSH_AUTH_SOCK}"
}
}
}
}
#!/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 dbhub -e "DSN=${DSN}" -e "DB_TYPE=${DB_TYPE}" -e "DB_HOST=${DB_HOST}" -e "DB_PORT=${DB_PORT}" -e "DB_USER=${DB_USER}" -e "DB_PASSWORD=${DB_PASSWORD}" -e "DB_NAME=${DB_NAME}" -e "TRANSPORT=${TRANSPORT}" -e "PORT=${PORT}" -e "ID=${ID}" -e "SSH_HOST=${SSH_HOST}" -e "SSH_PORT=${SSH_PORT}" -e "SSH_USER=${SSH_USER}" -e "SSH_PASSWORD=${SSH_PASSWORD}" -e "SSH_KEY=${SSH_KEY}" -e "SSH_PASSPHRASE=${SSH_PASSPHRASE}" -e "SSH_AUTH_SOCK=${SSH_AUTH_SOCK}" -- npx -y @bytebase/[email protected]
{
"mcpServers": {
"dbhub": {
"command": "npx",
"args": [
"-y",
"@bytebase/[email protected]"
],
"env": {
"DSN": "${DSN}",
"DB_TYPE": "${DB_TYPE}",
"DB_HOST": "${DB_HOST}",
"DB_PORT": "${DB_PORT}",
"DB_USER": "${DB_USER}",
"DB_PASSWORD": "${DB_PASSWORD}",
"DB_NAME": "${DB_NAME}",
"TRANSPORT": "${TRANSPORT}",
"PORT": "${PORT}",
"ID": "${ID}",
"SSH_HOST": "${SSH_HOST}",
"SSH_PORT": "${SSH_PORT}",
"SSH_USER": "${SSH_USER}",
"SSH_PASSWORD": "${SSH_PASSWORD}",
"SSH_KEY": "${SSH_KEY}",
"SSH_PASSPHRASE": "${SSH_PASSPHRASE}",
"SSH_AUTH_SOCK": "${SSH_AUTH_SOCK}"
}
}
}
}
{
"servers": {
"dbhub": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@bytebase/[email protected]"
],
"env": {
"DSN": "${DSN}",
"DB_TYPE": "${DB_TYPE}",
"DB_HOST": "${DB_HOST}",
"DB_PORT": "${DB_PORT}",
"DB_USER": "${DB_USER}",
"DB_PASSWORD": "${DB_PASSWORD}",
"DB_NAME": "${DB_NAME}",
"TRANSPORT": "${TRANSPORT}",
"PORT": "${PORT}",
"ID": "${ID}",
"SSH_HOST": "${SSH_HOST}",
"SSH_PORT": "${SSH_PORT}",
"SSH_USER": "${SSH_USER}",
"SSH_PASSWORD": "${SSH_PASSWORD}",
"SSH_KEY": "${SSH_KEY}",
"SSH_PASSPHRASE": "${SSH_PASSPHRASE}",
"SSH_AUTH_SOCK": "${SSH_AUTH_SOCK}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.bytebase/dbhub
- 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.