Microsoft Fabric Analytics

Microsoft Fabric Analytics is an MCP server that provides tools for interacting with the Microsoft Fabric data platform directly through AI assistants. It connects supported clients to Fabric workspaces, capacity resources, Spark engines, and automated migration services. Data engineers, analytics engineers, and cloud architects use this server to automate administrative operations, monitor Spark applications, and execute analytics workflows through natural language prompts. The server enables full lifecycle management across Fabric workspaces, including creating workspaces, assigning them to premium capacities, managing user access roles, and configuring Git integration for version control. Beyond resource management, the server provides tools for notebook execution via the Livy API, lakehouse maintenance, data pipeline orchestration, and real-time monitoring across Spark sessions. It also features dedicated tools to discover and migrate legacy workloads from Azure Synapse Analytics to Microsoft Fabric, rewriting notebook utility calls and updating storage paths to OneLake automatically. By bridging the Model Context Protocol with Microsoft Fabric APIs and Azure authentication, the server streamlines day-to-day data engineering and operational tasks across enterprise cloud environments.

Category: Cloud & Infrastructure

Tags: analytics, data engineering, data-warehouse, microsoft fabric

Visit Microsoft Fabric Analytics

How to install and configure Microsoft Fabric Analytics

1. Ensure your system has Node.js 18+ or Python 3.8+ installed, depending on whether you choose the fabric-analytics-mcp package or mcp-for-microsoft-fabric-analytics. 2. Authenticate to your Azure account using the Azure CLI by running az login to allow the server to access your Microsoft Fabric tenant. 3. Review the complete setup, environment variable configuration, and MCP client registration options in the Fabric-Analytics-MCP repository. 4. Configure your MCP client, such as Claude Desktop or GitHub Copilot, by adding the Microsoft Fabric Analytics server definition according to the instructions in the project documentation. 5. Launch your MCP client and test connectivity by listing available workspaces or capacities.

What you can do with Microsoft Fabric Analytics

• Provision and configure new Microsoft Fabric workspaces, assigning them to specific capacity instances and configuring role assignments for organizational team members. - Execute and monitor Apache Spark notebooks and batch applications in real time through Livy API integration within Microsoft Fabric workspaces. - Migrate legacy Azure Synapse Analytics assets to Microsoft Fabric by automatically discovering workspaces and transforming notebook code to target OneLake. - Connect Fabric workspaces to remote Git repositories to inspect version control status and synchronize deployment changes alongside active data pipelines. - Query workspace status, environments, and data pipelines to troubleshoot failing Spark sessions or review capacity allocations across tenant environments.

Key facts

• https://github.com/santhoshravindran7/Fabric-Analytics-MCP
• Cloud & Infrastructure, Data & Analytics
• analytics, data engineering, data-warehouse, microsoft fabric

Part of MCP Servers

What is Microsoft Fabric Analytics?

Microsoft Fabric Analytics is an MCP server designed to connect AI assistants to Microsoft Fabric. It provides over fifty tools for managing workspaces, provisioning capacity, running Spark notebooks via Livy, orchestrating data pipelines, and monitoring resource health directly through natural language queries in compatible AI clients.

Which MCP clients work with Microsoft Fabric Analytics?

The server functions with any client that implements the standard Model Context Protocol. Documented environments include Claude Desktop and GitHub Copilot, as well as development tools like Cursor that support registering external MCP server executables and communicating over standard input and output channels.

How does Microsoft Fabric Analytics authenticate with Azure?

The server supports multiple enterprise authentication methods to connect to Azure and Fabric. Supported approaches include using an active Azure CLI session via az login, bearer tokens, service principals, interactive browser sign-in, and device code authentication, providing flexible options for both local development and automated deployment pipelines.

Can Microsoft Fabric Analytics migrate Azure Synapse workloads?

Yes, the server includes specialized migration tools that inventory Azure Synapse Analytics workspaces, notebooks, and pipelines. It can automatically transform Synapse-specific syntax, such as mssparkutils calls, to Fabric notebookutils equivalents, rewrite storage paths to OneLake, and provide dry-run reports before provisioning assets.

Is Microsoft Fabric Analytics open source?

Yes, Microsoft Fabric Analytics is distributed as open-source software licensed under the MIT License. The code and public issue tracker are accessible on GitHub at https://github.com/santhoshravindran7/Fabric-Analytics-MCP, where developers can review changes, submit pull requests, and report issues.