Prototype · Preview: every server in the official registry, synced every 30 minutes. Sign in with Google to write reviews.Prototype · updated every 30 min
PopNx MCPMCP servers for people who use AI · explained in plain words

fabric-dw

by sdebruynversion 2026.9.0i★ 10iRuns on your computerOfficial site ↗
Registry nameio.github.sdebruyn/fabric-dw-mcp

How to install

What it does

MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints

  • Connects Runs on your computer
  • Account or key Needs FABRIC_AUTH
  • Category Marketing & social media

Use together with

Skills that teach the AI this kind of work; they work alongside this one

scroll-world

A skill that turn any brand into a scrollable 3D world landing page

by oso95★ 11,0551 skills

Skill · How-to guide

social-auto-upload

自动化上传视频到社交媒体:抖音、小红书、视频号、tiktok、youtube、bilibili

by dreammis★ 16,657 (whole repo)4 skills

Skill · How-to guide

native-subtitle-quote-image

保留视频内嵌字幕,精确取帧并生成 3:4 社交长图的 Agent Skill

by chengyi-ai★ 2,8881 skills

Skill · How-to guide

Why it ranks here

Lists are ordered by a usage score (out of 100) built from these parts

Popularity12/80GitHub stars or weekly downloads: the larger counts 60, the smaller 20
Freshness12/12Full marks for a release or code change within 30 days
Still answering0/8The cloud endpoint answered at the last check
Usage score24/100

Quality: Passed 3/3 basic checks (shown, not used for ordering) · Momentum: No data yet (Used only on the Trending tab)

Install

Pick the AI app you use, then copy the settings.

Let your AI install it with one sentence

Please install fabric-dw. Follow https://mcp.popnx.com/i/sdebruyn-fabric-dw-mcp.md, show me the commands and wait for my OK before running them.

Paste it into an AI that can work on your computer (such as Claude Code or Cursor). It reads our steps, shows you the commands and waits for your OK. No key, no sign-up. · See the full text your AI reads

Passed 3/3 checks · Runs on your computer · ✓ Commands checked Nov 14, 2026

First: which AI do you use?

Pick your app and the steps appear below.

Works with Claude, with some setup first

You need a fabric-dw key (create it on the maker’s site) · Install Docker on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone

Let AI install it

Copy this message into a Claude chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server fabric-dw for Claude on this computer, in this order: 1) Check Docker with docker --version. If it is missing, tell me to install it from https://www.docker.com/products/docker-desktop/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "fabric-dw": { "command": "docker", "args": [ "run", "-i", "--rm", "-e", "FABRIC_AUTH", "ghcr.io/sdebruyn/fabric-dw:2026.9.0" ], "env": { "FABRIC_AUTH": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For FABRIC_AUTH, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the fabric-dw tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install Docker (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    docker --version
    • A version number such as Docker version … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: Install Docker Desktop: on Mac open Docker.dmg and drag the icon to Applications (pick Apple silicon or Intel to match your Mac) · on Windows double-click Docker Desktop Installer.exe · then open the Docker Desktop app and leave it running. No curl command needed

    Open the Docker download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: docker --version

    Install once; it works for everything that needs Docker

  2. Sign up and create a fabric-dw key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the fabric-dw site ↗

  3. Open the Claude desktop app’s settings file

    SettingsDeveloperEdit Config

  4. Paste these settings and save the file

    {
      "mcpServers": {
        "fabric-dw": {
          "command": "docker",
          "args": [
            "run",
            "-i",
            "--rm",
            "-e",
            "FABRIC_AUTH",
            "ghcr.io/sdebruyn/fabric-dw:2026.9.0"
          ],
          "env": {
            "FABRIC_AUTH": "your-value"
          }
        }
      }
    }

    Paste the key only into the app’s field, never into a chat or to anyone

  5. Quit Claude and open it again

  6. Try it

    Use fabric-dw and tell me what you can do for me, then show me one thing

    ✓ If Claude says it is using fabric-dw or shows a fabric-dw tool in the answer, you are connected

5 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • 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). · default INFO

Descriptions are as written by the maker.

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

ChatGPT cannot connect fabric-dw yet

fabric-dw runs on your computer, but ChatGPT can only connect servers that run on the web

What you can do instead

A · Use an app that can connect fabric-dw

  • You need a fabric-dw key (create it on the maker’s site) · Install Docker on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone
  • You need a fabric-dw key (create it on the maker’s site) · Install Docker on your computer first (one time)
  • You need a fabric-dw key (create it on the maker’s site) · Install Docker on your computer first (one time)
  • You need a fabric-dw key (create it on the maker’s site) · Install Docker on your computer first (one time)

