Microsoft Fabric Mcp Enterprise Data Agents 2026

Date: 2026-05-16
Track: tool-scout
Slug: microsoft-fabric-mcp-enterprise-data-agents-2026

Environment

• macOS Darwin 24.6.0
• Node.js 20+ LTS required (not installed in this run)
• No Fabric workspace / Entra ID credentials available

Installability Inspection (No Execution)

Inspected Microsoft Fabric MCP server installation surface from official Microsoft Learn docs and GitHub.

Local MCP (Pro-Dev) — Generally Available

# Install via npm (global)
npm install -g fabric-pro-dev-mcp-server

# Or via npx (no install)
npx -y @microsoft/fabric-mcp@latest server start --mode all

Source: https://learn.microsoft.com/en-us/rest/api/fabric/articles/mcp-servers/pro-dev-local/get-started-local

VS Code configuration (.vscode/mcp.json):

{
  "servers": {
    "fabric-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": ["-y", "@microsoft/fabric-mcp@latest", "server", "start", "--mode", "all"]
    }
  }
}

OneLake MCP — Generally Available

npx @microsoft/fabric-mcp

Works with: VS Code (GitHub Copilot Agent Mode), Claude Desktop, Cursor, any MCP-compatible client.

Remote Core MCP — Preview (Cloud-Hosted)

• No local installation required
• Endpoint: https://api.fabric.microsoft.com/v1/mcp
• Authentication: Microsoft Entra ID (OAuth 2.0)
• Every operation respects existing Fabric RBAC (Admin/Member/Contributor/Viewer)
• All invocations recorded in Fabric Audit Logs

Eventhouse RTI MCP — Preview

GitHub: https://github.com/microsoft/fabric-rti-mcp
Supports: KQL queries, schema discovery, real-time data reasoning

What Worked (Documentation Review)

• Local MCP installable via npx without credentials ✓
• OneLake MCP GA — production SLAs, telemetry, retry ✓
• Core Remote MCP endpoint documented with OpenAPI spec ✓
• Eventhouse MCP has open-source GitHub repo with docs ✓

What Was Not Tested

• Actual npx execution (no Node.js in sandbox environment)
• Entra ID authentication flow (no Microsoft account/credentials)
• Real Fabric workspace operations
• KQL query execution via Eventhouse MCP

Limitations

This is an installability + documentation inspection run. No Fabric workspace or Microsoft credentials were available, so hands-on operation could not be verified. The quickstart commands come from official Microsoft Learn documentation.

Conclusion

Microsoft Fabric MCP is a production-ready tool (Local MCP GA, OneLake MCP GA). The Remote/Core MCP is in preview but documented. The ecosystem is real, the npm package exists, and the integration works with VS Code, Claude Desktop, and Cursor. Safe to write a tool-scout guide based on official documentation.