SQL MCP Server
mcpotherio.github.nethinwei/sql-mcp-server · v0.1.17
Controlled SQL access gateway with policy, cost limits, tenant isolation, and safe tools.
run it
on your own machines, one way per deploy methodgenerated from the record, not tested yet
CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
#!/usr/bin/env bash
# sql (io.github.nethinwei/sql-mcp-server), recipe docker (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-sql.service.
set -euo pipefail
export HOST=127.0.0.1 PORT=8101
exec docker run --rm --name mcp-my-agent-sql -p 127.0.0.1:${PORT}:8000 --env-file /etc/mcp/my-agent.env ghcr.io/nethinwei/sql-mcp-server:0.1.17
[Unit]
Description=MCP server sql (toolset my-agent), generated by Hub
After=network-online.target docker.service
Wants=network-online.target
[Service]
Type=simple
User=mcp
Group=mcp
SupplementaryGroups=docker
EnvironmentFile=/etc/mcp/my-agent.env
Environment=HOME=/var/lib/mcp/sql
WorkingDirectory=/var/lib/mcp/sql
ExecStart=/opt/mcp/my-agent/bin/sql.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/sql
[Install]
WantedBy=multi-user.target
generated from the record, not tested yet
CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
docker run --rm -p 127.0.0.1:8101:8000 -e DATABASE_DSN ghcr.io/nethinwei/sql-mcp-server:0.1.17
generated from the record, not tested yet
CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
# Generated by Hub for toolset "my-agent" (2026-10-17T23:24:37+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:
sql:
image: ghcr.io/nethinwei/sql-mcp-server:0.1.17
ports:
- 127.0.0.1:8101:8000
restart: unless-stopped
x-note: 'CHANGE_ME: check the image''s README for its transport and port; this assumes streamable
HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command
instead.'
environment:
DATABASE_DSN: ${DATABASE_DSN}
volumes:
npm-cache: {}
uv-cache: {}
generated from the record, not tested yet
CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
# Generated by Hub for toolset "my-agent" (2026-10-17T23:24:37+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: sql
namespace: mcp
labels: &id001
app: sql
spec:
replicas: 1
selector:
matchLabels: *id001
template:
metadata:
labels: *id001
spec:
containers:
- name: sql
image: ghcr.io/nethinwei/sql-mcp-server:0.1.17
ports:
- containerPort: 8000
name: http
env:
- name: DATABASE_DSN
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DATABASE_DSN
---
apiVersion: v1
kind: Service
metadata:
name: sql
namespace: mcp
spec:
selector:
app: sql
ports:
- port: 8000
targetPort: http
name: http
generated from the record, not tested yet
CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
# Generated by Hub for toolset "my-agent" (2026-10-17T23:24:37+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:
sql:
enabled: true
replicas: 1
port: 8000
path: /mcp
container:
name: sql
image: ghcr.io/nethinwei/sql-mcp-server:0.1.17
ports:
- containerPort: 8000
name: http
env:
- name: DATABASE_DSN
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DATABASE_DSN
# 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: DATABASE_DSN. 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 needsdocker run -i --rm -e DATABASE_DSN ghcr.io/nethinwei/sql-mcp-server:0.1.17
{
"mcpServers": {
"sql": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"DATABASE_DSN",
"ghcr.io/nethinwei/sql-mcp-server:0.1.17"
],
"env": {
"DATABASE_DSN": "${DATABASE_DSN}"
}
}
}
}
#!/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 sql -e "DATABASE_DSN=${DATABASE_DSN}" -- docker run -i --rm -e DATABASE_DSN ghcr.io/nethinwei/sql-mcp-server:0.1.17
{
"mcpServers": {
"sql": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"DATABASE_DSN",
"ghcr.io/nethinwei/sql-mcp-server:0.1.17"
],
"env": {
"DATABASE_DSN": "${DATABASE_DSN}"
}
}
}
}
{
"servers": {
"sql": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"DATABASE_DSN",
"ghcr.io/nethinwei/sql-mcp-server:0.1.17"
],
"env": {
"DATABASE_DSN": "${DATABASE_DSN}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.nethinwei/sql-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.