Fabric Analytics MCP Server

MCP server for Microsoft Fabric Analytics with Synapse-to-Fabric migration - enables LLMs to access, analyze, and migrate workloads to Microsoft

Local serverstdioPython

What is the Fabric Analytics MCP MCP server?

MCP server for Microsoft Fabric Analytics with Synapse-to-Fabric migration - enables LLMs to access, analyze, and migrate workloads to Microsoft Fabric. That is what the fabric analytics mcp mcp server brings to an AI assistant: the same capability, reachable through the Model Context Protocol rather than a separate app or dashboard.

The short version

A comprehensive Model Context Protocol (MCP) server that provides analytics capabilities and tools for interacting with Microsoft Fabric data platform. This server enables AI assistants like Claude to seamlessly access, analyze, and monitor Microsoft Fabric resources through standardized MCP protocols, bringing the power of Microsoft Fabric directly to your AI conversations.

The tools it exposes

The server publishes 4 tools. What each one is for:

  • fabric_list_synapse_workspaces — List all Synapse workspaces in your Azure subscription
  • fabric_discover_synapse_workspace — Inventory notebooks, pipelines, linked services, and Spark jobs from Synapse
  • fabric_transform_notebooks — Transform Synapse notebooks to Fabric format (mssparkutils → notebookutils)
  • fabric_migrate_synapse_to_fabric — Complete end-to-end migration with discovery, transformation, and provisioning

What it needs from you

Configuration is passed through the environment: FABRIC_AUTH_METHOD, FABRIC_TOKEN, FABRIC_WORKSPACE_ID, ENABLE_HEALTH_SERVER, ACR_NAME, FABRIC_CLIENT_ID, FABRIC_CLIENT_SECRET, FABRIC_TENANT_ID. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.

Getting it running

Setup follows the usual MCP pattern — install or clone the server, register it in your client's configuration file, restart the client.

How it compares

Among the payments and commerce options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. Fabric Analytics MCP's toolset — fabric_list_synapse_workspaces, fabric_discover_synapse_workspace, fabric_transform_notebooks and 1 more — is a fair guide to whether it matches your workflow. It is maintained by santhoshravindran7; worth a glance at recent repository activity before you build anything load-bearing on it.

This entry was verified against Fabric Analytics MCP's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.

Things to watch

  • It runs with your machine's permissions. That is convenient and also the reason to think about what you point it at before you approve a tool call.
  • Missing credentials fail quietly in some clients — if no tools show up, check the environment block first.
  • Keep per-call confirmation enabled while you learn its behaviour; it is the cheapest safeguard you have.

Available tools

ToolWhat it does
fabric_list_synapse_workspacesList all Synapse workspaces in your Azure subscription
fabric_discover_synapse_workspaceInventory notebooks, pipelines, linked services, and Spark jobs from Synapse
fabric_transform_notebooksTransform Synapse notebooks to Fabric format (mssparkutils → notebookutils)
fabric_migrate_synapse_to_fabricComplete end-to-end migration with discovery, transformation, and provisioning

Configuration

VariableDescriptionRequired
FABRIC_AUTH_METHODConfiguration value read at startup.Optional
FABRIC_TOKENCredential the server authenticates with.Yes
FABRIC_WORKSPACE_IDConfiguration value read at startup.Optional
ENABLE_HEALTH_SERVERConfiguration value read at startup.Optional
ACR_NAMEConfiguration value read at startup.Optional
FABRIC_CLIENT_IDConfiguration value read at startup.Optional
FABRIC_CLIENT_SECRETCredential the server authenticates with.Yes
FABRIC_TENANT_IDConfiguration value read at startup.Optional

Example prompts to try

  • Use Fabric Analytics MCP to fabric list synapse workspaces.
  • Use Fabric Analytics MCP to fabric discover synapse workspace.
  • Use Fabric Analytics MCP to fabric transform notebooks.

Frequently asked questions

It connects Fabric Analytics MCP to MCP-compatible AI assistants such as Claude and Cursor, exposing 4 tools (fabric_list_synapse_workspaces, fabric_discover_synapse_workspace, fabric_transform_notebooks, and more) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Fabric Analytics MCP directly.