fabric-dw MCP Server

Name: fabric-dw MCP Server
Author: io.github.sdebruyn

io.github.sdebruyn/fabric-dw-mcp

Repository Registry

What is the fabric-dw MCP server?

MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints

How to install fabric-dw

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

FABRIC_AUTH
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
Set to 1 to restrict execute_sql to SELECT/WITH statements and block all mutating tools.
FABRIC_MCP_ALLOW_DESTRUCTIVE
Set to 1 to enable permanently-destructive tools (delete_*, clear_table, restore_warehouse_in_place). Disabled by default.
FABRIC_MCP_WORKSPACES
Comma-separated workspace names or GUIDs the server may touch. Unset allows all workspaces.
FABRIC_MCP_ALLOW_REMOTE
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
Log level for the MCP server (DEBUG, INFO, WARNING, ERROR, CRITICAL).

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "fabric-dw-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/sdebruyn/fabric-dw:2026.7.3"
      ],
      "env": {
        "FABRIC_AUTH": "<YOUR_FABRIC_AUTH>",
        "FABRIC_MCP_READONLY": "<YOUR_FABRIC_MCP_READONLY>",
        "FABRIC_MCP_ALLOW_DESTRUCTIVE": "<YOUR_FABRIC_MCP_ALLOW_DESTRUCTIVE>",
        "FABRIC_MCP_WORKSPACES": "<YOUR_FABRIC_MCP_WORKSPACES>",
        "FABRIC_MCP_ALLOW_REMOTE": "<YOUR_FABRIC_MCP_ALLOW_REMOTE>",
        "FABRIC_LOG_LEVEL": "<YOUR_FABRIC_LOG_LEVEL>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "fabric-dw-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/sdebruyn/fabric-dw:2026.7.3"
      ],
      "env": {
        "FABRIC_AUTH": "<YOUR_FABRIC_AUTH>",
        "FABRIC_MCP_READONLY": "<YOUR_FABRIC_MCP_READONLY>",
        "FABRIC_MCP_ALLOW_DESTRUCTIVE": "<YOUR_FABRIC_MCP_ALLOW_DESTRUCTIVE>",
        "FABRIC_MCP_WORKSPACES": "<YOUR_FABRIC_MCP_WORKSPACES>",
        "FABRIC_MCP_ALLOW_REMOTE": "<YOUR_FABRIC_MCP_ALLOW_REMOTE>",
        "FABRIC_LOG_LEVEL": "<YOUR_FABRIC_LOG_LEVEL>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "fabric-dw-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/sdebruyn/fabric-dw:2026.7.3"
      ],
      "env": {
        "FABRIC_AUTH": "<YOUR_FABRIC_AUTH>",
        "FABRIC_MCP_READONLY": "<YOUR_FABRIC_MCP_READONLY>",
        "FABRIC_MCP_ALLOW_DESTRUCTIVE": "<YOUR_FABRIC_MCP_ALLOW_DESTRUCTIVE>",
        "FABRIC_MCP_WORKSPACES": "<YOUR_FABRIC_MCP_WORKSPACES>",
        "FABRIC_MCP_ALLOW_REMOTE": "<YOUR_FABRIC_MCP_ALLOW_REMOTE>",
        "FABRIC_LOG_LEVEL": "<YOUR_FABRIC_LOG_LEVEL>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "fabric-dw-mcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/sdebruyn/fabric-dw:2026.7.3"
      ],
      "env": {
        "FABRIC_AUTH": "<YOUR_FABRIC_AUTH>",
        "FABRIC_MCP_READONLY": "<YOUR_FABRIC_MCP_READONLY>",
        "FABRIC_MCP_ALLOW_DESTRUCTIVE": "<YOUR_FABRIC_MCP_ALLOW_DESTRUCTIVE>",
        "FABRIC_MCP_WORKSPACES": "<YOUR_FABRIC_MCP_WORKSPACES>",
        "FABRIC_MCP_ALLOW_REMOTE": "<YOUR_FABRIC_MCP_ALLOW_REMOTE>",
        "FABRIC_LOG_LEVEL": "<YOUR_FABRIC_LOG_LEVEL>"
      }
    }
  }
}

Claude Code

claude mcp add fabric-dw-mcp --env FABRIC_AUTH=<YOUR_FABRIC_AUTH> --env FABRIC_MCP_READONLY=<YOUR_FABRIC_MCP_READONLY> --env FABRIC_MCP_ALLOW_DESTRUCTIVE=<YOUR_FABRIC_MCP_ALLOW_DESTRUCTIVE> --env FABRIC_MCP_WORKSPACES=<YOUR_FABRIC_MCP_WORKSPACES> --env FABRIC_MCP_ALLOW_REMOTE=<YOUR_FABRIC_MCP_ALLOW_REMOTE> --env FABRIC_LOG_LEVEL=<YOUR_FABRIC_LOG_LEVEL> -- docker run -i --rm ghcr.io/sdebruyn/fabric-dw:2026.7.3