# Microsoft Fabric MCP Server (MCP server)

> Microsoft Fabric MCP Server is an MCP server that provides AI agents with comprehensive access to Microsoft Fabric's public APIs, item definitions, and best practices. The Fabric MCP Server packages complete OpenAPI specifications into a single context layer for AI-assisted… It has 3,738 GitHub stars, is released under the MIT license and runs locally with npx -y @microsoft/fabric-mcp.

A local-first Model Context Protocol (MCP) server that provides AI agents with comprehensive access to Microsoft Fabric's public APIs, item definitions, and best practices. The Fabric MCP Server packages complete OpenAPI specifications into a single context layer for AI-assisted development—without connecting to live Fabric environments.

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/microsoft/mcp |
| GitHub stars | 3,738 |
| License | MIT |
| Language | C# |
| Transport | stdio |
| Packages | nuget: Microsoft.Fabric.Mcp; npm: @microsoft/fabric-mcp |
| Remote URL | none |
| Needs API key | no |
| Official | yes |
| Works with | Claude Desktop, Claude Code, Cursor, VS Code |
| Category | Other |
| Latest release | Template.Mcp.Server-0.0.12-alpha.6918199 (Oct 5, 2026) |
| Last commit | Oct 6, 2026 |
| MCP registry name | com.microsoft/microsoft-fabric |

## Install

### Claude Desktop (claude_desktop_config.json)

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

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

### Claude Code

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

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

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

Project file; use ~/.cursor/mcp.json to enable it in every project.

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

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

Config formats checked against the official docs on 2026-10-07.

## Tools

- `docs_list-item-types`: Lists the Fabric item types that have public API specifications available, plus the non-item API areas (platform,…
- `docs_item-api-spec`: Retrieves the complete OpenAPI specification for a specific Fabric item type.
- `docs_platform-api-spec`: Retrieves the OpenAPI specification for core Fabric platform APIs.
- `docs_item-definitions`: Retrieves the JSON schema definition for a Fabric item type.
- `docs_best-practices`: Retrieves best practice documentation and guidance for a specific topic.
- `docs_api-examples`: Retrieves example API request/response files for a specific item type.
- `onelake_list-workspaces`: Lists available Microsoft Fabric workspaces.
- `onelake_list-items`: Lists workspace items with high-level metadata.
- `onelake_list-items-dfs`: Lists Fabric items via the DFS endpoint.
- `onelake_list-files`: Lists files using the hierarchical file-list endpoint.
- `onelake_download-file`: Downloads a OneLake file.
- `onelake_upload-file`: Uploads a file to OneLake storage.
- `onelake_delete-file`: Deletes a file from OneLake storage.
- `onelake_create-directory`: Creates a directory via the DFS endpoint.
- `onelake_delete-directory`: Deletes a directory (optionally recursive).
- `onelake_get-table-config`: Retrieves table API configuration for a workspace item.
- `onelake_list-table-namespaces`: Lists table namespaces (schemas) exposed through the table API.
- `onelake_get-table-namespace`: Retrieves metadata for a specific namespace.
- `onelake_list-tables`: Lists tables published within a namespace.
- `onelake_get-table`: Retrieves the definition for a specific table.
- `onelake_list-data-access-roles`: Lists all data access roles defined on a single item.
- `onelake_get-data-access-role`: Gets the full definition of a single data access role (members, permissions, decision rules).
- `onelake_create-or-update-data-access-role`: Upserts a single data access role on a single item.
- `onelake_delete-data-access-role`: Deletes a single data access role from an item.
- `onelake_list-shortcuts`: Lists shortcuts defined within an item. Hides DW-managed shortcuts by default (--include-managed to show).
- `onelake_get-shortcut`: Gets the properties of a single shortcut.
- `onelake_create-shortcut-onelake`: Creates a shortcut pointing to another OneLake location.
- `onelake_create-shortcut-adls-gen2`: Creates a shortcut pointing to Azure Data Lake Storage Gen2.
- `onelake_create-shortcut-amazon-s3`: Creates a shortcut pointing to Amazon S3.
- `onelake_create-shortcut-azure-blob`: Creates a shortcut pointing to Azure Blob Storage.
- `onelake_create-shortcut-gcs`: Creates a shortcut pointing to Google Cloud Storage.
- `onelake_create-shortcut-s3-compatible`: Creates a shortcut pointing to S3-compatible storage.
- `onelake_create-shortcut-dataverse`: Creates a shortcut pointing to a Dataverse environment.
- `onelake_create-shortcut-onedrive-sharepoint`: Creates a shortcut pointing to OneDrive/SharePoint Online.
- `onelake_delete-shortcut`: Deletes a single shortcut from an item (preserves destination data).
- `onelake_reset-shortcut-cache`: Drops cached shortcut reads, forcing re-resolution from destination.
- `onelake_get-settings`: Gets OneLake settings for a workspace (diagnostics + immutability policy).
- `onelake_modify-diagnostics`: Modifies diagnostic logging configuration (status, destination lakehouse) at workspace scope.
- `onelake_modify-immutability-policy`: Modifies the workspace-level OneLake immutability policy (scope, retention days).
- `core_search-catalog`: Searches the OneLake catalog for items across workspaces by name, description, or workspace name.

## Similar MCP servers

- [Reactive Resume](https://appsgit.com/mcp-servers/reactive-resume): A one-of-a-kind resume builder that keeps your privacy in mind. (43,921 stars, MIT)
- [N8n MCP](https://appsgit.com/mcp-servers/n8n-mcp): A MCP for Claude Desktop / Claude Code / Windsurf / Cursor to build n8n workflows for you. (23,047 stars, MIT)
- [XHS Downloader](https://appsgit.com/mcp-servers/xhs-downloader): 小红书（XiaoHongShu、RedNote）链接提取/作品采集工具. (12,922 stars, GPL-3.0)
- [MCP Use](https://appsgit.com/mcp-servers/mcp-use): The fullstack MCP framework to develop MCP Apps for ChatGPT / Claude & MCP Servers for AI Agents. (10,726 stars, MIT)
- [Ha MCP](https://appsgit.com/mcp-servers/ha-mcp): Comprehensive Model Context Protocol server for managing Home Assistant through AI assistants. (4,964 stars, MIT)
- [MCP Server Chart](https://appsgit.com/mcp-servers/mcp-server-chart): A Model Context Protocol server for generating charts using AntV. (4,391 stars, MIT, needs API key)

---

Canonical page: https://appsgit.com/mcp-servers/microsoft-fabric-mcp-server
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.