B · Others in Marketing & social media that work with ChatGPT

Picked from the most used in the same category, only ones that connect by address with no key

Works with Claude Code, with some setup first

You need a fabric-dw key (create it on the maker’s site) · Install Docker on your computer first (one time)

Let AI install it

Copy this message into a Claude Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server fabric-dw for Claude Code on this computer, in this order: 1) Check Docker with docker --version. If it is missing, tell me to install it from https://www.docker.com/products/docker-desktop/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): claude mcp add --scope user fabric-dw --env FABRIC_AUTH=your-value -- docker run -i --rm -e FABRIC_AUTH ghcr.io/sdebruyn/fabric-dw:2026.9.0 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For FABRIC_AUTH, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the fabric-dw tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install Docker (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    docker --version
    • A version number such as Docker version … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: Install Docker Desktop: on Mac open Docker.dmg and drag the icon to Applications (pick Apple silicon or Intel to match your Mac) · on Windows double-click Docker Desktop Installer.exe · then open the Docker Desktop app and leave it running. No curl command needed

    Open the Docker download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: docker --version

    Install once; it works for everything that needs Docker

  2. Sign up and create a fabric-dw key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the fabric-dw site ↗

  3. Open Terminal

    Mac: press Command+Space and type Terminal · Windows: open PowerShell

  4. Paste this command and press Enter

    claude mcp add --scope user fabric-dw --env FABRIC_AUTH=your-value -- docker run -i --rm -e FABRIC_AUTH ghcr.io/sdebruyn/fabric-dw:2026.9.0

    Replace “your-value” with your key before pressing Enter

    Paste the key only into the app’s field, never into a chat or to anyone

  5. Type /mcp in Claude Code

    You should see fabric-dw listed as connected

  6. Try it

    Use fabric-dw and tell me what you can do for me, then show me one thing

    ✓ If Claude Code says it is using fabric-dw or shows a fabric-dw tool in the answer, you are connected

5 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • 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). · default INFO

Descriptions are as written by the maker.

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with Cursor, with some setup first

You need a fabric-dw key (create it on the maker’s site) · Install Docker on your computer first (one time)

Let AI install it

Copy this message into a Cursor chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server fabric-dw for Cursor on this computer, in this order: 1) Check Docker with docker --version. If it is missing, tell me to install it from https://www.docker.com/products/docker-desktop/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "fabric-dw": { "command": "docker", "args": [ "run", "-i", "--rm", "-e", "FABRIC_AUTH", "ghcr.io/sdebruyn/fabric-dw:2026.9.0" ], "env": { "FABRIC_AUTH": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For FABRIC_AUTH, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the fabric-dw tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install Docker (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    docker --version
    • A version number such as Docker version … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: Install Docker Desktop: on Mac open Docker.dmg and drag the icon to Applications (pick Apple silicon or Intel to match your Mac) · on Windows double-click Docker Desktop Installer.exe · then open the Docker Desktop app and leave it running. No curl command needed

    Open the Docker download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: docker --version

    Install once; it works for everything that needs Docker

  2. Sign up and create a fabric-dw key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the fabric-dw site ↗

  3. Click this button to open Cursor

    Open in Cursor

    Cursor asks you to confirm; click Install

  4. Fill in your key

    In the fabric-dw settings, FABRIC_AUTH is empty; add your key and save

    Paste the key only into the app’s field, never into a chat or to anyone

  5. Open the AI chat in Cursor in Agent mode

  6. Try it

    Use fabric-dw and tell me what you can do for me, then show me one thing

    ✓ If Cursor says it is using fabric-dw or shows a fabric-dw tool in the answer, you are connected

5 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • 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). · default INFO

Descriptions are as written by the maker.

Menu names checked against Cursor’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with VS Code, with some setup first

You need a fabric-dw key (create it on the maker’s site) · Install Docker on your computer first (one time)

Let AI install it

