Microsoft Fabric MCP Server

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

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

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

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

Config formats checked against the official docs on Oct 7, 2026: modelcontextprotocol.io (opens in a new tab), code.claude.com (opens in a new tab), cursor.com (opens in a new tab), code.visualstudio.com (opens in a new tab).

• 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_assign-workspace-to-capacity

  Submits one request to assign an existing workspace to a capacity.

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. Documentation tools use bundled specifications without connecting to live Fabric environments; operational tools call Fabric APIs using the configured identity.