# Microsoft Fabric MCP server

> Gives AI agents Fabric API specs and item definitions, and runs authenticated operations like OneLake data access, jobs, and Data Factory pipelines.

- Repository: https://github.com/microsoft/mcp
- Page: https://hostedmcp.org/servers/microsoft/microsoft-fabric
- Official: yes
- Transport: stdio
- Stars: 3855
- License: MIT
- Latest version: 1.4.0

## Install

### Claude Code

```sh
claude mcp add microsoft-fabric -- npx -y @microsoft/fabric-mcp
```

### Cursor (`~/.cursor/mcp.json`)

```json
{
  "mcpServers": {
    "microsoft-fabric": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/fabric-mcp"
      ]
    }
  }
}
```

### VS Code (`.vscode/mcp.json`)

```json
{
  "servers": {
    "microsoft-fabric": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/fabric-mcp"
      ]
    }
  }
}
```

### VS Code CLI

```sh
code --add-mcp '{"name":"microsoft-fabric","type":"stdio","command":"npx","args":["-y","@microsoft/fabric-mcp"]}'
```

### Claude Desktop (`claude_desktop_config.json`)

```json
{
  "mcpServers": {
    "microsoft-fabric": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/fabric-mcp"
      ]
    }
  }
}
```

### Codex

```sh
codex mcp add microsoft-fabric -- npx -y @microsoft/fabric-mcp
```

### Codex config.toml (`~/.codex/config.toml`)

```toml
[mcp_servers.microsoft-fabric]
command = "npx"
args = ["-y", "@microsoft/fabric-mcp"]
```

### Gemini CLI

```sh
gemini mcp add -s user microsoft-fabric npx -- -y @microsoft/fabric-mcp
```

### Gemini settings.json (`~/.gemini/settings.json`)

```json
{
  "mcpServers": {
    "microsoft-fabric": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/fabric-mcp"
      ]
    }
  }
}
```

## Environment variables

| Name | Required | Secret | Description |
|---|---|---|---|
| `AZURE_CLIENT_ID` | no | no |  |
| `AZURE_CLIENT_SECRET` | no | no |  |
| `AZURE_TENANT_ID` | no | no |  |
| `AZURE_TOKEN_CREDENTIALS` | no | no |  |

## FAQ

### What can the Microsoft Fabric MCP server do?

It provides AI agents with Fabric public APIs, item definitions, and best practices, plus authenticated tools for working with Fabric resources such as OneLake and Data Factory.

### Do documentation tools need a live Fabric environment?

No. Documentation tools read bundled specifications locally, while operational tools call Fabric APIs using the configured identity.

### How do I install the Fabric MCP server with npm?

Run it with npx using the @microsoft/fabric-mcp package, requiring Node.js LTS 22.0.0 or later.

### Can it update workspace metadata?

Yes, you can rename a known workspace or update or clear its description without changing other properties.