Skip to main content

Install with UVX in VS Code PyPI Downloads

🎯 Overview

A Model Context Protocol (MCP) server implementation for Microsoft Fabric Real-Time Intelligence (RTI). This server enables AI agents to interact with Fabric RTI services by providing tools through the MCP interface, allowing for seamless data querying and analysis capabilities.

🔍 How It Works

The Fabric RTI MCP Server creates a seamless integration between AI agents and Fabric RTI services through:

  • 🔄 Smart JSON communication that AI agents understand
  • 🏗️ Natural language commands that get translated to Kql operations
  • 💡 Intelligent parameter suggestions and auto-completion!
  • ⚡ Consistent error handling that makes sense

✨ Supported Services

🚧 Coming soon

  • Activator
  • Eventstreams
  • Other RTI items

🔍 Explore your data

  • "Get databases in Eventhouse'"
  • "Sample 10 rows from table 'StormEvents' in Eventhouse"
  • "What can you tell me about StormEvents data?"
  • "Analyze the StormEvents to come up with trend analysis ocross past 10 years of data"
  • "Analyze the commands in 'CommandExecution' table and categorize them as low/medium/high risks"

Available tools

  • List databases
  • List tables
  • Get schema for a table
  • Sample rows from a table
  • Execute query
  • Ingest a csv

Getting Started

Prerequisites

  1. Install either the stable or Insiders release of VS Code:
  2. Install the GitHub Copilot and GitHub Copilot Chat extensions
  3. Install uv
powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"

or, check here for other install options

  1. Open VS Code in an empty folder

Install from PyPI (Pip)

The Fabric RTI MCP Server is available on PyPI, so you can install it using pip. This is the easiest way to install the server.

From VS Code

1. Open the command palette (Ctrl+Shift+P) and run the command `MCP: Add Server`
2. Select install from Pip
3. When prompted, enter the package name `fabric-rti-mcp`
4. Follow the prompts to install the package and add it to your settings.json file

The process should end with the below settings in your settings.json file.

settings.json

{
    "mcp": {
        "server": {
            "fabric-rti-mcp": {
                "command": "uvx",
                "args": [
                    "microsoft-fabric-rti-mcp"
                ]
            }
        }
    }
}

🔧 Manual Install (Install from source)

  1. Make sure you have Python 3.10+ installed properly and added to your PATH.
  2. Clone the repository
  3. Install the dependencies (pip install . or uv tool install .)
  4. Add the settings below into your vscode settings.json file.
  5. Change the path to match the repo location on your machine.
  6. Change the cluster uri in the settings to match your cluster.
{
    "mcp": {
        "servers": {
            "kusto-mcp": {
                "command": "uv",
                "args": [
                    "--directory",
                    "C:/path/to/fabric-rti-mcp/",
                    "run",
                    "-m",
                    "fabric_rti_mcp.server"
                ]
            }
        }
    }
}

🐛 Debugging the MCP Server locally

Assuming you have python installed and the repo cloned:

Install locally

pip install -e ".[dev]"

Configure

Add the server to your

{
    "mcp": {
        "servers": {
            "local-fabric-rti-mcp": {
                "command": "python",
                "args": [
                    "-m",
                    "fabric_rti_mcp.server"
                ]
            }
        }
    }
}

Attach the debugger

Use the Python: Attach configuration in your launch.json to attach to the running server. Once VS Code picks up the server and starts it, navigate to it's output:

  1. Open command palette (Ctrl+Shift+P) and run the command MCP: List Servers
  2. Navigate to local-fabric-rti-mcp and select Show Output
  3. Pick up the process id (PID) of the server from the output
  4. Run the Python: Attach configuration in your launch.json file, and paste the PID of the server in the prompt
  5. The debugger will attach to the server process, and you can start debugging

🧪 Test the MCP Server

  1. Open GitHub Copilot in VS Code and switch to Agent mode
  2. You should see the Fabric RTI MCP Server in the list of tools
  3. Try a prompt that tells the agent to use the Eventhouse tools, such as "List my Kusto tables"
  4. The agent should be able to use the Fabric RTI MCP Server tools to complete your query

