Claude-skill-registry fabric-rti-mcp
Expert guidance for Microsoft Fabric Real-Time Intelligence (RTI) using the Fabric RTI MCP Server. Execute KQL queries on Eventhouse, manage Eventstreams for real-time data processing, create Activator triggers for alerting, and manage Map items. Use when working with Fabric RTI, KQL, real-time analytics, streaming data, or event-driven applications.
git clone https://github.com/majiayu000/claude-skill-registry
T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/fabric-rti-mcp-housegarofalo-claude-code-base" ~/.claude/skills/majiayu000-claude-skill-registry-fabric-rti-mcp && rm -rf "$T"
skills/data/fabric-rti-mcp-housegarofalo-claude-code-base/SKILL.mdMicrosoft Fabric RTI Expert
Expert guidance for Microsoft Fabric Real-Time Intelligence using the Fabric RTI MCP Server. Work with Eventhouse databases, Eventstreams, Activators, and Maps through natural language.
Core Capabilities
- Eventhouse/KQL (12 tools) - Query data, manage schemas, sample data
- Eventstreams (17 tools) - Build real-time streaming pipelines
- Activator (2 tools) - Create triggers and alerts
- Map (7 tools) - Manage data visualizations
Quick Reference
Eventhouse Tools
| Tool | Purpose |
|---|---|
| Execute KQL queries |
| List tables in database |
| Get table schema |
| Sample table records |
| Ingest CSV data |
Eventstream Tools
| Tool | Purpose |
|---|---|
| List Eventstreams |
| Create new Eventstream |
| Add sample data source |
| Add Eventhouse destination |
| Validate configuration |
Activator Tools
| Tool | Purpose |
|---|---|
| List triggers |
| Create alert trigger |
Map Tools
| Tool | Purpose |
|---|---|
| List Maps |
| Create new Map |
| Get Map configuration |
Querying Data with KQL
kusto_query
Execute KQL queries against Eventhouse databases.
Parameters:
(string) - Target database namedatabase
(string) - KQL query textquery
Example:
StormEvents | where State == "ILLINOIS" and EventType == "Flood" | summarize Count=count() by StartTime | order by StartTime desc
kusto_sample_table_data
Get sample records from a table.
Parameters:
(string)table_name
(number, default: 10)sample_count
Managing Eventstreams
eventstream_create
Create a new Eventstream for real-time data processing.
Parameters:
(string)workspace_id
(string)display_name
(string, optional)description
eventstream_add_eventhouse_destination
Route data to Eventhouse for analytics.
Parameters:
(string)eventhouse_id
(string)kql_database_id
(string)table_name
(string) - "Json", "Csv", etc.input_serialization_type
Workflow
1. eventstream_start_definition 2. eventstream_add_sample_data_source 3. eventstream_add_eventhouse_destination 4. eventstream_validate_definition 5. eventstream_create_from_definition
Creating Activator Triggers
activator_create_trigger
Create triggers for real-time alerting.
Parameters:
(string)workspace_id
(string)display_name
(string)description
(string)eventhouse_id
(string)kql_database_id
(string) - KQL query for monitoringquery
(string) - "Email", "Teams"notification_type
(array) - Email addresses or Teams webhooksrecipients
Example: Monitor for floods and send email alert
Query: StormEvents | where EventType == "Flood" and State == "ILLINOIS" Notification: Email to admin@company.com
Common Scenarios
Query Analysis
1. kusto_list_databases - Find databases 2. kusto_list_tables - Find tables 3. kusto_get_table_schema - Understand structure 4. kusto_query - Run analysis query
Real-Time Pipeline
1. eventstream_create - Create pipeline 2. eventstream_add_custom_endpoint_source - Add data source 3. eventstream_add_derived_stream - Transform data 4. eventstream_add_eventhouse_destination - Save to database 5. eventstream_validate_definition - Check config
Alerting Setup
1. kusto_query - Test alert condition 2. activator_create_trigger - Create alert 3. Monitor for notifications
When to Use This Skill
- Querying Fabric Eventhouse with KQL
- Building real-time data streaming pipelines
- Creating data-driven alerts and triggers
- Managing real-time analytics workloads
- Working with time-series and event data
- Implementing event-driven architectures
Keywords
microsoft fabric, real-time intelligence, rti, eventhouse, kql, kusto, eventstream, activator, map, real-time analytics, streaming data, event-driven, triggers, alerts, time-series data