# Microsoft Fabric MCP

> Microsoft's MCP server for Fabric: API specs and best practices for writing Fabric code, plus tools for workspaces, OneLake and pipelines.

The Microsoft Fabric MCP Server gives your agent what it needs to write production-ready code for Microsoft Fabric, plus signed-in tools for working with your Fabric resources.

What you can do with it
- Look up the OpenAPI specs and JSON item definitions for Fabric item types, such as Lakehouses, pipelines, semantic models and notebooks
- Get Fabric's best practices for pagination, throttling, retries, authentication and long-running operations, with example payloads
- Search the OneLake catalog and list your workspaces, items and capacities
- Browse, upload and download OneLake files, and read table definitions
- Create workspaces and items, and manage OneLake shortcuts and data access roles
- Manage Data Factory pipelines and Dataflow Gen2, and run M queries

How it connects
It runs on your machine with npx @microsoft/fabric-mcp@latest server start (it needs Node.js 22 or later), and also comes as a .NET tool, a Docker image and a VS Code extension. Its documentation tools read specifications bundled with the server and don't connect to Fabric; its operational tools call Fabric's APIs as the identity you configure.

Good to know
Some tools can delete files, items and whole workspaces, so connect it with an identity that has only the access you want to give it.

- Type: Plugin
- Made by: Microsoft
- Category: Data & analytics
- Formats: Local MCP
- Version: 1.4.0
- Website: https://github.com/microsoft/mcp/tree/main/servers/Fabric.Mcp.Server
- Source: https://github.com/microsoft/mcp/tree/HEAD/servers/Fabric.Mcp.Server
- Page: https://pluginboard.ai/plugins/microsoft-fabric-mcp

## Works with

- Claude
- GitHub Copilot
- Cursor
- Claude Code
- Codex
- Antigravity
- Gemini CLI
- OpenClaw
- OpenCode
- Hermes Agent

## Install

### Claude

Add to claude_desktop_config.json:

```json
{
  "mcpServers": {
    "microsoft-fabric-mcp": {
      "command": "dnx",
      "args": [
        "Microsoft.Fabric.Mcp@1.4.0",
        "--yes",
        "server",
        "start"
      ]
    }
  }
}
```

### GitHub Copilot

Add to VS Code: vscode:mcp/install?%7B%22name%22%3A%22microsoft-fabric-mcp%22%2C%22command%22%3A%22dnx%22%2C%22args%22%3A%5B%22Microsoft.Fabric.Mcp%401.4.0%22%2C%22--yes%22%2C%22server%22%2C%22start%22%5D%7D

Run in your terminal:

```shell
code --add-mcp '{"name":"microsoft-fabric-mcp","command":"dnx","args":["Microsoft.Fabric.Mcp@1.4.0","--yes","server","start"]}'
```

Copilot CLI:

```shell
copilot mcp add microsoft-fabric-mcp -- dnx Microsoft.Fabric.Mcp@1.4.0 --yes server start
```

### Cursor

Add to Cursor: cursor://anysphere.cursor-deeplink/mcp/install?name=microsoft-fabric-mcp&config=eyJjb21tYW5kIjoiZG54IiwiYXJncyI6WyJNaWNyb3NvZnQuRmFicmljLk1jcEAxLjQuMCIsIi0teWVzIiwic2VydmVyIiwic3RhcnQiXX0%3D

Add to .cursor/mcp.json:

```json
{
  "mcpServers": {
    "microsoft-fabric-mcp": {
      "command": "dnx",
      "args": [
        "Microsoft.Fabric.Mcp@1.4.0",
        "--yes",
        "server",
        "start"
      ]
    }
  }
}
```

### Claude Code

Run in your terminal:

```shell
claude mcp add microsoft-fabric-mcp -- dnx Microsoft.Fabric.Mcp@1.4.0 --yes server start
```

### Codex

Run in your terminal:

```shell
codex mcp add microsoft-fabric-mcp -- dnx Microsoft.Fabric.Mcp@1.4.0 --yes server start
```

### Antigravity

Add to ~/.gemini/config/mcp_config.json:

```json
{
  "mcpServers": {
    "microsoft-fabric-mcp": {
      "command": "dnx",
      "args": [
        "Microsoft.Fabric.Mcp@1.4.0",
        "--yes",
        "server",
        "start"
      ]
    }
  }
}
```

### Gemini CLI

Run in your terminal:

```shell
gemini mcp add microsoft-fabric-mcp dnx Microsoft.Fabric.Mcp@1.4.0 --yes server start
```

### OpenClaw

In a terminal: Run openclaw mcp add microsoft-fabric-mcp --command dnx, with --arg before each argument (Microsoft.Fabric.Mcp@1.4.0 --yes server start) and --env NAME=value for each variable it needs.

### OpenCode

Run in your terminal:

```shell
opencode mcp add microsoft-fabric-mcp -- dnx Microsoft.Fabric.Mcp@1.4.0 --yes server start
```

### Hermes Agent

Add to ~/.hermes/config.yaml:

```json
{
  "mcp_servers": {
    "microsoft-fabric-mcp": {
      "command": "dnx",
      "args": [
        "Microsoft.Fabric.Mcp@1.4.0",
        "--yes",
        "server",
        "start"
      ]
    }
  }
}
```

---
From Pluginboard (https://pluginboard.ai).