Fabric Dw MCP Server

Python CLI and MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints: administer, query, optimize, and secure them from your terminal or your AI agent.

People who need database tools inside Claude, Cursor, VS Code, or another MCP client. The project is written in Python.

VERIFIED ACTIVE

LAST COMMIT 2026-08-24 · ★ 9 · #119 OF 151 MAINTAINED DATABASE · VERIFIED 2026-08-25

MIT · Python servers · how we verify → /methodology

01 · Install Fabric Dw

before you install - you'll need

Set AZURE_CLIENT_ID, AZURE_TENANT_ID, AZURE_CLIENT_SECRET before connecting. FABRIC_AUTH is optional or environment-specific per the README.

Docker

docker run -i --rm ghcr.io/sdebruyn/fabric-dw:2026.7.3

Claude Desktop - add to config

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

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as container (OCI image) - can be sandboxed away from your filesystem

license MIT - declared in the repository

registry namespace io.github.sdebruyn is GitHub-verified and matches the repo owner

03 · What Fabric Dw can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

Latest releases

v2026.7.3 · 2026-07-19

Highlights · Live query watch mode · The queries running, queries locks, and queries connections commands now accept a --watch SECONDS flag that refreshes the terminal output in a loop. No more re-running the same…

v2026.7.2 · 2026-07-17

Highlights · Inspect who holds the lock · New queries locks command and list_locks MCP tool to see which sessions hold locks and who is waiting on whom. The output joins sys.dm_tran_locks with sys.dm_exec_requests and…

v2026.7.1 · 2026-07-13

Highlights · Smarter MCP agents out of the box · The MCP server now ships server instructions that every connected client receives automatically. AI agents are steered toward the 118 dedicated tools (across 20 domains)…

04 · Who maintains Fabric Dw

fabric-dw is maintained by sdebruyn. It's the only MCP server we track from this author; the repo dates to Jun 2026.

05 · Facts

repository: github.com/sdebruyn/fabric-dw-mcp-cli
website: https://fdw.debruyn.dev/
category: database - ranked #119 of 151 actively-maintained database servers as of 2026-08-25.
release cadence: 5 releases in the last 90 days (latest 2026-07-19)
registry: io.github.sdebruyn/fabric-dw-mcp (active, first published 2026-07-03 · 4 versions)
packages: oci:ghcr.io/sdebruyn/fabric-dw:2026.7.3

06 · Fabric Dw FAQ

What is Fabric Dw?

Python CLI and MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints: administer, query, optimize, and secure them from your terminal or your AI agent.

Is Fabric Dw still maintained?

Yes - as of 2026-08-25, its last commit was 2026-08-24 and it shipped 5 releases in the last 90 days. We re-verify nightly.

How do I install Fabric Dw?

Run `docker run -i --rm ghcr.io/sdebruyn/fabric-dw:2026.7.3`. The README documents 4 environment variables (AZURE_CLIENT_ID, AZURE_TENANT_ID, AZURE_CLIENT_SECRET…) to set first. Set AZURE_CLIENT_ID, AZURE_TENANT_ID, AZURE_CLIENT_SECRET before connecting. FABRIC_AUTH is optional or environment-specific per the README. You can also paste the ready-made client config above.

07 · Alternatives to Fabric Dw

Alternatives to Fabric Dw

Maintained database servers if Fabric Dw isn't the fit.

Pairs well with

Servers that cover what Fabric Dw doesn't - only shown when the pairing reason fits the companion.

More database MCP servers · CIPP MCP · KnowBe4 MCP · SentinelOne MCP · Sherweb MCP · Syncro MCP

More Python MCP servers · Sports Betting MCP · Glovebox MCP · Periscope MCP · Selvage · Sdcgovernance · see all