NestDaddy

fabric-dw

io.github.sdebruyn/fabric-dw-mcp · v2026.9.0

MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints

Connect Runs on your machine

Terminal
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
claude_desktop_config.json
{
  "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>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "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>"
      }
    }
  }
}
.vscode/mcp.json
{
  "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

NameDescription
FABRIC_AUTH
Optional
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_READONLY
Optional
Set to 1 to restrict execute_sql to SELECT/WITH statements and block all mutating tools.
FABRIC_MCP_ALLOW_DESTRUCTIVE
Optional
Set to 1 to enable permanently-destructive tools (delete_*, clear_table, restore_warehouse_in_place). Disabled by default.
FABRIC_MCP_WORKSPACES
Optional
Comma-separated workspace names or GUIDs the server may touch. Unset allows all workspaces.
FABRIC_MCP_ALLOW_REMOTE
Optional
Set to 1 to allow the HTTP transport to bind on a non-loopback address. Always front with an authenticating reverse proxy.
FABRIC_LOG_LEVEL
Optional
Log level for the MCP server (DEBUG, INFO, WARNING, ERROR, CRITICAL).

Details

Packageghcr.io/sdebruyn/fabric-dw:2026.9.0 (OCI, stdio)
First published9 Sep 2026
Last updated9 Sep 2026
Registry nameio.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.