Kql Generator — Development agent for Claude Code
Generates KQL queries dynamically from parsed-schema.json and thresholds.json.
How to install Kql Generator
Installs to ~/.claude/agents/prashantdce21msft-d365-observability-hub-kql-generator.md
mkdir -p ~/.claude/agents && curl -fsSL https://raw.githubusercontent.com/prashantdce21MSFT/d365-observability-hub/HEAD/.claude/agents/kql-generator.md -o ~/.claude/agents/prashantdce21msft-d365-observability-hub-kql-generator.md Restart Claude Code, or start a new session, for it to be picked up.
What Kql Generator does
name: kql-generator <<<<<<< HEAD description: Generates KQL queries dynamically from parsed-schema.json and thresholds.json. Never hardcodes event names, column names, table names, or thresholds. All values come from the schema. tools: Read, Write
KQL Generator
Purpose
Write production-ready KQL queries based purely on the discovered schema. Never assume any event name, column name, or threshold value — always read from `schemas/parsed-schema.json`.
Instructions
Step 1 —
Alternatives in Development
- Civitai Perf Review — Reviews a feature segment in the main Civitai Next.js app (src/) for production performance — N+1 queries, uni 7.2k ★
- Stimulus Agent — Creates accessible Stimulus controllers following Hotwire patterns with targets, values, and actions 652 ★
- Phpdoc Writer — Writes clear, comprehensive PHPDoc blocks for PHP classes and methods 129 ★
Full documentation available on GitHub
View Source RepositoryRelated Agents
Batch Agent
Specialist agent for D365 batch job monitoring. Reads all configuration from parsed-schema.json — never hardco
Dmf Agent
Specialist agent for D365 DMF export/import monitoring. Reads all configuration from parsed-schema.json — neve
Cross Ref
Locates a named feature (component, page, hook, function, route, style, modal, table column) inside ONE repo a
Table Agent
Owns TanStack Table work — column definitions, sorting, filtering, pagination, row selection and the shared ta
Settings Lookup
Look up INAV settings from settings.yaml. Use PROACTIVELY when needing setting names, valid values, defaults,
Deep Review Cross Table
Audits queries (count, filter, exists, aggregate) for wrong-table bugs — especially when parallel models shoul
Related Skills
Load Schema
Initialise the system by running schema-analyst to discover all tables, event names, columns and fields dynami
Create Table
Skill: Schema Change (Create Table / Add Column / Add View / Etc.)
Update Models Roster
Record a model change — or a temporary tier substitution — in the Model Roster, the single place concrete mode
