Skip to content
MCP server

fabric-dw

MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints

Runs locally
Install
Pricing
Open source
Runs
Locally
Version
2026.9.0
Listing updated
2 months ago

About fabric-dw

fabric-dw is an open-source MCP server. It runs locally on your machine and is started by your AI client.

Install

Run in a terminal

claude mcp add fabric-dw-mcp -- docker run -i --rm ghcr.io/sdebruyn/fabric-dw:2026.9.0

Add to claude_desktop_config.json

{
  "mcpServers": {
    "fabric-dw-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/sdebruyn/fabric-dw:2026.9.0"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "fabric-dw-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/sdebruyn/fabric-dw:2026.9.0"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "fabric-dw-mcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/sdebruyn/fabric-dw:2026.9.0"
      ]
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "fabric-dw-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/sdebruyn/fabric-dw:2026.9.0"
      ]
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "fabric-dw-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/sdebruyn/fabric-dw:2026.9.0"
      ]
    }
  }
}

Using several servers? Build one config file with the MCP config generator.

Configuration

  • FABRIC_AUTHAzure 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_READONLYSet to 1 to restrict execute_sql to SELECT/WITH statements and block all mutating tools.
  • FABRIC_MCP_ALLOW_DESTRUCTIVESet to 1 to enable permanently-destructive tools (delete_*, clear_table, restore_warehouse_in_place). Disabled by default.
  • FABRIC_MCP_WORKSPACESComma-separated workspace names or GUIDs the server may touch. Unset allows all workspaces.
  • FABRIC_MCP_ALLOW_REMOTESet to 1 to allow the HTTP transport to bind on a non-loopback address. Always front with an authenticating reverse proxy.
  • FABRIC_LOG_LEVELLog level for the MCP server (DEBUG, INFO, WARNING, ERROR, CRITICAL).

Pricing

Open source

Prices change. Check fdw.debruyn.dev before you buy.

fabric-dw FAQ

Is fabric-dw free?

Yes. fabric-dw is open source, so you can use and self-host it for free.

How do I add fabric-dw to Claude Code?

Run this command in your terminal: claude mcp add fabric-dw-mcp -- docker run -i --rm ghcr.io/sdebruyn/fabric-dw:2026.9.0

Where this comes from

  • Description: from the official MCP Registry entry.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers