universal-db-mcp
mcpkey · packageio.github.Fashad-Ahmed/universal-db-mcp · v1.1.2
Security-first MCP server for PostgreSQL, SQLite, MySQL, DuckDB with SQL injection prevention.
run it
on your own machines, one way per deploy methodgenerated from the record, not tested yet
# once, as root:
# as_mcp DIR COMMAND...: runs COMMAND as the mcp user in DIR, its home, sandboxed as the
# units are: a package's install scripts can write to DIR only, as the server later can
as_mcp() {
local dir="$1"; shift
systemd-run --quiet --wait --pipe --collect --uid=mcp --gid=mcp \
-p WorkingDirectory="$dir" -p Environment=HOME="$dir" -p ReadWritePaths="$dir" \
-p NoNewPrivileges=true -p ProtectSystem=strict -p ProtectHome=true -p PrivateTmp=true \
-- "$@" </dev/null
}
install -d -m 0750 -o mcp -g mcp /var/lib/mcp/universal-db
# universal-db: its packages, installed whole before its unit starts (no session installs)
systemctl stop mcp-my-agent-universal-db.service 2>/dev/null || true
as_mcp /var/lib/mcp/universal-db uv tool install universal-db-mcp==1.1.2
as_mcp /var/lib/mcp/universal-db uv tool install mcp-proxy
#!/usr/bin/env bash
# universal-db (io.github.Fashad-Ahmed/universal-db-mcp), recipe baremetal (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-universal-db.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 universal-db-mcp==1.1.2
[Unit]
Description=MCP server universal-db (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/universal-db
WorkingDirectory=/var/lib/mcp/universal-db
ExecStart=/opt/mcp/my-agent/bin/universal-db.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/universal-db
[Install]
WantedBy=multi-user.target
generated from the record, not tested yet
docker run --rm -p 127.0.0.1:8101:8000 -e POSTGRES_URI -e SQLITE_PATH -e MYSQL_URI -e DUCKDB_PATH -e ALLOW_DESTRUCTIVE -e MAX_RESULT_ROWS ghcr.io/astral-sh/uv:python3.12-bookworm-slim sh -c 'uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx universal-db-mcp==1.1.2'
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T17:39:57+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:
universal-db:
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 universal-db-mcp==1.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:
POSTGRES_URI: ${POSTGRES_URI}
SQLITE_PATH: ${SQLITE_PATH}
MYSQL_URI: ${MYSQL_URI}
DUCKDB_PATH: ${DUCKDB_PATH}
ALLOW_DESTRUCTIVE: ${ALLOW_DESTRUCTIVE}
MAX_RESULT_ROWS: ${MAX_RESULT_ROWS}
volumes:
npm-cache: {}
uv-cache: {}
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T17:39:57+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: universal-db
namespace: mcp
labels: &id001
app: universal-db
spec:
replicas: 1
selector:
matchLabels: *id001
template:
metadata:
labels: *id001
spec:
containers:
- name: universal-db
image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
ports:
- containerPort: 8000
name: http
env:
- name: POSTGRES_URI
valueFrom:
secretKeyRef:
name: mcp-credentials
key: POSTGRES_URI
- name: SQLITE_PATH
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SQLITE_PATH
- name: MYSQL_URI
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_URI
- name: DUCKDB_PATH
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DUCKDB_PATH
- name: ALLOW_DESTRUCTIVE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: ALLOW_DESTRUCTIVE
- name: MAX_RESULT_ROWS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MAX_RESULT_ROWS
args:
- sh
- -c
- uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx universal-db-mcp==1.1.2
readinessProbe:
httpGet:
path: /status
port: http
initialDelaySeconds: 10
---
apiVersion: v1
kind: Service
metadata:
name: universal-db
namespace: mcp
spec:
selector:
app: universal-db
ports:
- port: 8000
targetPort: http
name: http
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T17:39:57+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:
universal-db:
enabled: true
replicas: 1
port: 8000
path: /mcp
container:
name: universal-db
image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
ports:
- containerPort: 8000
name: http
env:
- name: POSTGRES_URI
valueFrom:
secretKeyRef:
name: mcp-credentials
key: POSTGRES_URI
- name: SQLITE_PATH
valueFrom:
secretKeyRef:
name: mcp-credentials
key: SQLITE_PATH
- name: MYSQL_URI
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MYSQL_URI
- name: DUCKDB_PATH
valueFrom:
secretKeyRef:
name: mcp-credentials
key: DUCKDB_PATH
- name: ALLOW_DESTRUCTIVE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: ALLOW_DESTRUCTIVE
- name: MAX_RESULT_ROWS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: MAX_RESULT_ROWS
args:
- sh
- -c
- uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx universal-db-mcp==1.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: POSTGRES_URI, SQLITE_PATH, MYSQL_URI, DUCKDB_PATH, ALLOW_DESTRUCTIVE, MAX_RESULT_ROWS. 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 universal-db-mcp==1.1.2 # env: POSTGRES_URI, SQLITE_PATH, MYSQL_URI, DUCKDB_PATH, ALLOW_DESTRUCTIVE, MAX_RESULT_ROWS
{
"mcpServers": {
"universal-db": {
"command": "uvx",
"args": [
"universal-db-mcp==1.1.2"
],
"env": {
"POSTGRES_URI": "${POSTGRES_URI}",
"SQLITE_PATH": "${SQLITE_PATH}",
"MYSQL_URI": "${MYSQL_URI}",
"DUCKDB_PATH": "${DUCKDB_PATH}",
"ALLOW_DESTRUCTIVE": "${ALLOW_DESTRUCTIVE}",
"MAX_RESULT_ROWS": "${MAX_RESULT_ROWS}"
}
}
}
}
#!/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 universal-db -e "POSTGRES_URI=${POSTGRES_URI}" -e "SQLITE_PATH=${SQLITE_PATH}" -e "MYSQL_URI=${MYSQL_URI}" -e "DUCKDB_PATH=${DUCKDB_PATH}" -e "ALLOW_DESTRUCTIVE=${ALLOW_DESTRUCTIVE}" -e "MAX_RESULT_ROWS=${MAX_RESULT_ROWS}" -- uvx universal-db-mcp==1.1.2
{
"mcpServers": {
"universal-db": {
"command": "uvx",
"args": [
"universal-db-mcp==1.1.2"
],
"env": {
"POSTGRES_URI": "${POSTGRES_URI}",
"SQLITE_PATH": "${SQLITE_PATH}",
"MYSQL_URI": "${MYSQL_URI}",
"DUCKDB_PATH": "${DUCKDB_PATH}",
"ALLOW_DESTRUCTIVE": "${ALLOW_DESTRUCTIVE}",
"MAX_RESULT_ROWS": "${MAX_RESULT_ROWS}"
}
}
}
}
{
"servers": {
"universal-db": {
"type": "stdio",
"command": "uvx",
"args": [
"universal-db-mcp==1.1.2"
],
"env": {
"POSTGRES_URI": "${POSTGRES_URI}",
"SQLITE_PATH": "${SQLITE_PATH}",
"MYSQL_URI": "${MYSQL_URI}",
"DUCKDB_PATH": "${DUCKDB_PATH}",
"ALLOW_DESTRUCTIVE": "${ALLOW_DESTRUCTIVE}",
"MAX_RESULT_ROWS": "${MAX_RESULT_ROWS}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.Fashad-Ahmed/universal-db-mcp
- 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.