Fabric RTI
MCP server for Fabric Real-Time Intelligence (https://aka.ms/fabricrti) supporting tools for Eventhouse (https://aka.ms/eventhouse), Azure Data Explorer (https://aka.ms/adx, and other RTI services (coming soon)
What is Fabric RTI?
Fabric RTI is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to mcp server for fabric real-time intelligence (https://aka.ms/fabricrti) supporting tools for eventhouse (https://aka.ms/eventhouse), azure data explorer (https://aka.ms/adx, and other rti services (co...
MCP server for Fabric Real-Time Intelligence (https://aka.ms/fabricrti) supporting tools for Eventhouse (https://aka.ms/eventhouse), Azure Data Explorer (https://aka.ms/adx, and other RTI services (coming soon)
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- MCP server for Fabric Real-Time Intelligence (https://aka.ms
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx fabric-rtiConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Fabric RTI
The Fabric RTI MCP Server connects AI assistants to Microsoft Fabric's Real-Time Intelligence platform, including Eventhouse, Azure Data Explorer (Kusto), Eventstreams, Activator, and Map services. It exposes over 30 tools across these services, enabling AI agents to execute KQL queries, manage real-time data pipelines, create monitoring triggers, and visualize geospatial data. Developers and data engineers working with Microsoft Fabric can use this server to query and manage streaming analytics workloads directly from their AI coding assistant without switching contexts.
Prerequisites
- Python 3.9+ and pip or uv package manager installed
- Microsoft Fabric workspace with Real-Time Intelligence services (Eventhouse or Azure Data Explorer)
- Azure CLI installed and logged in, or another Azure credential provider for DefaultAzureCredential authentication
- An MCP-compatible client such as VS Code with GitHub Copilot, Claude Desktop, or Cursor
- Network access to your Kusto/Eventhouse cluster endpoint
Install the package
Install the microsoft-fabric-rti-mcp package from PyPI using pip or uv. Using uv tool install is recommended as it creates an isolated environment.
pip install microsoft-fabric-rti-mcp
# or with uv (recommended)
uv tool install microsoft-fabric-rti-mcpAuthenticate with Azure
The server uses Azure Identity's DefaultAzureCredential chain. Log in with the Azure CLI before starting the server so credentials are automatically discovered.
az loginConfigure environment variables
Set the required environment variables for your Eventhouse or Azure Data Explorer cluster. KUSTO_SERVICE_URI is the cluster endpoint and KUSTO_SERVICE_DEFAULT_DB is the default database to query.
export KUSTO_SERVICE_URI="https://yourcluster.kusto.windows.net"
export KUSTO_SERVICE_DEFAULT_DB="YourDatabase"
# Optional: for Fabric API access
export FABRIC_API_BASE="https://api.fabric.microsoft.com/v1"Add the server to your MCP client
Configure your MCP client (Claude Desktop, VS Code, or Cursor) to launch the server. The configuration JSON below uses the uvx runner for Claude Desktop.
Verify connection by running a test query
Once configured, open your MCP client and ask it to list databases in your Eventhouse. This confirms the server is running and credentials are valid.
Fabric RTI Examples
Client configuration
Claude Desktop configuration using uvx to run the Fabric RTI MCP server with required environment variables.
{
"mcpServers": {
"fabric-rti": {
"command": "uvx",
"args": ["microsoft-fabric-rti-mcp"],
"env": {
"KUSTO_SERVICE_URI": "https://yourcluster.kusto.windows.net",
"KUSTO_SERVICE_DEFAULT_DB": "YourDatabase",
"FABRIC_API_BASE": "https://api.fabric.microsoft.com/v1",
"FABRIC_RTI_TRANSPORT": "stdio"
}
}
}
}Prompts to try
Example prompts to use with the Fabric RTI MCP server after setup.
- "Get all databases in my Eventhouse cluster"
- "Sample 10 rows from the StormEvents table"
- "Run a KQL query: SignalRServiceDiagnosticLogs | count"
- "List all Eventstreams in my Fabric workspace"
- "Create a Teams alert trigger when error rate exceeds 5% for my IoT stream"
- "Show me details of the Eventstream named SensorData"Troubleshooting Fabric RTI
Authentication fails with DefaultAzureCredential error
Run 'az login' in your terminal and ensure your Azure account has Viewer or Contributor access to the Fabric workspace. If using a service principal, set AZURE_CLIENT_ID, AZURE_CLIENT_SECRET, and AZURE_TENANT_ID environment variables.
KQL queries return 'cluster not found' or connection timeout
Verify KUSTO_SERVICE_URI is the correct cluster URI (format: https://<clustername>.<region>.kusto.windows.net). Test connectivity by running 'az kusto cluster show' or opening the cluster URL in a browser.
Server fails to start after pip install
Ensure you are running Python 3.9+ with 'python --version'. If using uv, run 'uv tool install microsoft-fabric-rti-mcp' to install in an isolated environment and ensure ~/.local/bin is in your PATH.
Frequently Asked Questions about Fabric RTI
What is Fabric RTI?
Fabric RTI is a Model Context Protocol (MCP) server that mcp server for fabric real-time intelligence (https://aka.ms/fabricrti) supporting tools for eventhouse (https://aka.ms/eventhouse), azure data explorer (https://aka.ms/adx, and other rti services (coming soon) It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Fabric RTI?
Follow the installation instructions on the Fabric RTI GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Fabric RTI?
Fabric RTI works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Fabric RTI free to use?
Yes, Fabric RTI is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
Fabric RTI Alternatives — Similar Databases Servers
Looking for alternatives to Fabric RTI? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Fabric RTI 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 Fabric RTI?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.