Data and BI - official Microsoft server
Microsoft Fabric MCP server
Microsoft's local MCP server that gives agents Fabric API specifications, item definition schemas and best practices, plus authenticated tools for OneLake files and tables, workspaces and Data Factory pipelines. It runs locally from @microsoft/fabric-mcp (npm); the notes below cover how it authenticates.
Last verified 12 tools2 sources
Install
Generic
{
"mcpServers": {
"fabric-mcp-server": {
"command": "npx",
"args": [
"-y",
"@microsoft/fabric-mcp@latest",
"server",
"start",
"--mode",
"all"
]
}
}
}Tools
docs_list-item-types- Lists the Fabric item types that have public API specifications available.
docs_item-api-spec- Retrieves the complete OpenAPI specification for a specific Fabric item type.
docs_platform-api-spec- Retrieves the OpenAPI specification for core Fabric platform APIs.
docs_item-definitions- Retrieves the JSON schema definition for a Fabric item type.
docs_best-practices- Retrieves best practice documentation and guidance for a specific topic.
onelake_list-workspaces- Lists available Microsoft Fabric workspaces.
onelake_list-items- Lists workspace items with high-level metadata.
onelake_list-files- Lists files using the hierarchical file-list endpoint.
onelake_download-file- Downloads a OneLake file.
onelake_upload-file- Uploads a file to OneLake storage.
onelake_list-tables- Lists tables published within a namespace.
onelake_get-table- Retrieves the definition for a specific table.
As documented on October 17, 2026. A running server reports its current list through tools/list.
Notes and caveats
- Labelled Public Preview in Microsoft's MCP catalog.
- Requires Node.js 22+ for the npm route; NuGet .NET tool and Docker also documented.
- Toolsets: core, docs, onelake, datafactory.
More MCP servers for data and BI
- MicrosoftStatus: Preview
Azure DevOps MCP server
Microsoft MCP server that gives agents access to Azure DevOps projects, work items, repos, pipelines, test plans and wikis, available as a hosted remote server or a local stdio server.
Transport: Streamable HTTP, stdioAuth: OAuth - MicrosoftStatus: GA
Azure MCP server
Microsoft's local MCP server that exposes tools across many Azure services (Foundry, App Service, Storage, Cosmos DB, Monitor, Azure CLI and more) to agents, authenticating with Entra ID.
Transport: stdio, Streamable HTTPAuth: Other - MicrosoftStatus: Preview
Azure Resource Manager MCP server
Microsoft-hosted remote MCP server that lets agents query Azure resources with Resource Graph, run and preview ARM template deployments, create or update resources, inspect resource schemas, and query costs and prices.
Transport: Streamable HTTPAuth: OAuth - MicrosoftStatus: Preview
Foundry MCP server
Microsoft-hosted remote MCP server that gives agents read and write tool access to Microsoft Foundry services such as model catalog details, knowledge and evaluation, authenticated with Entra ID.
Transport: Streamable HTTPAuth: OAuth - Microsoft
Microsoft Learn MCP server
Free Microsoft-hosted remote MCP server that gives agents semantic lookup and page retrieval over official Microsoft documentation and code samples, with no API key.
Transport: Streamable HTTPAuth: No auth - MicrosoftStatus: Preview
Microsoft MCP server for Enterprise
Microsoft-hosted remote MCP server that translates natural-language requests into read-only Microsoft Graph calls over Microsoft Entra identity and directory data.
Transport: Streamable HTTPAuth: OAuth
Related reading
- Microsoft's Work IQ APIs Hit GA: What Agent Builders Actually Get on June 16Microsoft Work IQ APIs give agents pre-assembled, permission-trimmed Microsoft 365 context. What the domains, protocols and pricing mean for developers.
- Microsoft Agent Framework in October 2026: What Changed Since 1.0Microsoft Agent Framework is at Python 1.22 and .NET 1.25: Harness agents, functional workflows, channels, and why AutoGen users should migrate now.
- Microsoft's CLI Coding Agent Study: Adoption Is a Workflow ProblemMicrosoft's study of Claude Code and GitHub Copilot CLI found about 24% more merged PRs among adopters. The bigger lesson is rollout design, not magic.
- Document-Borne AI Worms Self-Propagate Through Copilot for Word: What HN ThinksCopilot for Word AI worm: hidden prompts in a Word document hijack Copilot, alter financial data and self-propagate across documents. What HN thinks.
- Nvidia, Microsoft, Meta, and 30+ Companies Warn Against Overregulating Open-Weight AI ModelsAn open letter from Nvidia, Microsoft, Meta, OpenAI and 30+ signers defends open-weight AI models. What it argues, who stayed out, and how HN reacted.
- Resource2Skill Turns Tutorials Into Agent SkillsResource2Skill, a Microsoft paper, turns tutorials, repos, articles, and reference artifacts into executable agent skills with provenance. What to copy from it.
FAQ
What does the Microsoft Fabric MCP server do?
Microsoft's local MCP server that gives agents Fabric API specifications, item definition schemas and best practices, plus authenticated tools for OneLake files and tables, workspaces and Data Factory pipelines. The vendor documents 12 tools, including docs_list-item-types, docs_item-api-spec, docs_platform-api-spec and docs_item-definitions.
How do I add the Microsoft Fabric MCP server to an MCP client?
Microsoft documents a Generic config; copy it from the Generic section of this page.
Does the Microsoft Fabric MCP server need authentication?
It uses a scheme other than OAuth or an API key, such as the session of the app or instance it runs in; the notes on this page describe it. Transport: stdio. Status: Preview, last checked October 17, 2026.
Sources
Last verified against 2 Microsoft pages, then re-checked independently.
- raw.githubusercontent.comhttps://raw.githubusercontent.com/microsoft/mcp/main/servers/Fabric.Mcp.Server/README.md
- raw.githubusercontent.comhttps://raw.githubusercontent.com/microsoft/mcp/main/README.md
Newsletter
New MCP servers, the week they ship
One email per week. New official MCP servers, the coding tools that support them and how developers wire them up.