fabric-rti-mcp: Skill for Claude Code

KQL Mastery

Try it yourself: All ✅ examples in this skill can be run against the public help cluster: https://help.kusto.windows.net, database Samples (contains StormEvents, SimpleGraph_Nodes/Edges, nyc_taxi, and more).

1. Running KQL with Fabric RTI MCP

Fabric RTI MCP exposes Kusto functionality as MCP tools. Authentication is handled transparently using Azure Identity.

Available tools

Tool	Purpose
kusto_query	Execute a KQL query on a database
kusto_command	Execute a management command (.show, .create, etc.)
kusto_list_entities	List databases, tables, external tables, materialized views, functions, graphs
kusto_describe_database	Get schema for all entities in a database
kusto_describe_database_entity	Get schema for a specific entity (table, function, etc.)
kusto_sample_entity	Get sample data from a table or other entity
kusto_graph_query	Execute a graph query using snapshots or transient graphs
kusto_ingest_inline_into_table	Ingest inline CSV data into a table
kusto_known_services	List configured Kusto services
kusto_get_shots	Retrieve semantically similar shots from a shots table
kusto_deeplink_from_query	Build a deeplink URL to open a query in the web explorer
kusto_show_queryplan	Get the execution plan for a query without running it
kusto_diagnostics	Get a best-effort cluster health and capacity summary

Query vs management commands

KQL has two execution planes, each with its own MCP tool:

Plane	Tool	Starts with	Examples
Query	kusto_query	Table name, let, print, datatable	StormEvents | where State == "TEXAS"
Management	kusto_command	.show, .create, .set, .drop, .alter	.show tables, .show table T schema

Basic usage

# Query plane — use kusto_query
kusto_query(
    cluster_uri="https://help.kusto.windows.net",
    database="Samples",
    query="StormEvents | summarize count() by EventType | top 5 by count_ desc"
)

# Management plane — use kusto_command
kusto_command(
    cluster_uri="https://help.kusto.windows.net",
    database="Samples",
    command=".show tables"
)

# Schema exploration — use kusto_describe_database or kusto_describe_database_entity
kusto_describe_database(
    cluster_uri="https://help.kusto.windows.net",
    database="Samples"
)

# Sample data — use kusto_sample_entity
kusto_sample_entity(
    cluster_uri="https://help.kusto.windows.net",
    database="Samples",
    entity_name="StormEvents",
    entity_type="table",
    sample_size=5
)

# Graph queries — use kusto_graph_query
kusto_graph_query(
    cluster_uri="https://mycluster.kusto.windows.net",
    database="MyDB",
    graph_name="MyGraph",
    query="| graph-match (node) project labels=labels(node)"
)

# Deeplinks — use kusto_deeplink_from_query
kusto_deeplink_from_query(
    cluster_uri="https://help.kusto.windows.net",
    database="Samples",
    query="StormEvents | count"
)