fabric-dw
mcpotherio.github.sdebruyn/fabric-dw-mcp · v2026.9.0
MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints
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
# fabric-dw (io.github.sdebruyn/fabric-dw-mcp), recipe docker (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-fabric-dw.service.
set -euo pipefail
export HOST=127.0.0.1 PORT=8101
exec docker run --rm --name mcp-my-agent-fabric-dw -p 127.0.0.1:${PORT}:8000 -e FABRIC_AUTH -e FABRIC_MCP_READONLY -e FABRIC_MCP_ALLOW_DESTRUCTIVE -e FABRIC_MCP_WORKSPACES -e FABRIC_MCP_ALLOW_REMOTE -e FABRIC_LOG_LEVEL ghcr.io/sdebruyn/fabric-dw:2026.9.0
[Unit]
Description=MCP server fabric-dw (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/fabric-dw
WorkingDirectory=/var/lib/mcp/fabric-dw
ExecStart=/opt/mcp/my-agent/bin/fabric-dw.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/fabric-dw
[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 FABRIC_AUTH -e FABRIC_MCP_READONLY -e FABRIC_MCP_ALLOW_DESTRUCTIVE -e FABRIC_MCP_WORKSPACES -e FABRIC_MCP_ALLOW_REMOTE -e FABRIC_LOG_LEVEL ghcr.io/sdebruyn/fabric-dw:2026.9.0
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-18T22:55:01+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:
fabric-dw:
image: ghcr.io/sdebruyn/fabric-dw:2026.9.0
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:
FABRIC_AUTH: ${FABRIC_AUTH}
FABRIC_MCP_READONLY: ${FABRIC_MCP_READONLY}
FABRIC_MCP_ALLOW_DESTRUCTIVE: ${FABRIC_MCP_ALLOW_DESTRUCTIVE}
FABRIC_MCP_WORKSPACES: ${FABRIC_MCP_WORKSPACES}
FABRIC_MCP_ALLOW_REMOTE: ${FABRIC_MCP_ALLOW_REMOTE}
FABRIC_LOG_LEVEL: ${FABRIC_LOG_LEVEL}
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-18T22:55:01+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: fabric-dw
namespace: mcp
labels: &id001
app: fabric-dw
spec:
replicas: 1
selector:
matchLabels: *id001
template:
metadata:
labels: *id001
spec:
containers:
- name: fabric-dw
image: ghcr.io/sdebruyn/fabric-dw:2026.9.0
ports:
- containerPort: 8000
name: http
env:
- name: FABRIC_AUTH
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_AUTH
- name: FABRIC_MCP_READONLY
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_MCP_READONLY
- name: FABRIC_MCP_ALLOW_DESTRUCTIVE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_MCP_ALLOW_DESTRUCTIVE
- name: FABRIC_MCP_WORKSPACES
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_MCP_WORKSPACES
- name: FABRIC_MCP_ALLOW_REMOTE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_MCP_ALLOW_REMOTE
- name: FABRIC_LOG_LEVEL
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_LOG_LEVEL
---
apiVersion: v1
kind: Service
metadata:
name: fabric-dw
namespace: mcp
spec:
selector:
app: fabric-dw
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-18T22:55:01+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:
fabric-dw:
enabled: true
replicas: 1
port: 8000
path: /mcp
container:
name: fabric-dw
image: ghcr.io/sdebruyn/fabric-dw:2026.9.0
ports:
- containerPort: 8000
name: http
env:
- name: FABRIC_AUTH
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_AUTH
- name: FABRIC_MCP_READONLY
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_MCP_READONLY
- name: FABRIC_MCP_ALLOW_DESTRUCTIVE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_MCP_ALLOW_DESTRUCTIVE
- name: FABRIC_MCP_WORKSPACES
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_MCP_WORKSPACES
- name: FABRIC_MCP_ALLOW_REMOTE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_MCP_ALLOW_REMOTE
- name: FABRIC_LOG_LEVEL
valueFrom:
secretKeyRef:
name: mcp-credentials
key: FABRIC_LOG_LEVEL
# 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: FABRIC_AUTH, FABRIC_MCP_READONLY, FABRIC_MCP_ALLOW_DESTRUCTIVE, FABRIC_MCP_WORKSPACES, FABRIC_MCP_ALLOW_REMOTE, FABRIC_LOG_LEVEL. 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 FABRIC_AUTH -e FABRIC_MCP_READONLY -e FABRIC_MCP_ALLOW_DESTRUCTIVE -e FABRIC_MCP_WORKSPACES -e FABRIC_MCP_ALLOW_REMOTE -e FABRIC_LOG_LEVEL ghcr.io/sdebruyn/fabric-dw:2026.9.0
{
"mcpServers": {
"fabric-dw": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"FABRIC_AUTH",
"-e",
"FABRIC_MCP_READONLY",
"-e",
"FABRIC_MCP_ALLOW_DESTRUCTIVE",
"-e",
"FABRIC_MCP_WORKSPACES",
"-e",
"FABRIC_MCP_ALLOW_REMOTE",
"-e",
"FABRIC_LOG_LEVEL",
"ghcr.io/sdebruyn/fabric-dw:2026.9.0"
],
"env": {
"FABRIC_AUTH": "${FABRIC_AUTH}",
"FABRIC_MCP_READONLY": "${FABRIC_MCP_READONLY}",
"FABRIC_MCP_ALLOW_DESTRUCTIVE": "${FABRIC_MCP_ALLOW_DESTRUCTIVE}",
"FABRIC_MCP_WORKSPACES": "${FABRIC_MCP_WORKSPACES}",
"FABRIC_MCP_ALLOW_REMOTE": "${FABRIC_MCP_ALLOW_REMOTE}",
"FABRIC_LOG_LEVEL": "${FABRIC_LOG_LEVEL}"
}
}
}
}
#!/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 fabric-dw -e "FABRIC_AUTH=${FABRIC_AUTH}" -e "FABRIC_MCP_READONLY=${FABRIC_MCP_READONLY}" -e "FABRIC_MCP_ALLOW_DESTRUCTIVE=${FABRIC_MCP_ALLOW_DESTRUCTIVE}" -e "FABRIC_MCP_WORKSPACES=${FABRIC_MCP_WORKSPACES}" -e "FABRIC_MCP_ALLOW_REMOTE=${FABRIC_MCP_ALLOW_REMOTE}" -e "FABRIC_LOG_LEVEL=${FABRIC_LOG_LEVEL}" -- docker run -i --rm -e FABRIC_AUTH -e FABRIC_MCP_READONLY -e FABRIC_MCP_ALLOW_DESTRUCTIVE -e FABRIC_MCP_WORKSPACES -e FABRIC_MCP_ALLOW_REMOTE -e FABRIC_LOG_LEVEL ghcr.io/sdebruyn/fabric-dw:2026.9.0
{
"mcpServers": {
"fabric-dw": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"FABRIC_AUTH",
"-e",
"FABRIC_MCP_READONLY",
"-e",
"FABRIC_MCP_ALLOW_DESTRUCTIVE",
"-e",
"FABRIC_MCP_WORKSPACES",
"-e",
"FABRIC_MCP_ALLOW_REMOTE",
"-e",
"FABRIC_LOG_LEVEL",
"ghcr.io/sdebruyn/fabric-dw:2026.9.0"
],
"env": {
"FABRIC_AUTH": "${FABRIC_AUTH}",
"FABRIC_MCP_READONLY": "${FABRIC_MCP_READONLY}",
"FABRIC_MCP_ALLOW_DESTRUCTIVE": "${FABRIC_MCP_ALLOW_DESTRUCTIVE}",
"FABRIC_MCP_WORKSPACES": "${FABRIC_MCP_WORKSPACES}",
"FABRIC_MCP_ALLOW_REMOTE": "${FABRIC_MCP_ALLOW_REMOTE}",
"FABRIC_LOG_LEVEL": "${FABRIC_LOG_LEVEL}"
}
}
}
}
{
"servers": {
"fabric-dw": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"FABRIC_AUTH",
"-e",
"FABRIC_MCP_READONLY",
"-e",
"FABRIC_MCP_ALLOW_DESTRUCTIVE",
"-e",
"FABRIC_MCP_WORKSPACES",
"-e",
"FABRIC_MCP_ALLOW_REMOTE",
"-e",
"FABRIC_LOG_LEVEL",
"ghcr.io/sdebruyn/fabric-dw:2026.9.0"
],
"env": {
"FABRIC_AUTH": "${FABRIC_AUTH}",
"FABRIC_MCP_READONLY": "${FABRIC_MCP_READONLY}",
"FABRIC_MCP_ALLOW_DESTRUCTIVE": "${FABRIC_MCP_ALLOW_DESTRUCTIVE}",
"FABRIC_MCP_WORKSPACES": "${FABRIC_MCP_WORKSPACES}",
"FABRIC_MCP_ALLOW_REMOTE": "${FABRIC_MCP_ALLOW_REMOTE}",
"FABRIC_LOG_LEVEL": "${FABRIC_LOG_LEVEL}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.sdebruyn/fabric-dw-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.