---
title: "Microsoft Fabric Real-Time Intelligence MCP Server: review, setup & limitations · Undominated.ai"
canonical: https://undominated.ai/mcp-servers/microsoft-fabric-rti/
description: "Runs KQL queries and management commands against Fabric Eventhouse and Azure Data Explorer, and manages Fabric Eventstreams, Activator triggers and Maps, with Azure Identity credentials."
---

# Microsoft Fabric Real-Time Intelligence MCP Server: review, setup & limitations · Undominated.ai

> Runs KQL queries and management commands against Fabric Eventhouse and Azure Data Explorer, and manages Fabric Eventstreams, Activator triggers and Maps, with Azure Identity credentials.

[← Explore all mcp servers](/mcp-servers/)

ANALYTICS DATABASES / Microsoft

# Microsoft Fabric Real-Time Intelligence MCP Server

Runs KQL queries and management commands against Fabric Eventhouse and Azure Data Explorer, and manages Fabric Eventstreams, Activator triggers and Maps, with Azure Identity credentials.

 [See setup guidance ↓](#setup)[Original source ↗](https://github.com/microsoft/fabric-rti-mcp)

SOURCE REVIEW

 Reviewed 2026-10-13
 Evidence 3 linked sources
 Publisher Microsoft
 Licence [MIT ↗](https://github.com/microsoft/fabric-rti-mcp/blob/3c765f92ca5067be8ad70a4b5c5daf8f20f236d9/LICENSE)
 Revision 3c765f92ca50
 [Read what was—and wasn’t—checked ↓](#review)

“This server enables AI agents to interact with Fabric RTI services by providing tools through the MCP interface, allowing for seamless data querying, analysis, and streaming capabilities.”

 [Microsoft · upstream description ↗](https://github.com/microsoft/fabric-rti-mcp/blob/3c765f92ca5067be8ad70a4b5c5daf8f20f236d9/README.md) Our analysis follows below.

01 / THE REASONING

## Why this made the selection.

 - Published in Microsoft's own repository; the README at this commit lists the Eventhouse, Eventstreams, Activator and Map tools by name and documents FABRIC_RTI_ALLOWED_TOOLS to expose only chosen services or tools.
- The README states the server is not intended as a production HTTP endpoint and that HTTP mode screens bearer-token shape without cryptographic Entra JWT validation, so its trust boundary is written down.

### A good fit for

 - Querying Eventhouse or Azure Data Explorer in natural language and inspecting schemas from VS Code or GitHub Copilot CLI
- Setting up Activator triggers that send email or Teams notifications when a KQL-monitored condition occurs

### Weigh up before choosing

 - kusto_command runs management commands including .create, .alter and .drop, and Eventstream and Map tools create, update and delete items; the README leaves safeguards to the user's Fabric RBAC roles.
- KUSTO_ALLOW_UNKNOWN_SERVICES defaults to true, so the server connects to clusters outside KUSTO_KNOWN_SERVICES unless it is set to false. The README marks the project Public Preview.
- The README says the software may send usage data to Microsoft. Nothing was installed or run.

02 / THE REVIEW RECORD

## What we actually inspected.

Source review has boundaries. A clear record is more useful than a “safe” badge.

### Material inspected

 - README.md at 3c765f92ca5067be8ad70a4b5c5daf8f20f236d9
- LICENSE and pyproject.toml at the same commit

### Our findings

 - In stdio mode the README says authentication uses DefaultAzureCredential: environment variables, Visual Studio, Azure CLI, Azure PowerShell, Azure Developer CLI, then an interactive browser login.
- HTTP mode (FABRIC_RTI_TRANSPORT=http) defaults to 127.0.0.1:3000 at /mcp; FABRIC_RTI_HTTP_DEBUG_MODE allows local process credentials and permissive CORS.
- pyproject.toml names microsoft-fabric-rti-mcp, Python >=3.10, license MIT, with the microsoft-fabric-rti-mcp console script; the LICENSE is MIT, Copyright (c) Microsoft Corporation.

### Not established by this review

 - uvx launch
- Any Kusto query or command
- Any Eventstream, Activator or Map change
- HTTP mode

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

## Connect a server deliberately.

[Upstream setup instructions ↗](https://github.com/microsoft/fabric-rti-mcp/blob/3c765f92ca5067be8ad70a4b5c5daf8f20f236d9/README.md)
 - The README installs through VS Code (MCP: Add Server, then the PyPI package microsoft-fabric-rti-mcp) or GitHub Copilot CLI (/mcp add), ending in the uvx block shown. It was not run.
- Set KUSTO_ALLOW_UNKNOWN_SERVICES=false with KUSTO_KNOWN_SERVICES, and FABRIC_RTI_ALLOWED_TOOLS, to limit which clusters and tools the agent can reach.

### Before you start

 - uv
- An Azure identity with access to the Fabric workspace or Kusto cluster

### Documented configuration example

Use the client and authentication context described in the setup guidance. Configuration formats vary between hosts.

 {
 "mcpServers": {
 "fabric-rti-mcp": {
 "command": "uvx",
 "args": [
 "microsoft-fabric-rti-mcp"
 ],
 "env": {
 "KUSTO_SERVICE_URI": "https://help.kusto.windows.net/",
 "KUSTO_SERVICE_DEFAULT_DB": "Samples",
 "FABRIC_API_BASE": "https://api.fabric.microsoft.com/v1"
 }
 }
 }
} Copy configuration ↗

### Compatibility

VS Code · GitHub Copilot · GitHub Copilot CLI

### Implementation

Python

### Transports

stdio · HTTP

### Local process with Azure Identity credentials

 - Runs KQL queries and management commands on Kusto clusters the signed-in identity can reach
- Creates, updates and deletes Eventstreams, Activator triggers and Maps allowed by the user's Fabric roles

### Cost model

MIT server source. Fabric capacity and Azure Data Explorer usage are billed by Microsoft; no rate was reviewed.

04 / FOLLOW THE EVIDENCE

## The source trail.

Our notes are separate from the original resource. Check upstream before adopting a new version.

 - [Fabric RTI MCP README ↗](https://github.com/microsoft/fabric-rti-mcp/blob/3c765f92ca5067be8ad70a4b5c5daf8f20f236d9/README.md) Checked 2026-10-13 https://github.com/microsoft/fabric-rti-mcp/blob/3c765f92ca5067be8ad70a4b5c5daf8f20f236d9/README.md Supports: Tools, Installation, Configuration, Authentication, HTTP mode, Permissions and data collection
- [Fabric RTI MCP pyproject.toml ↗](https://github.com/microsoft/fabric-rti-mcp/blob/3c765f92ca5067be8ad70a4b5c5daf8f20f236d9/pyproject.toml) Checked 2026-10-13 https://github.com/microsoft/fabric-rti-mcp/blob/3c765f92ca5067be8ad70a4b5c5daf8f20f236d9/pyproject.toml Supports: Package name, License MIT, Console script
- [Fabric RTI MCP LICENSE ↗](https://github.com/microsoft/fabric-rti-mcp/blob/3c765f92ca5067be8ad70a4b5c5daf8f20f236d9/LICENSE) Checked 2026-10-13 https://github.com/microsoft/fabric-rti-mcp/blob/3c765f92ca5067be8ad70a4b5c5daf8f20f236d9/LICENSE Supports: MIT License, Copyright (c) Microsoft Corporation

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### ClickHouse MCP Server ↗ Queries ClickHouse and inspects table metadata, with read-only SQL by default and separate authentication for network transports.](/mcp-servers/clickhouse/)[### CrateDB MCP Server ↗ Python MCP server from the crate organisation that runs SQL against a CrateDB cluster over its HTTP endpoint behind a SELECT-only check, reads table columns, table metadata and cluster health, lists a curated CrateDB documentation index, and fetches documentation pages by link under three permitted URL prefixes.](/mcp-servers/cratedb/)[### Firebolt MCP Server ↗ Go MCP server from Firebolt that connects a client to Firebolt Cloud or Firebolt Core, runs SQL, and exposes Firebolt documentation tools.](/mcp-servers/firebolt/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Inspect resource evidence](/tools/)
- [Choose a host](/agents/)
- [Inspect reusable workflows](/skills/)
- [Use Undominated data](/api/)
