# Microsoft Fabric MCP Server

A Microsoft MCP server that hands your agent tools for Microsoft Fabric. Useful when your data and reports live in Fabric.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed, Gemini CLI · ★ 3799
- Author: microsoft
- License: MIT · policy=link-only · description only; the file stays with the author
- Source: https://github.com/microsoft/mcp/tree/HEAD/servers/fabric.mcp.server
- Updated: 2026-10-23
- HTML: https://affpapa.org/en/nevibecode/mcp/microsoft-fabric-mcp-server

## What it does

The server runs locally through `npx` and the `@microsoft/fabric-mcp` package. Your agent gets a set of tools for reaching Microsoft Fabric: queries, data access, service documentation. Everything speaks the standard MCP protocol, so the same server plugs into different clients.

Setup is one terminal command. In Claude that is `claude mcp add microsoft-fabric -- npx -y @microsoft/fabric-mcp`. Cursor and GitHub Copilot take a config entry that starts the same command as a stdio process. Claude and Gemini CLI have their own add syntax.

You need access to Microsoft Fabric — without it the tools do nothing. The package is pulled from npm on every launch, so make sure `npx` is on your PATH and the registry is reachable. MIT licensed, source in `microsoft/mcp`.

## Requirements
- Needs: Node.js (commands run via npx)

## Install

### Claude Code (native platform)

**Platform CLI**
```bash
claude mcp add microsoft-fabric -- npx -y @microsoft/fabric-mcp
```

### Codex

**Platform CLI**
```bash
codex mcp add fabric.mcp.server -- npx -y @microsoft/fabric-mcp
```

### Cursor

**Config file**
File `.cursor/mcp.json`:
```json
{
    "mcpServers": {
        "fabric.mcp.server": {
            "command": "npx",
            "args": [
                "-y",
                "@microsoft/fabric-mcp"
            ]
        }
    }
}
```

### GitHub Copilot

**Config file**
File `.vscode/mcp.json`:
```json
{
    "servers": {
        "fabric.mcp.server": {
            "type": "stdio",
            "command": "npx",
            "args": [
                "-y",
                "@microsoft/fabric-mcp"
            ]
        }
    }
}
```

### Gemini CLI

**Platform CLI**
```bash
gemini mcp add fabric.mcp.server npx -y @microsoft/fabric-mcp
```

## When to use it
- query Microsoft Fabric data without leaving the agent
- check a table schema against the Fabric docs
- pull a report together without opening a browser
- see which Fabric tools the agent can call
- wire one server into several IDEs

## Example prompts
- list the tables in my Microsoft Fabric workspace
- which Fabric tools are available over MCP
- run a query against Fabric and show the first rows

## Similar
- [fabric-lakehouse](https://affpapa.org/en/nevibecode/skills/fabric-lakehouse.md) — skill · 8800 installs
- [microsoft-foundry](https://affpapa.org/en/nevibecode/plugins/microsoft-foundry.md) — plugin · ★ 2056
- [microsoft-events](https://affpapa.org/en/nevibecode/plugins/microsoft-events.md) — plugin · ★ 292
- [Microsoft Learn MCP](https://affpapa.org/en/nevibecode/mcp/microsoft-learn-mcp.md) — MCP server · ★ 1953
- [microsoft-teams](https://affpapa.org/en/nevibecode/rules/microsoft-teams.md) — rule · ★ 3579
- [ads-microsoft](https://affpapa.org/en/nevibecode/skills/ads-microsoft.md) — skill · 3800 installs

From the same set: [microsoft/mcp](https://affpapa.org/en/nevibecode/by/microsoft/mcp.md) — 2 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md