🔑 Authentication

The MCP Server seamlessly integrates with your host operating system's authentication mechanisms, making it super easy to get started! We use Azure Identity under the hood via DefaultAzureCredential, which tries these credentials in order:

  1. Environment Variables (EnvironmentCredential) - Perfect for CI/CD pipelines
  2. Visual Studio (VisualStudioCredential) - Uses your Visual Studio credentials
  3. Azure CLI (AzureCliCredential) - Uses your existing Azure CLI login
  4. Azure PowerShell (AzurePowerShellCredential) - Uses your Az PowerShell login
  5. Azure Developer CLI (AzureDeveloperCliCredential) - Uses your azd login
  6. Interactive Browser (InteractiveBrowserCredential) - Falls back to browser-based login if needed

If you're already logged in through any of these methods, the Fabric RTI MCP Server will automatically use those credentials.

🛡️ Security Note

Your credentials are always handled securely through the official Azure Identity SDK - we never store or manage tokens directly.

MCP as a phenomenon is very novel and cutting-edge. As with all new technology standards, consider doing a security review to ensure any systems that integrate with MCP servers follow all regulations and standards your system is expected to adhere to. This includes not only the Azure MCP Server, but any MCP client/agent that you choose to implement down to the model provider.

👥 Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.

When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

🤝 Code of Conduct

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.

Data Collection

The software may collect information about you and your use of the software and send it to Microsoft. Microsoft may use this information to provide services and improve our products and services. You may turn off the telemetry as described in the repository. There are also some features in the software that may enable you and Microsoft to collect data from users of your applications. If you use these features, you must comply with applicable law, including providing appropriate notices to users of your applications together with a copy of Microsoft’s privacy statement. Our privacy statement is located at https://go.microsoft.com/fwlink/?LinkID=824704. You can learn more about data collection and use in the help documentation and our privacy statement. Your use of the software operates as your consent to these practices.

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.

Metadata

Release files for microsoft-fabric-rti-mcp 0.0.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for microsoft-fabric-rti-mcp 0.0.1
File Size Uploaded Provenance Actions
microsoft_fabric_rti_mcp-0.0.1.tar.gz 75.0 kB With provenance Details for microsoft_fabric_rti_mcp-0.0.1.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for microsoft-fabric-rti-mcp 0.0.1
File Interpreter ABI Platform Actions
microsoft_fabric_rti_mcp-0.0.1-py3-none-any.whl Python 3 none any Details for microsoft_fabric_rti_mcp-0.0.1-py3-none-any.whl

Total release size: 86.9 kB

Release files / microsoft_fabric_rti_mcp-0.0.1.tar.gz

Download URL microsoft_fabric_rti_mcp-0.0.1.tar.gz
Size 75.0 kB
Tags Source
SHA-256 checksum
How to use checksums
8d5c5e7e61599d86fe21e4a9f3fa02d45b0cedbd878c72c9abe70f942194b3cd
BLAKE2b-256 checksum
How to use checksums
5e967a2e92d7cde81d52f900f35e3e0948107e84904700fc2f4f1710c0b9b79b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/6.1.0 CPython/3.12.9

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Jun 2, 2025.

Transparency log

Release files / microsoft_fabric_rti_mcp-0.0.1-py3-none-any.whl

Download URL microsoft_fabric_rti_mcp-0.0.1-py3-none-any.whl
Size 11.9 kB
Tags Python 3
SHA-256 checksum
How to use checksums
6f21050deec5dd5e140168662be79c3d651f9970210dbe4fe17e9cd179794fc3
BLAKE2b-256 checksum
How to use checksums
6793f4e04fa06633571b942f79d1d6953875b9fb10ad7cb89b833a7e9807bedc
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/6.1.0 CPython/3.12.9

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Jun 2, 2025.

Transparency log

Security for microsoft-fabric-rti-mcp 0.0.1

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Full provenance

Both files in this release have been uploaded with provenance metadata.

Select from 2 files

Attestation for microsoft_fabric_rti_mcp-0.0.1.tar.gz

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Jun 2, 2025.

Transparency log

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page