Microsoft Fabric, verified
MCP server by Microsoft · Verified
Give AI agents Microsoft Fabric API specs, item schemas and best practices, plus OneLake file and Data Factory tools.
Install Microsoft Fabric
Runs on your machine. Your client starts it with this command:
Needs Node.js on your computer. The setup steps below show where the command goes in each client.
Share this server
Opens this page, with the install command and setup steps.
mcp.tc/i/microsoft-fabricAbout
Microsoft Fabric MCP Server packages Fabric's public OpenAPI specifications, item definition schemas (lakehouses, pipelines, semantic models, notebooks and others) and recommended patterns such as pagination and error handling into context for coding agents. It also includes OneLake data operations and Data Factory pipeline and Dataflow Gen2 tools.
It runs locally as a stdio server through npx (@microsoft/fabric-mcp), as a NuGet package (Microsoft.Fabric.Mcp), as a VS Code extension, or built from source with the .NET 10 SDK. The API and schema context works without connecting to a live Fabric environment. Node.js LTS is needed for the npx option.
What you can do
- Look up Fabric item types and their OpenAPI specifications
- Read JSON definition schemas for Fabric items
- Get best practices and examples for Fabric API usage
- Work with OneLake files, shortcuts, settings and data access roles
- Manage Data Factory pipelines and Dataflow Gen2
- Search the OneLake catalog
Tools
Local servers list their tools once they’re running, and this one doesn’t publish its list in advance. Your client shows them after you add it.
Example prompts
What Fabric item types are available?
Show the definition schema for a Fabric semantic model.
Search the OneLake catalog for items related to sales.
What are the best practices for paginating Fabric API results?
Set up
Every client starts Microsoft Fabric on your machine with the same command. Pick yours; the page remembers your choice.
Claude Code
- Run this in a terminal, in your project folder:
claude mcp add --transport stdio microsoft-fabric -- npx -y @microsoft/fabric-mcp@latest server start --mode all- Start Claude Code and type
/mcp. microsoft-fabric should show as connected.
Add --scope user to make it available in every project.
Claude Desktop
- Open Settings → Developer → Edit Config. It opens
claude_desktop_config.json. Add:
{
"mcpServers": {
"microsoft-fabric": {
"command": "npx",
"args": [
"-y",
"@microsoft/fabric-mcp@latest",
"server",
"start",
"--mode",
"all"
]
}
}
}- Save the file and restart Claude Desktop.
Needs Node.js on your computer. The file lives in ~/Library/Application Support/Claude/ on macOS and %APPDATA%\Claude\ on Windows.
Cursor
Add to Cursor (opens in a new tab)
Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):
{
"mcpServers": {
"microsoft-fabric": {
"command": "npx",
"args": [
"-y",
"@microsoft/fabric-mcp@latest",
"server",
"start",
"--mode",
"all"
]
}
}
}Needs Node.js on your computer.
VS Code
Install in VS Code (opens in a new tab)
Or from a terminal:
code --add-mcp '{"name":"microsoft-fabric","type":"stdio","command":"npx","args":["-y","@microsoft/fabric-mcp@latest","server","start","--mode","all"]}'Or commit it to the repo in .vscode/mcp.json:
{
"servers": {
"microsoft-fabric": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@microsoft/fabric-mcp@latest",
"server",
"start",
"--mode",
"all"
]
}
}
}Needs Node.js on your computer.
Devin Desktop
- Add it to
~/.config/devin/mcp_config.json(macOS and Linux) or%APPDATA%\devin\mcp_config.json(Windows):
{
"mcpServers": {
"microsoft-fabric": {
"command": "npx",
"args": [
"-y",
"@microsoft/fabric-mcp@latest",
"server",
"start",
"--mode",
"all"
]
}
}
}- Refresh the MCP server list in Cascade.
Devin Desktop is the new name for Windsurf.
Codex
codex mcp add microsoft-fabric -- npx -y @microsoft/fabric-mcp@latest server start --mode allOr edit ~/.codex/config.toml directly:
[mcp_servers.microsoft-fabric]
command = "npx"
args = ["-y", "@microsoft/fabric-mcp@latest", "server", "start", "--mode", "all"]Needs Node.js on your computer.
Gemini CLI
gemini mcp add microsoft-fabric npx -- -y @microsoft/fabric-mcp@latest server start --mode allThis adds it to the current project. Add -s user to use it everywhere.
Any client
Most clients that start local servers accept this shape:
{
"mcpServers": {
"microsoft-fabric": {
"command": "npx",
"args": [
"-y",
"@microsoft/fabric-mcp@latest",
"server",
"start",
"--mode",
"all"
]
}
}
}Zed puts servers under context_servers in its settings, with the same command, args and env fields.
Needs Node.js on your computer.
Embed
Show Microsoft Fabric in a README or on your site. Each embed links to this page, uses the server’s own install command, and sets no cookies. How embeds work
The card, the iframe and the JSON are in English. Add ?lang=it, fr, de or es to their address for another language.
README badge
[](https://mcp.tc/i/microsoft-fabric)<a href="https://mcp.tc/i/microsoft-fabric"><img src="https://mcp.tc/i/microsoft-fabric/badge.svg" alt="Microsoft Fabric on mcp.tc" height="20"></a>It follows the reader’s light or dark mode. Add ?theme=light or ?theme=dark to fix it, or ?style=compact to show the mark without the word.
Website card
<script src="https://mcp.tc/w/microsoft-fabric.js" async></script>The card appears where the tag is. Add data-theme="dark" or data-size="compact" to the tag to change it. The file holds everything it needs, so it makes no other requests and sets no cookies.
iframe
<iframe src="https://mcp.tc/embed/microsoft-fabric" title="Microsoft Fabric on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>Use it on pages that don’t allow scripts. Add ?theme=light or ?theme=dark to the address to fix the colors.
JSON
The listing as data for your own pages and tools: name, tagline, install command, tools and the “Add to” links. Any site can read it (CORS is open).
https://mcp.tc/i/microsoft-fabric.jsonAI prompt
Paste this into an AI coding assistant, such as Claude Code or Cursor, and it adds the Microsoft Fabric card to your site.
Add the mcp.tc card for Microsoft Fabric, an MCP server, to my website. It is one static script: no build step, no package to install, no cookies.
Put this tag where the card should appear. The card renders right before it:
```html
<script src="https://mcp.tc/w/microsoft-fabric.js" async></script>
```
To show the card somewhere else, put this placeholder there and load the same script once, for example before `</body>`. Keep the link inside: visitors without JavaScript see it.
```html
<div data-mcptc="microsoft-fabric"><a href="https://mcp.tc/i/microsoft-fabric">Microsoft Fabric on mcp.tc</a></div>
```
Options:
- `data-theme="light"` or `"dark"` on the tag or the placeholder fixes the colors. Without it, the card follows the visitor’s light or dark mode.
- `data-size="compact"` gives a smaller card without the tagline.
- The CSS variable `--mcptc-max-width` on the placeholder or a parent sets the width (default `520px`).
- `?lang=` on the script URL sets the card’s language: `en`, `it`, `fr`, `de` or `es`.
If the site has a Content Security Policy, allow `script-src https://mcp.tc` and `img-src data:` (the icon is inline).
For a README or other Markdown docs, use the badge instead:
```markdown
[](https://mcp.tc/i/microsoft-fabric)
```
Reference: https://mcp.tc/embedChange history
This server runs on your computer, so we follow its npm package: each new version shows up here, with edits by its owner.
-
New version 1.8.0 (was 1.7.0). Read from npm.
-
New version 1.7.0 (was 1.6.0). Read from npm.
-
New version 1.6.0 (was 1.5.0). Read from npm.
-
New version 1.5.0 (was 1.4.0). Read from npm.
-
Tracking started: version 1.4.0.
FAQ
Can I paste mcp.tc/i/microsoft-fabric into my MCP client?
No. Microsoft Fabric runs on your own computer, started by your client, so it has no web address to connect to. The quick link is the page to share; the install command is npx -y @microsoft/fabric-mcp@latest server start --mode all.
Does Microsoft Fabric need an API key?
No. It doesn’t declare any keys or environment variables. It runs with your user account’s permissions, so check what its tools can reach.
Is Microsoft Fabric a remote or a local server?
Local. Your client starts it as a process on your computer with npx -y @microsoft/fabric-mcp@latest server start --mode all, which needs Node.js.
What can Microsoft Fabric do?
You can look up Fabric item types and their OpenAPI specifications, read JSON definition schemas for Fabric items and get best practices and examples for Fabric API usage.
Which clients can use it?
Any client that starts local servers: Claude Code, Claude Desktop, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. claude.ai and ChatGPT only connect to remote servers.
Does mcp.tc track changes to Microsoft Fabric?
Partly. It runs on your computer, so we follow its npm package: its History tab shows each new version and edits by its owner. Follow the listing to get an email when it changes.
Who wrote this page?
mcp.tc’s robot read Microsoft Fabric’s public metadata (its package and repository pages), and an AI model drafted the text from it. A person reviews anything the checks can’t confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.
mcp.tc isn’t affiliated with Microsoft. This page was built from Microsoft Fabric’s public metadata, last checked on 3 Oct 2026, and an AI model wrote the description, so it can be wrong. Names and marks belong to their owners. Something off? Report this listing.