Microsoft · Official

Microsoft Fabric (local) MCP server

Local server with offline Fabric API docs and best practices, OneLake file and table tools, and Fabric item creation.

Verified publisher namespaceLocalDatabases
Registry name
com.microsoft/microsoft-fabric
Latest version
1.4.0 · updated 2026-08-27
Links
Vendor docsSource

Install

Commands are generated from the registry record. Remote servers usually ask you to sign in with OAuth on first use.

Step-by-step guides
Add to CursorAdd to VS CodeAdd to KiroAdd to LM StudioAdd to GooseBundle with other servers

Claude Code

claude mcp add microsoft-fabric -- npx -y @microsoft/fabric-mcp server start

Codex

# ~/.codex/config.toml
[mcp_servers.microsoft_fabric]
command = "npx"
args = ["-y", "@microsoft/fabric-mcp", "server", "start"]

Gemini CLI

gemini mcp add microsoft-fabric npx -y @microsoft/fabric-mcp server start

Cursor

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

VS Code (GitHub Copilot)

code --add-mcp '{"name":"microsoft-fabric","command":"npx","args":["-y","@microsoft/fabric-mcp","server","start"]}'
Step-by-step for Claude CodeStep-by-step for CodexStep-by-step for Gemini CLIStep-by-step for CursorStep-by-step for VS Code (GitHub Copilot)

What the Microsoft Fabric (local) MCP server can do

From Microsoft's own MCP documentation.

Authentication

Docs tools need no sign-in. Live OneLake and Fabric tools use your Azure CLI login (az login) or a service principal with a certificate or client secret set through AZURE_TENANT_ID, AZURE_CLIENT_ID and AZURE_CLIENT_CERTIFICATE_PATH or AZURE_CLIENT_SECRET.

Options

  • Install through the Fabric MCP Server VS Code extension (recommended), npx @microsoft/fabric-mcp, or a .NET source build.
  • API documentation and best practices tools work offline.
  • Microsoft also runs separate remote Fabric servers (Core, Data Warehouse, Eventhouse and more). This entry is the local one.

Tools (21 documented tools)

docs_workloadsdocs_workload-api-specdocs_platform-api-specdocs_item-definitionsdocs_best-practicesdocs_api-examplesonelake_list_workspacesonelake_list_itemsonelake_list_items_dfsonelake_list_filesonelake_download_fileonelake_upload_fileonelake_delete_fileonelake_create_directoryonelake_delete_directoryonelake_get_table_configonelake_list_table_namespacesonelake_get_table_namespaceonelake_list_tablesonelake_get_tablecore_create-item

Good to know

  • The OneLake tools include upload, delete and create directory, so they can change data. Check which identity and workspace are in use first.
  • Service principal support depends on the API and item type, and Fabric REST calls need the service principal tenant setting.
  • Local means the server runs on your machine. It does not mean the client or model processes data locally.
  • Tool names can change between releases.
Microsoft MCP docs

Packages

  • nuget Microsoft.Fabric.Mcp
  • npm @microsoft/fabric-mcp

More databases

AirtableAlgoliaClickHouseGoogle Cloud FirestoreGoogle MapsMapbox

Get the weekly agent stack update

New official MCP servers, spec changes and harness releases, checked against the source. One email a week, no fluff.

Work at Microsoft?

Feature Microsoft Fabric (local) at the top of the databases category and the MCP directory from $49/month.

Feature this server

Add an install badge to the Microsoft Fabric (local) README

Free. One link that installs the server in Cursor, VS Code, Kiro, LM Studio or Goose with one click, and gives Claude Code, Codex, Gemini CLI and 10 more agents their exact config.

Install in any agent (Markdown)

[![Install with AgentAtlas](https://img.shields.io/badge/install-15_agents-111111)](https://agentatlas.dev/tools/setup-kit?servers=microsoft-fabric)

Listed on AgentAtlas (Markdown)

[![Listed on AgentAtlas](https://img.shields.io/badge/listed_on-AgentAtlas-111111)](https://agentatlas.dev/mcp/microsoft-fabric)

Reviewed Oct 20, 2026. Official means published under Microsoft's namespace in the MCP registry. It is not a security audit.