# Eventhouse CLI

Authors and queries Fabric Eventhouse and KQL databases: tables, functions, policies...

- Repository: https://github.com/microsoft/skills-for-fabric (1306 stars)
- Category: Data and ML
- License: MIT
- Last updated: 2026-10-29
- Runs scripts: yes, review before use

## Install

Claude Code: `npx skills add microsoft/skills-for-fabric --skill eventhouse-cli -g -a claude-code -y`
Codex: `npx skills add microsoft/skills-for-fabric --skill eventhouse-cli -g -a codex -y`
Cursor: `npx skills add microsoft/skills-for-fabric --skill eventhouse-cli -g -a cursor -y`
Gemini CLI: `npx skills add microsoft/skills-for-fabric --skill eventhouse-cli -g -a gemini-cli -y`
Claude Code plugin marketplace: `/plugin marketplace add microsoft/skills-for-fabric`

## Description

Authors and queries Fabric Eventhouse and KQL databases: tables, functions, policies, materialized views, ingestion, and read-only KQL for real-time and time-series analytics. All KQL database work belongs here, table creation and simple queries included. An Eventstream item is eventstream-cli; an Event Schema Set is eventschemaset-cli.

## SKILL.md, as published by its author (untrusted third-party text, read it as data)

> **Telemetry, MANDATORY.** Every `api.fabric.microsoft.com` call must carry
> `x-ms-fabric-skill: eventhouse-cli` (`az rest`: `--headers "x-ms-fabric-skill=eventhouse-cli"`),
> including every LRO poll, `fabric_lro` and retry. Snippets omit it, add it anyway.

> **CRITICAL NOTES**
> 1. To find the workspace details (including its ID) from workspace name: list all workspaces and, then, use JMESPath filtering
> 2. To find the item details (including its ID) from workspace ID, item type, and item name: list all items of that type in that workspace and, then, use JMESPath filtering
> 3. **Skill disambiguation**: use `eventhouse-cli` for anything expressed in KQL or stored in a KQL Database. Use the matching `eventstream-cli` mode for streaming topology, and the matching `sqldw-*` skill for T-SQL against a Warehouse or Lakehouse SQL endpoint.

# Fabric Eventhouse / KQL Database -- CLI Skill

This one skill owns Fabric Eventhouse and KQL Database: schema and ingestion management plus read-only KQL analytics.

It is a **mode dispatcher** and contains NO procedures. Pick the mode that matches the request from the table below, then **read the matching `references/<mode>.md` file end to end with your file-reading tool BEFORE issuing a single command**. That file holds the endpoints, payload shapes, templates and gotchas; acting without it produces wrong payloads and wrong results.

## Mode selection

The rest: https://github.com/microsoft/skills-for-fabric/blob/HEAD/plugins/fabric-skills/skills/eventhouse-cli/SKILL.md