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
NPM
npx -y microsoft-fabricManual Installation
npx -y microsoft-fabricConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Microsoft Fabric
The Microsoft Fabric MCP Server wraps the Microsoft Fabric REST API and exposes 25 MCP tools for querying workspaces, listing items and tables, reading schemas, managing OneLake shortcuts, monitoring job instances, and analyzing data lineage — all through natural language. It uses Azure CLI's DefaultAzureCredential for authentication, so no separate API keys are needed beyond an active Azure login. Data engineers and analysts use it to explore Fabric lakehouses, generate schema-aware code, and monitor pipelines without leaving their AI assistant.
Prerequisites
- Python 3.10+ and the uv package manager (https://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 or Claude Code
Install Azure CLI and authenticate
The server uses DefaultAzureCredential, which relies on an active Azure CLI session. Install the CLI for your platform and log in. If you have multiple subscriptions, set the correct one.
# macOS
brew install azure-cli
# Windows
winget install -e --id Microsoft.AzureCLI
# Authenticate
az login
az account show
# Optional: select a specific subscription
az account set --subscription "Your-Subscription-Name-or-ID"Install the server with uvx
The recommended installation uses uvx to run the published package directly. Alternatively, clone the repository and install in editable mode for development.
# Run directly (no install needed)
uvx microsoft-fabric-mcp
# Or clone and install locally
git clone https://github.com/Augustab/microsoft_fabric_mcp
cd microsoft_fabric_mcp
uv pip install -e .Add the server to your MCP client configuration
Open your claude_desktop_config.json and add the Fabric entry. The uvx method is recommended for simplicity; use the local path method if you cloned the repository.
{
"mcpServers": {
"mcp_fabric": {
"command": "uvx",
"args": ["microsoft-fabric-mcp"]
}
}
}Restart your MCP client
Fully restart Claude Desktop. On startup the server will use your existing Azure CLI credentials — no additional authentication prompts should appear. Confirm by asking Claude to list your Fabric workspaces.
Explore workspaces and lakehouses
Ask Claude to list workspaces, inspect item schemas, or retrieve table schemas from a specific lakehouse. The server maps these to the appropriate Fabric REST API calls automatically.
Microsoft Fabric Examples
Client configuration
claude_desktop_config.json entry using uvx to run microsoft-fabric-mcp. Azure CLI credentials are picked up automatically from the environment.
{
"mcpServers": {
"mcp_fabric": {
"command": "uvx",
"args": ["microsoft-fabric-mcp"]
}
}
}Prompts to try
Natural language prompts that exercise the workspace, schema, job monitoring, and lineage tools.
- "Show me all workspaces in my Fabric tenant"
- "List all lakehouses in the DWH-PROD workspace"
- "Get the schema for the sales_transactions table in the Silver lakehouse"
- "Check the status of the latest job instances in the ETL workspace"
- "Show the data lineage for the Gold lakehouse"
- "Write Python code to read from the Bronze lakehouse and upsert into Silver, using the actual table schemas"Troubleshooting Microsoft Fabric
Authentication errors when the server starts
Run `az login` and `az account show` in a terminal to confirm you have an active session. If you have multiple subscriptions, run `az account set --subscription <name-or-id>` to select the correct one before restarting your MCP client.
uvx command not found
Install uv via `curl -LsSf https://astral.sh/uv/install.sh | sh` on macOS/Linux or `powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"` on Windows. Restart your shell after installation.
Tools list Fabric items from the wrong subscription
Use `az account list` to see all subscriptions and `az account set --subscription <id>` to switch. The server reads DefaultAzureCredential which picks up the currently active subscription from the CLI session.
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?
Install via npm with the command: npx -y microsoft-fabric. Then add the server configuration to your AI client's JSON config file (e.g., claude_desktop_config.json or .cursor/mcp.json).
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.