Fabric-Analytics-MCP

Overview

Fabric-Analytics-MCP is a comprehensive Model Context Protocol server that provides tools for interacting with Microsoft Fabric data platform. It enables AI assistants like Claude to seamlessly access, analyze, and monitor Microsoft Fabric resources through standardized MCP protocols. The server supports complete workspace management, CRUD operations for Fabric items, advanced notebook management, Livy API integration, and comprehensive Spark monitoring capabilities.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• fabric_list_workspaces

  List all accessible workspaces with detailed metadata

  Try:List all workspaces in my tenantTry:Show me all my Fabric workspaces
• fabric_create_workspace

  Create new workspaces with custom configuration

  Try:Create a new workspace called 'Analytics-Q1-2025'Try:Set up a workspace for our project
• fabric_list_capacities

  List all available Fabric capacities

  Try:Show me all available capacitiesTry:List all Fabric capacities I can use
• fabric_assign_workspace_to_capacity

  Attach workspaces to dedicated capacity

  Try:Assign workspace 1234abcd to capacity f9998888Try:Move workspace to premium capacity
• fabric_list_synapse_workspaces

  List all Synapse workspaces in your Azure subscription

  Try:List my Synapse workspacesTry:Show all Azure Synapse workspaces
• fabric_discover_synapse_workspace

  Inventory notebooks, pipelines, linked services from Synapse

  Try:Discover assets in my Synapse workspaceTry:Show me what's in analytics-synapse workspace
• fabric_transform_notebooks

  Transform Synapse notebooks to Fabric format

  Try:Transform my Synapse notebook to FabricTry:Convert mssparkutils to notebookutils
• fabric_migrate_synapse_to_fabric

  Complete end-to-end migration from Synapse to Fabric

  Try:Migrate all notebooks from Synapse to FabricTry:Complete migration of analytics-synapse workspace
• fabric_list_workspace_environments

  List all environments in a workspace

  Try:Show me environments in Analytics workspaceTry:List all development environments
• fabric_get_workspace_role_assignments

  View workspace permissions and role assignments

  Try:Show me who has access to the Analytics workspaceTry:List workspace permissions
• fabric_add_workspace_role_assignment

  Grant workspace access to users or groups

  Try:Add john.doe as Admin to Analytics workspaceTry:Give read access to the team group
• fabric_get_workspace_git_status

  Check Git integration status of a workspace

  Try:Check Git status of Analytics workspaceTry:Is the workspace connected to GitHub?

Comparable tools

Installation

npm install -g mcp-for-microsoft-fabric-analytics

{
  "mcpServers": {
    "fabric-analytics": {
      "command": "node",
      "args": ["path/to/index.js"],
      "cwd": "path/to/project",
      "env": {
        "FABRIC_AUTH_METHOD": "bearer_token",
        "FABRIC_TOKEN": "your_bearer_token_here",
        "FABRIC_WORKSPACE_ID": "your_workspace_id",
        "ENABLE_HEALTH_SERVER": "false"
      }
    }
  }
}

FAQ

How do I authenticate with Microsoft Fabric?

The server supports multiple authentication methods: Bearer token, Service Principal, Device Code, Interactive, and Azure CLI. For quick setup, use Azure CLI authentication with 'az login' for zero-config setup.

Can I migrate from Azure Synapse Analytics to Microsoft Fabric using this MCP server?

Yes, the server includes 4 specialized migration tools that automate the migration of Spark notebooks and pipelines from Azure Synapse to Microsoft Fabric, with code transformation, asset discovery, and end-to-end automation capabilities.

Compare Fabric-Analytics-MCP with