Microsoft Fabric MCP Server — Claude Code MCP server
A Microsoft MCP server that hands your agent tools for Microsoft Fabric. Useful when your data and reports live in Fabric.
claude mcp add microsoft-fabric -- npx -y @microsoft/fabric-mcpWhat Microsoft Fabric MCP Server does
The server runs locally through npx and the @microsoft/fabric-mcp package. Your agent gets a set of tools for reaching Microsoft Fabric: queries, data access, service documentation. Everything speaks the standard MCP protocol, so the same server plugs into different clients.
Setup is one terminal command. In Claude that is claude mcp add microsoft-fabric -- npx -y @microsoft/fabric-mcp. Cursor and GitHub Copilot take a config entry that starts the same command as a stdio process. Claude and Gemini CLI have their own add syntax.
You need access to Microsoft Fabric — without it the tools do nothing. The package is pulled from npm on every launch, so make sure npx is on your PATH and the registry is reachable. MIT licensed, source in microsoft/mcp.
What it helps with
- query Microsoft Fabric data without leaving the agent
- check a table schema against the Fabric docs
- pull a report together without opening a browser
- see which Fabric tools the agent can call
- wire one server into several IDEs
Example prompts for the agent
- list the tables in my Microsoft Fabric workspace
- which Fabric tools are available over MCP
- run a query against Fabric and show the first rows
How to install Microsoft Fabric MCP Server
Platform CLI
claude mcp add microsoft-fabric -- npx -y @microsoft/fabric-mcpPlatform CLI
codex mcp add fabric.mcp.server -- npx -y @microsoft/fabric-mcpConfig file
{
"mcpServers": {
"fabric.mcp.server": {
"command": "npx",
"args": [
"-y",
"@microsoft/fabric-mcp"
]
}
}
}Config file
{
"servers": {
"fabric.mcp.server": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@microsoft/fabric-mcp"
]
}
}
}Platform CLI
gemini mcp add fabric.mcp.server npx -y @microsoft/fabric-mcpStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about Microsoft Fabric MCP Server
How do I install Microsoft Fabric MCP Server in Claude?
Run claude mcp add microsoft-fabric -- npx -y @microsoft/fabric-mcp. The server starts locally through npx.
What does Microsoft Fabric MCP Server do?
It gives your agent MCP tools for Microsoft Fabric: data queries and access to service capabilities.
What do I need for it to work?
Access to Microsoft Fabric and npx on your PATH — the @microsoft/fabric-mcp package is fetched from npm at launch.