Copy this message into a VS Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server fabric-dw for VS Code on this computer, in this order: 1) Check Docker with docker --version. If it is missing, tell me to install it from https://www.docker.com/products/docker-desktop/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "servers": { "fabric-dw": { "type": "stdio", "command": "docker", "args": [ "run", "-i", "--rm", "-e", "FABRIC_AUTH", "ghcr.io/sdebruyn/fabric-dw:2026.9.0" ], "env": { "FABRIC_AUTH": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For FABRIC_AUTH, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the fabric-dw tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install Docker (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    docker --version
    • A version number such as Docker version … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: Install Docker Desktop: on Mac open Docker.dmg and drag the icon to Applications (pick Apple silicon or Intel to match your Mac) · on Windows double-click Docker Desktop Installer.exe · then open the Docker Desktop app and leave it running. No curl command needed

    Open the Docker download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: docker --version

    Install once; it works for everything that needs Docker

  2. Sign up and create a fabric-dw key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the fabric-dw site ↗

  3. Click this button to open VS Code

    Open in VS Code

    VS Code asks you to confirm; click Install

  4. Fill in your key

    In the fabric-dw settings, FABRIC_AUTH is empty; add your key and save

    Paste the key only into the app’s field, never into a chat or to anyone

  5. Open the AI chat in VS Code in Agent mode

  6. Try it

    Use fabric-dw and tell me what you can do for me, then show me one thing

    ✓ If VS Code says it is using fabric-dw or shows a fabric-dw tool in the answer, you are connected

5 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • 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). · default INFO

Descriptions are as written by the maker.

Menu names checked against VS Code’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Other apps that use MCP, such as Windsurf, Zed or Gemini CLI, each add servers differently. See how in the app list.

See every app that uses MCP →

JSON settings are under “For developers” below

Stuck? Ask people who use fabric-dw💬 Discussion →
For developers: Terminal commands and JSON settings

Installed on your computer

Claude Code

claude mcp add --scope user fabric-dw --env FABRIC_AUTH=your-value -- docker run -i --rm -e FABRIC_AUTH ghcr.io/sdebruyn/fabric-dw:2026.9.0

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "fabric-dw": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "FABRIC_AUTH",
        "ghcr.io/sdebruyn/fabric-dw:2026.9.0"
      ],
      "env": {
        "FABRIC_AUTH": "your-value"
      }
    }
  }
}

Cursor (~/.cursor/mcp.json)

{
  "mcpServers": {
    "fabric-dw": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "FABRIC_AUTH",
        "ghcr.io/sdebruyn/fabric-dw:2026.9.0"
      ],
      "env": {
        "FABRIC_AUTH": "your-value"
      }
    }
  }
}

VS Code (mcp.json)

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

Values you fill in

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

Descriptions are as written by the maker.

These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.

At a glance

Downloads per weeki
Not on npm/PyPI
Connection
Runs on your computer
Latest versioni
2026.9.0
Published to registryi
Sep 9, 2026
Code last changedi
Nov 16, 2026
Maker
sdebruyn
Packages
oci: ghcr.io/sdebruyn/fabric-dw:2026.9.0
Registry status
Active

Which apps can use it

Based on how this server connects and on each app’s own docs, checked Nov 10, 2026.

Run on your computer in

ClaudeGooseLM StudioMsty StudioCherry StudioCursorVS Code + GitHub CopilotVisual StudioWindsurf (Devin Desktop)ZedKiroClineContinueJetBrains AI AssistantClaude CodeCodex CLIGemini CLIOpenCodenodecodeWarpLibreChatRaycast

All apps, with pros and cons →

Related guides

What it can do

Runs on your computer; the tool list appears in your AI app after you install it.

Basic checksi

We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 19, 2026

  • ✓ Pass

    Maker matches the repo

    The registry name was verified with the GitHub account sdebruyn, which owns the repo

  • ✓ Pass

    Still maintained

    Code last changed 3 days ago

  • ✓ Pass

    Has a licence

    Uses MIT

  • – Not applicable

    Endpoint responds

    This one runs on your computer; there is no internet endpoint

  • – Not applicable

    Sign-in with OAuth

    Runs on your computer and uses local settings instead

  • … Not checked yet

    No hidden instructions in tool descriptions

    Runs on your computer; we can only read tool lists from internet endpoints

Published vulnerabilities (OSV.dev)

Not checked: only npm and PyPI packages with a version can be checked

What we check → · JSON

Makers: ask for a re-check or report wrong info
For makers: add a badge to your README

If you made this, paste this code into your README. The badge links back to this page.

