Microsoft Fabric
MCP server wrapping around the Fabric Rest API
What is Microsoft Fabric?
Microsoft Fabric is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to mcp server wrapping around the fabric rest api
MCP server wrapping around the Fabric Rest API
This server falls under the Analytics category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- MCP server wrapping around the Fabric Rest API
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx microsoft-fabric-mcpConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Microsoft Fabric
Microsoft Fabric MCP Server wraps the Microsoft Fabric REST API and exposes 25 tools across workspace management, data schema inspection, job monitoring, operational intelligence, and environment configuration — all accessible through natural language in your AI assistant. It uses Azure CLI's DefaultAzureCredential for authentication, so no separate OAuth setup is needed if you are already logged in with az login. Data engineers and analysts working in Microsoft Fabric use it to query lakehouses, monitor pipeline jobs, inspect table schemas, and manage workspaces without switching between the Fabric portal and their editor.
Prerequisites
- UV package manager installed (pip install uv or from astral.sh/uv)
- Azure CLI installed and authenticated via az login
- An active Microsoft Fabric workspace with appropriate permissions
- An MCP-compatible client such as Claude Desktop, Cursor, or Claude Code
Install the UV package manager
The server is distributed via PyPI and runs with uvx, which requires the UV package manager. Install it using the official installer or via pip.
# macOS/Linux
curl -LsSf https://astral.sh/uv/install.sh | sh
# Windows (PowerShell)
powershell -c "irm https://astral.sh/uv/install.ps1 | iex"
# Or via pip
pip install uvAuthenticate with Azure CLI
Log in to Azure using the CLI. The server uses DefaultAzureCredential, which automatically picks up your az login session — no additional token configuration is needed.
az login
# Verify your active subscription
az account showAdd the server to your MCP client configuration
Add the microsoft-fabric-mcp entry to your MCP client config file. UVX will automatically download and run the package without a separate install step.
{
"mcpServers": {
"mcp_fabric": {
"command": "uvx",
"args": ["microsoft-fabric-mcp"]
}
}
}Restart your MCP client
Restart Claude Desktop or your MCP client after saving the config. The server will download the package on first run. Verify it appears as Connected in Settings → Developer → MCP Servers.
Test with a workspace query
Confirm the server works by asking Claude to list your Fabric workspaces. If authentication is working, it will return your available workspaces.
Microsoft Fabric Examples
Client configuration
Claude Desktop or Cursor configuration for the Microsoft Fabric MCP Server using uvx. Azure CLI authentication must be active before launching the client.
{
"mcpServers": {
"mcp_fabric": {
"command": "uvx",
"args": ["microsoft-fabric-mcp"]
}
}
}Prompts to try
Sample prompts that use the server's 25 tools for workspace management, data inspection, and job monitoring in Microsoft Fabric.
- "Show me all lakehouses in the DWH-PROD workspace"
- "List the tables available in the Bronze lakehouse and show me the schema for the sales table"
- "What notebook jobs ran in the last 24 hours and which ones failed?"
- "Create a notebook that reads from the sales table in Bronze and upserts the results into the Silver lakehouse"
- "Show me the data lineage for the Gold layer in my analytics workspace"Troubleshooting Microsoft Fabric
Authentication errors or 401 Unauthorized responses
Run az login and then az account show to confirm you are logged in and the correct subscription is active. The server uses DefaultAzureCredential which reads your az login session. If you have multiple Azure accounts, run az account set --subscription <id> to select the right one.
Workspace or item names not resolving correctly
The server caches name-to-ID resolutions. After renaming workspaces or items in the Fabric portal, call the clear_name_resolution_cache tool to force fresh lookups. For resource list changes (new lakehouses, etc.), call clear_fabric_data_cache.
uvx command not found after installation
After installing UV, you may need to restart your terminal or add the UV binary directory to your PATH. On macOS/Linux, run source ~/.bashrc or source ~/.zshrc. Verify the installation with which uvx or uv --version.
Frequently Asked Questions about Microsoft Fabric
What is Microsoft Fabric?
Microsoft Fabric is a Model Context Protocol (MCP) server that mcp server wrapping around the fabric rest api It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Microsoft Fabric?
Follow the installation instructions on the Microsoft Fabric GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Microsoft Fabric?
Microsoft Fabric works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Microsoft Fabric free to use?
Yes, Microsoft Fabric is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
Microsoft Fabric Alternatives — Similar Analytics Servers
Looking for alternatives to Microsoft Fabric? Here are other popular analytics servers you can use with Claude, Cursor, and VS Code.
OpenMetadata
★ 14.0kOpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
Superset
★ 10.9kAn MCP server that provides AI assistants with full access to Apache Superset instances, enabling interaction with dashboards, charts, datasets, databases, and SQL execution capabilities.
Horizon
★ 4.4k📡 Your own AI-powered news radar. Generates daily briefings in English & Chinese. | 用 AI 构建你专属的新闻雷达
MCP Server Chart
★ 4.1kEnables generation of 25+ types of charts and data visualizations using AntV, including bar charts, line charts, maps, mind maps, and specialized diagrams like fishbone and sankey charts. Supports both statistical charts and geographic visualizations
Muapi CLI
★ 997Official CLI for muapi.ai — generate images, videos & audio from the terminal. MCP server, 14 AI models, npm + pip installable.
Weather MCP Server
★ 907Weather Data Fetcher MCP server built with Node.js, MCP SDK, and Zod. Provides weather details like temperature and forecast for cities such as Noida and Delhi via a registered tool. Simplifies API integration, enabling structured responses for clien
Browse More Analytics MCP Servers
Explore all analytics servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Microsoft Fabric in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Microsoft Fabric?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.