MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints
Connect Runs on your machine
claude mcp add fabric-dw-mcp -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 ghcr.io/sdebruyn/fabric-dw:2026.9.0
{
"mcpServers": {
"fabric-dw-mcp": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"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>"
}
}
}
}
{
"mcpServers": {
"fabric-dw-mcp": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"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-mcp": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"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>"
}
}
}
}
Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
FABRIC_AUTHOptional | Azure credential source: 'default' (DefaultAzureCredential chain), 'sp' (service principal, needs AZURE_TENANT_ID/AZURE_CLIENT_ID/AZURE_CLIENT_SECRET), or 'interactive' (browser sign-in). |
FABRIC_MCP_READONLYOptional | Set to 1 to restrict execute_sql to SELECT/WITH statements and block all mutating tools. |
FABRIC_MCP_ALLOW_DESTRUCTIVEOptional | Set to 1 to enable permanently-destructive tools (delete_*, clear_table, restore_warehouse_in_place). Disabled by default. |
FABRIC_MCP_WORKSPACESOptional | Comma-separated workspace names or GUIDs the server may touch. Unset allows all workspaces. |
FABRIC_MCP_ALLOW_REMOTEOptional | Set to 1 to allow the HTTP transport to bind on a non-loopback address. Always front with an authenticating reverse proxy. |
FABRIC_LOG_LEVELOptional | Log level for the MCP server (DEBUG, INFO, WARNING, ERROR, CRITICAL). |
Details
| Package | ghcr.io/sdebruyn/fabric-dw:2026.9.0 (OCI, stdio) |
| First published | 9 Sep 2026 |
| Last updated | 9 Sep 2026 |
| Registry name | io.github.sdebruyn/fabric-dw-mcp |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.