[![Featured on PopNx MCP](https://mcp.popnx.com/badge/sdebruyn-fabric-dw-mcp.svg)](https://mcp.popnx.com/en/servers/sdebruyn-fabric-dw-mcp)

Discussion

Ask, share a tip or report that it does not work. Sorted by what people marked helpful.

No posts yet. Be the first to ask or share.

Posts here are written by users, not the PopNx team.

Sign in to post

User reviews

No reviews yet

Sign in to write a review

Compared with others in Marketing & social mediai

  • More stars than 96% of the other 4159 servers in this category
  • Published to the registry more recently than 26% of the other 4159 servers in this category
  • Basic checks equal to or better than 99% of the other 4159 servers in this category

Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.

Common questions

Is fabric-dw safe?

It passed 3 of 3 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.

What keys or codes does it need?

You need to fill in: FABRIC_AUTH

Does it run on my computer or in the cloud?

It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).

Is it still maintained?

The GitHub repo last changed 3 days ago, and the latest version (2026.9.0) reached the registry 2 months ago.

Which apps can use it?

Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Docker on your computer.

What can I use instead?

In the same category: Relaticle, ChatbotX, X (Twitter) MCP Server by Xquik, Betterlytics, BibiGPT YouTube Video Summarizer

Similar alternatives

Same category, other makers, commands already checked. Official ones first, then by stars.

Reading a card:↓ Downloads per weeki★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi

ChatbotX

Omnichannel customer messaging, CRM contacts, flows, sequences, broadcasts, and AI automation.

by ChatbotXIOGrowing★ 1.1K Stars for the whole repoUpdated 13 days ago

Runs in the cloud✓ service owner · chatbotx.io

Betterlytics

Query your Betterlytics web analytics from AI agents: traffic, funnels, journeys, errors, uptime.

by betterlyticsGrowing★ 196Updated 4 months ago

Runs in the cloud✓ service owner · betterlytics.io
Compared with similar ones
This one
fabric-dw
RelaticleChatbotXX (Twitter) MCP Server by XquikBetterlyticsBibiGPT YouTube Video Summarizer
Runs whereInstalls on your computerRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to install
Needs a keyYesNoNoNoYesNo
Add with + in ClaudeNoNoNoNoNoNo
Basic checks3/34/44/44/44/44/4
LicenseMITAGPL-3.0NOASSERTIONMITAGPL-3.0MIT
PriceNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registry

README from the maker

Open the README

Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.

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.

Full documentation: [fdw.debruyn.dev](https://fdw.debruyn.dev)

📣 Just announced! Read the story behind fabric-dw in the announcement blog post.

Description

fabric-dw provides two interfaces for managing Microsoft Fabric Data Warehouses and SQL Analytics Endpoints:

  • CLI: a command-line tool for common DW administration tasks.
  • MCP server: a Model Context Protocol server that exposes DW operations as tools for AI assistants.

Authentication is configured via the FABRIC_AUTH environment variable. The default (FABRIC_AUTH=default) uses azure-identity DefaultAzureCredential, which walks environment variables, Workload/Managed Identity, Azure CLI, Azure Developer CLI, Azure PowerShell, and interactive browser in order. Any of these will satisfy it. See the Authentication docs for the full chain, all supported sources, and debugging tips.

Installation

pip install fabric-dw

or run without installing:

uvx fabric-dw --help

or install persistently on PATH:

uv tool install fabric-dw

After installation, the fdw command is a short alias for fabric-dw; both invoke the same entry point. See the Install docs for MCP server setup, upgrading, and prerelease builds.

Quick Start

CLI

The workspace is a global root option -w / --workspace placed before the command group. Set a default once with fdw config set workspace and omit -w on every subsequent call. Workspace resolution order: (1) -w flag, (2) FABRIC_DW_DEFAULT_WORKSPACE env var, (3) configured default.

# Run without installing; install to get the fdw alias

uvx fabric-dw --help

Set a default workspace once; all subsequent commands pick it up

fdw config set workspace SalesWS

# -- Run and explain SQL --

Execute a query against a warehouse

fdw sql exec SalesWH -q "SELECT TOP 10 * FROM dbo.orders ORDER BY order_date DESC"

Capture an estimated execution plan as SVG -- no SSMS or Windows needed

fdw sql plan SalesWH -f query.sql --format svg -o plan.svg

-- Performance mission-control --

See what is running right now

fdw queries running SalesWH

Long-running queries from the past hour

fdw queries long-running SalesWH --ago 1h

Kill a runaway session by ID

fdw queries kill SalesWH 55

Most-repeated queries over the past 24 hours

fdw queries frequent SalesWH --ago 24h

-- Optimize --

Inspect a statistics histogram with inline terminal bar charts

fdw statistics show SalesWH dbo.orders st_order_date --histogram

Re-cluster a table on a new key (transactional CTAS-swap, auto-rollback on failure)

fdw tables cluster-by SalesWH dbo.orders --cluster-by customer_id

-- Time travel + export --

Browse the table as it looked 2 hours ago

fdw tables read SalesWH dbo.orders --ago 2h

Export a point-in-time snapshot to Parquet

fdw tables export SalesWH dbo.orders --output snapshot.parquet --ago 2h

-- Governance --

Grant SELECT on a specific table

fdw permissions sql grant SalesWH SELECT --to analyst@company.com --object dbo.orders

Deny access to sensitive columns (column-level security)

fdw permissions cls deny SalesWH SELECT --to contractor@company.com \ --object dbo.orders --columns salary,bonus

Create a row-level security policy (filter rows by SalesRep)

fdw permissions rls create SalesWH rls.SalesFilter \ --filter "rls.fn_sales_filter(SalesRep)" --on dbo.orders

-- Load + scaffold --

Load a local Parquet file and auto-create the table from its schema

fdw tables load SalesWH dbo.orders --file orders.parquet --create

Scaffold a full dbt-fabric project wired to the warehouse

fdw dbt init SalesWH ./my-dbt-project --project-name sales_dw --with-sources

MCP Server

Add to your MCP client configuration (e.g. Claude Desktop, VS Code):

{

"mcpServers": { "fabric-dw": { "command": "uvx", "args": ["--from", "fabric-dw", "fabric-dw-mcp"] } } }

The MCP server exposes all CLI operations as MCP tools (workspaces, warehouses, SQL endpoints, schemas, tables, views, queries, snapshots, restore points, audit, statistics, permissions, sql-pools). Bundled Claude Code agent skills (query-optimizer, warehouse-performance, dbt-setup) are included for deeper AI-assisted analysis. Set FABRIC_AUTH in the environment if you need a non-default auth mode.

Both the skills and the MCP server install in one command via the fabric-dw plugin marketplace, for Claude Code and GitHub Copilot CLI alike: /plugin marketplace add sdebruyn/fabric-dw-mcp-cli then /plugin install fabric-dw@fabric-dw. See the Agent Skills docs for details.

Run in Docker

The Docker image's default ENTRYPOINT is the MCP server (fabric-dw-mcp). Use it as-is with your MCP client, or override the entrypoint to run the CLI instead.

docker pull ghcr.io/sdebruyn/fabric-dw:latest

Run the MCP server (default entrypoint, connect via stdio from your MCP client):

docker run --rm -i \ -e AZURE_CLIENT_ID=… \ -e AZURE_TENANT_ID=… \ -e AZURE_CLIENT_SECRET=… \ -e FABRIC_AUTH=sp \ ghcr.io/sdebruyn/fabric-dw

Run the CLI instead (override the entrypoint):

docker run --rm \ --entrypoint fabric-dw \ -e AZURE_CLIENT_ID=… \ -e AZURE_TENANT_ID=… \ -e AZURE_CLIENT_SECRET=… \ -e FABRIC_AUTH=sp \ ghcr.io/sdebruyn/fabric-dw --help

Dev images (built from every main merge): ghcr.io/sdebruyn/fabric-dw:main or : .dev .

Package page: ghcr.io/sdebruyn/fabric-dw

Security environment variables
VariableDefaultDescription
FABRIC_MCP_READONLYunsetSet to 1 to restrict execute_sql to SELECT/WITH and block all mutating tools.
FABRIC_MCP_ALLOW_DESTRUCTIVEunsetSet to 1 to enable permanently-destructive tools (delete_*, clear_table, restore_warehouse_in_place). Disabled by default.
FABRIC_MCP_WORKSPACESunsetComma-separated workspace names or GUIDs the server may touch. Unset = all workspaces allowed.
FABRIC_MCP_ALLOW_REMOTEunsetSet to 1 to allow the HTTP transport (--transport http) to bind on a non-loopback address. A warning is logged; ensure an authenticating reverse proxy with TLS fronts the endpoint, and pass --allowed-host so Host validation stays on. See Hosting the MCP server.
HTTP transport

The MCP server can be started in HTTP mode for remote clients:

fabric-dw-mcp --transport http [--host 127.0.0.1] [--port 8000]

It binds to loopback by default, where Host and Origin validation is handled for you. Binding anywhere else requires FABRIC_MCP_ALLOW_REMOTE=1 and --allowed-host, and the endpoint has no built-in authentication or TLS, so always front it with an authenticating reverse proxy. See Hosting the MCP server for that setup.

Develop in a container

Open the repo in GitHub Codespaces or VS Code's Remote-Containers extension. The devcontainer pre-installs Python 3.14, uv, Azure CLI, and the GitHub CLI.

Contributing

See CONTRIBUTING.md for dev setup, branch flow, and how to run tests locally.

📖 Docs: fdw.debruyn.dev (or run uv run --only-group docs zensical serve locally).

Security

Please report vulnerabilities privately. See SECURITY.md.

Code of Conduct

This project follows the Contributor Covenant 2.1.

License

MIT. Copyright (c) 2026 Sam Debruyn