azure-kusto-irql-graph
Skill1.6k starsChanged 19 days agoMITView on GitHub
Apply IRQL graph functions to KQL or IRQL query results for Kusto Explorer visualization. Generates Lift_To_Graph mappings and composes Graph_Render_View, Graph_Fold_By_Property, Extract_Node_*, Enrich_Node_*, and Enrich_Graph_* calls. Accepts a supplied query or limited basic natural-language source request; it is not a general natural-language-to-KQL/IRQL skill. WHEN: Lift_To_Graph, Graph_Render_View, Graph_Fold_By_Property, IRQL graph enrichment, graph mapping for existing query results, icon-decorated graph, fold graph nodes. Use azure-kusto-graph for native make-graph analysis, graph-match, shortest paths, components, or persistent graphs.
3 other projects use a version of this, 1 of them edited.
Trending
More talk lately.about the whole repository
Most recently taken up by
- microsoft/GitHub-Copilot-for-Azureedited, first seen Oct 13, 2026
- microsoft/skillsword for word, first seen Oct 13, 2026
- microsoft/agent-skillsword for word, first seen Oct 8, 2026
Who's talking about microsoft/azure-skills
- microsoft/apm“Fold marketplace authoring config into apm.yml as the single APM surface”GitHub · Apr 29, 2026 · 2 reactions
- salaboy/skills-oci“Support for Skill Collections”GitHub · Jul 3, 2026 · 1 reactions
- Azure/azure-dev“Add `azd tool install/upgrade azure-skills` with per-host selection”GitHub · Jun 18, 2026 · 1 reactions
- microsoft/apm“feat(pack): unify 'apm pack' to produce bundle and marketplace.json (closes #722)”GitHub · Apr 29, 2026 · 1 reactions
- microsoft/GitHub-Copilot-for-Azure“Update CHANGELOG.md when syncing plugin content”GitHub · Apr 16, 2026 · 1 reactions
The biggest 5 of 50 mentions linking to the repository that our crawl found. Each line is their own headline.
See all 50
Talked about on GitHub (50 times).
On GitHub · 50
- Apr 29, 2026Fold marketplace authoring config into apm.yml as the single APM surface — microsoft/apm2 reactions
- Jul 3, 2026Support for Skill Collections — salaboy/skills-oci1 reaction
- Jun 18, 2026Add `azd tool install/upgrade azure-skills` with per-host selection — Azure/azure-dev1 reaction · 1 comment
- Apr 29, 2026feat(pack): unify 'apm pack' to produce bundle and marketplace.json (closes #722) — microsoft/apm1 reaction · 1 comment
- Apr 16, 2026Update CHANGELOG.md when syncing plugin content — microsoft/GitHub-Copilot-for-Azure1 reaction · 2 comments
45 more on GitHub
- Nov 14, 2026agent-skills.github.microsoft.azure-skills: 1.2.123 → 1.2.124 — sudosubin/agents.nix0 reactions
- Nov 13, 2026claude-code-marketplaces.github.microsoft.azure-skills: 1.2.123 → 1.2.124 — sudosubin/agents.nix0 reactions
- Nov 13, 2026claude-code-plugins.github.microsoft.azure-skills: 1.2.123 → 1.2.124 — sudosubin/agents.nix0 reactions
- Nov 13, 2026agent-plugins.github.microsoft.azure-skills: 1.2.123 → 1.2.124 — sudosubin/agents.nix0 reactions
- Nov 13, 2026copilot-plugins.github.microsoft.azure-skills: 1.2.123 → 1.2.124 — sudosubin/agents.nix0 reactions
- Nov 13, 2026[Skill Bug]: prereq native-module unknown guidance conflicts with Boolean schema — microsoft/GitHub-Copilot-for-Azure0 reactions · 1 comment
- Nov 13, 2026agent-skills.github.microsoft.azure-skills: 1.2.122 → 1.2.123 — sudosubin/agents.nix0 reactions
- Nov 12, 2026claude-code-marketplaces.github.microsoft.azure-skills: 1.2.122 → 1.2.123 — sudosubin/agents.nix0 reactions
- Nov 12, 2026claude-code-plugins.github.microsoft.azure-skills: 1.2.122 → 1.2.123 — sudosubin/agents.nix0 reactions
- Nov 12, 2026agent-plugins.github.microsoft.azure-skills: 1.2.122 → 1.2.123 — sudosubin/agents.nix0 reactions
- Nov 12, 2026copilot-plugins.github.microsoft.azure-skills: 1.2.122 → 1.2.123 — sudosubin/agents.nix0 reactions
- Nov 10, 2026copilot-plugins.github.microsoft.azure-skills: 1.2.120 → 1.2.122 — sudosubin/agents.nix0 reactions
- Nov 10, 2026agent-skills.github.microsoft.azure-skills: 1.2.120 → 1.2.122 — sudosubin/agents.nix0 reactions
- Nov 10, 2026claude-code-marketplaces.github.microsoft.azure-skills: 1.2.120 → 1.2.122 — sudosubin/agents.nix0 reactions
- Nov 10, 2026claude-code-plugins.github.microsoft.azure-skills: 1.2.120 → 1.2.122 — sudosubin/agents.nix0 reactions
- Nov 10, 2026agent-plugins.github.microsoft.azure-skills: 1.2.120 → 1.2.122 — sudosubin/agents.nix0 reactions
- Nov 10, 2026copilot-plugins.github.microsoft.azure-skills: 1.2.118 → 1.2.120 — sudosubin/agents.nix0 reactions
- Nov 10, 2026claude-code-marketplaces.github.microsoft.azure-skills: 1.2.118 → 1.2.120 — sudosubin/agents.nix0 reactions
- Nov 10, 2026agent-skills.github.microsoft.azure-skills: 1.2.118 → 1.2.120 — sudosubin/agents.nix0 reactions
- Nov 10, 2026claude-code-plugins.github.microsoft.azure-skills: 1.2.118 → 1.2.120 — sudosubin/agents.nix0 reactions
- Nov 10, 2026agent-plugins.github.microsoft.azure-skills: 1.2.118 → 1.2.120 — sudosubin/agents.nix0 reactions
- Nov 9, 2026claude-code-marketplaces.github.microsoft.azure-skills: 1.2.115 → 1.2.118 — sudosubin/agents.nix0 reactions
- Nov 9, 2026chore: sync azure plugin name and version to apm.yml — microsoft/GitHub-Copilot-for-Azure0 reactions
- Nov 9, 2026copilot-plugins.github.microsoft.azure-skills: 1.2.115 → 1.2.118 — sudosubin/agents.nix0 reactions
- Nov 9, 2026agent-skills.github.microsoft.azure-skills: 1.2.115 → 1.2.118 — sudosubin/agents.nix0 reactions
- Nov 9, 2026claude-code-plugins.github.microsoft.azure-skills: 1.2.115 → 1.2.118 — sudosubin/agents.nix0 reactions
- Nov 9, 2026agent-plugins.github.microsoft.azure-skills: 1.2.115 → 1.2.118 — sudosubin/agents.nix0 reactions
- Nov 7, 2026claude-code-marketplaces.github.microsoft.azure-skills: 1.2.114 → 1.2.115 — sudosubin/agents.nix0 reactions
- Nov 6, 2026agent-skills.github.microsoft.azure-skills: 1.2.114 → 1.2.115 — sudosubin/agents.nix0 reactions
- Nov 6, 2026claude-code-plugins.github.microsoft.azure-skills: 1.2.114 → 1.2.115 — sudosubin/agents.nix0 reactions
- Nov 6, 2026agent-plugins.github.microsoft.azure-skills: 1.2.114 → 1.2.115 — sudosubin/agents.nix0 reactions
- Nov 6, 2026copilot-plugins.github.microsoft.azure-skills: 1.2.114 → 1.2.115 — sudosubin/agents.nix0 reactions
- Nov 6, 2026agent-skills.github.microsoft.azure-skills: 1.2.113 → 1.2.114 — sudosubin/agents.nix0 reactions
- Nov 5, 2026claude-code-plugins.github.microsoft.azure-skills: 1.2.113 → 1.2.114 — sudosubin/agents.nix0 reactions
- Nov 5, 2026agent-plugins.github.microsoft.azure-skills: 1.2.113 → 1.2.114 — sudosubin/agents.nix0 reactions
- Nov 5, 2026copilot-plugins.github.microsoft.azure-skills: 1.2.113 → 1.2.114 — sudosubin/agents.nix0 reactions
- Nov 5, 2026claude-code-marketplaces.github.microsoft.azure-skills: 1.2.113 → 1.2.114 — sudosubin/agents.nix0 reactions
- Nov 5, 2026agent-plugins.github.microsoft.azure-skills: init at 1.2.113 — sudosubin/agents.nix0 reactions
- Nov 4, 2026agent-skills.github.microsoft.azure-skills: 1.2.111 → 1.2.113 — sudosubin/agents.nix0 reactions
- Nov 4, 2026claude-code-plugins.github.microsoft.azure-skills: 1.2.111 → 1.2.113 — sudosubin/agents.nix0 reactions
- Nov 4, 2026agent-skills.github.microsoft.azure-skills: 1.2.110 → 1.2.111 — sudosubin/agents.nix0 reactions
- Nov 2, 2026agent-skills.github.microsoft.azure-skills: 1.2.109 → 1.2.110 — sudosubin/agents.nix0 reactions
- Nov 2, 2026chore: bump external skill pins — jthiruveedula/agentkit0 reactions
- Oct 30, 2026agent-skills.github.microsoft.azure-skills: 1.2.108 → 1.2.109 — sudosubin/agents.nix0 reactions
- Oct 29, 2026agent-skills.github.microsoft.azure-skills: 1.2.106 → 1.2.108 — sudosubin/agents.nix0 reactions
Other versions3 projects use a version of this.
Word for word · 2
- microsoft/skills★ 3.2k100% same
- microsoft/agent-skills★ 3.2k100% same
Edited · 1
- microsoft/GitHub-Copilot-for-Azure★ 264100% same
Wrote their own version · 0
None found.
How matches are found. Word for word: the exact same text. Edited: shares passages with this file (“99% same” means 99% of its five-word phrases also appear here; 10% or more counts). Their own version: similar meaning, or, weakest, the same name. We can’t tell which project had it first. Projects are counted among the 200 most-starred candidates, and mentions are links to the repository we found, up to 50 per site, so both counts are a floor.
In this repository88 other files it gives its agents.
- aks-cost-optimizationSkill
- aks-gpu-inferenceSkill
- aks-known-issuesSkill
- aks-network-captureSkill
- aks-troubleshootingSkill
- azure-search-navSkill
- azure-advisor-actionabilitySkill
- azure-advisor-cost-optimizationSkill
- azure-advisorSkill
- cost-analysisSkill
- cost-estimationSkill
- cost-governanceSkill
- cost-optimizationSkill
- azure-kusto-graphSkill
- azure-kusto-irqlSkill
- azure-local-multi-rackSkill
- azure-localSkill
- airunway-aks-setupSkill
- appinsights-instrumentationSkill
- azure-aigatewaySkill
- azure-aiSkill
- azure-app-onboard-prereqSkill
- azure-app-onboardSkill
- azure-cloud-migrateSkill
- azure-complianceSkill
- azure-computeSkill
- azure-deploySkill
- azure-diagnosticsSkill
- azure-enterprise-infra-plannerSkill
- azure-kubernetes-app-deploySkill
- azure-kubernetes-automatic-readinessSkill
- azure-kubernetesSkill
- azure-kustoSkill
- azure-messagingSkill
- azure-prepareSkill
- azure-quotasSkill
- azure-reliabilitySkill
- azure-resource-lookupSkill
- azure-resource-visualizerSkill
- azure-storageSkill
- azure-upgradeSkill
- azure-validateSkill
- discover-azure-skillsSkill
- entra-agent-idSkill
- entra-app-registrationSkill
- finetuningSkill
- capacitySkill
- customizeSkill
- presetSkill
- deploy-modelSkill
- microsoft-foundrySkill
- python-appservice-deploySkill
- foundry-iqSkill
- airunway-aks-setupSkill
- appinsights-instrumentationSkill
- azure-aigatewaySkill
- azure-aiSkill
- azure-app-onboard-prereqSkill
- azure-app-onboardSkill
- azure-cloud-migrateSkill
- The first 60 shown.
The file
Show its rules and text
We split this skill into the rules it gives an agent
19 rules. About 0 are common, 7 are distinctive, and 12 are very specific to this project.
≈0
Common · estimate
Many files like this have a rule of this kind.
≈7
Distinctive · estimate
This author's own choices. Worth a look.
12
Very specific
Tied to their project's names, files or tools. Probably skip.
- Common
- Distinctive
- Very specific
- Very specific: line 23
If a request mixes visualization and native graph analysis, use this skill for the lift/render portion and azure-kusto-graph for operator …
- Distinctive: line 32
If no query or output schema is available and the source is not trivial, request the KQL query or its result columns before generating a …
- Distinctive: line 36
Use this skill when the user:
- Very specific: line 43
Do not activate this skill solely for graph-match, graph paths/components, persistent graphs, or generic make-graph construction.
- Very specific: line 66
Check any Extract_Node_*, Enrich_Node_*, or Enrich_Graph_* function before using it.
- Distinctive: line 67
If a required function is missing and you have permission to alter the database, ask the user for confirmation before deploying.
- Very specific: line 68
If you do not have alter permissions, tell the user which functions are missing and point them to references/DEPLOY_IRQL_FUNCTIONS.md for …
- Very specific: line 136
Use icons from https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/:
- Distinctive: line 174
Start with the supplied KQL/IRQL tabular pipeline.
- Very specific: line 175
Use Lift_To_Graph(mapping) to create graph entities.
- Very specific: line 176
Add Extract_Node_*, Enrich_Node_*, or Enrich_Graph_* only when requested and compatible with the mapped keys.
- Very specific: line 177
Add Graph_Fold_By_Property() only when grouping/collapse is requested.
- Distinctive: line 266
When the user supplies a query and describes the graph:
- Very specific: line 273
If the user mentions grouping/collapsing and the function exists, add Graph_Fold_By_Property()
- Distinctive: line 281
Always output the complete KQL query in the chat response with Step 1 (connect) and Step 2 (query) clearly labeled:
- Very specific: line 294
If the user asks to save or open in Kusto Explorer, follow the procedure in references/KUSTO_EXPLORER_LAUNCH.md.
- Very specific: line 296
Use ask_user to confirm before writing files or launching executables
- Very specific: line 298
Never use shell interpolation or here-strings — write files via Set-Content/Add-Content
- Distinctive: line 299
Never encode queries into browser URLs
≈ “Common” is an estimate: at least 1 in 5 of the 364,980 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Files
IRQL Graph Functions -- Query Results to Visualization
Apply the IRQL graph function family to tabular results. Given a KQL or IRQL query and the user's graph description, generate a Lift_To_Graph mapping and compose only the stored graph functions needed to visualize, fold, extract, or enrich the graph in Kusto Explorer. The source query does not need to use IRQL.
Scope and Routing
| Request | Use |
| Turn supplied KQL/IRQL rows into an icon-decorated visual graph | This skill: Lift_To_Graph + Graph_Render_View |
Fold nodes or apply Extract_Node_*, Enrich_Node_*, or Enrich_Graph_* | This skill |
Use make-graph, graph-match, shortest paths, connected components, graph models, or snapshots | azure-kusto-graph |
| Author a non-trivial KQL/IRQL investigation from natural language | A Kusto or IRQL query-generation skill, then this skill |
If a request mixes visualization and native graph analysis, use this skill for the lift/render portion and azure-kusto-graph for operator semantics. Do not replace graph-lift functions with a hand-built edges-first graph unless the user asks for native graph operators.
Input Contract
- Preferred input: a working KQL/IRQL query that produces tabular results, plus a natural-language description of the desired nodes, edges, labels, icons, extracts, enrichments, or folds.
- This skill is not a natural-language-to-KQL or NL-to-IRQL converter. It transforms existing query results into graph visualizations. For general NL-to-KQL or NL-to-IRQL conversion, use a dedicated query-generation skill (available separately).
- Preserve the supplied query's retrieval, joins, filters, and aggregations. Add only projections or synthetic IDs required by the graph mapping.
- A basic natural-language source request is supported only when it maps directly to one known table or IRQL
Get_*selector with obvious columns and simple filters. State the assumed source, and do not invent joins, schema, or investigation logic. - For non-trivial query construction, use a separate Kusto/IRQL query-generation skill first, then apply this skill to its output.
- If no query or output schema is available and the source is not trivial, request the KQL query or its result columns before generating a mapping.
Activation Triggers
Use this skill when the user:
- Supplies KQL/IRQL results and asks for an IRQL graph visualization or mapping
- Mentions
Lift_To_Graph,Graph_Render_View, orGraph_Fold_By_Property - Asks for icon-decorated node/edge mappings in Kusto Explorer
- Wants to fold/collapse nodes by a shared property
- Requests graph extraction or enrichment through
Extract_Node_*,Enrich_Node_*, orEnrich_Graph_*
Do not activate this skill solely for graph-match, graph paths/components, persistent graphs, or generic make-graph construction; those belong to azure-kusto-graph.
Not a natural-language-to-KQL/IRQL converter. The input should generally be a working KQL or IRQL query whose results need graph visualization. Basic NL source requests work only for trivial single-table/selector cases. For general NL-to-KQL or NL-to-IRQL, use a dedicated query-generation skill (available separately).
Environment
- Cluster:
https://kc7001.eastus.kusto.windows.net - Databases:
ValdyTimes,JoJosHospital(graph functions pre-deployed) - Rendering: Kusto Explorer desktop app (make-graph visualization window)
- Tool:
kusto_query(via Azure MCP Server)
Function Preflight
Lift_To_Graph and Graph_Render_View are stored functions, not built-in Kusto operators. Before generating or running a lift pipeline against a target database, check what is deployed:
.show functions
| where Name in~ ("Lift_To_Graph", "Graph_Render_View", "Graph_Fold_By_Property")
| project NameLift_To_GraphandGraph_Render_Vieware required.Graph_Fold_By_Propertyis required only when folding is requested.- Check any
Extract_Node_*,Enrich_Node_*, orEnrich_Graph_*function before using it; omit optional enrichment when unavailable unless the user wants it deployed. - If a required function is missing and you have permission to alter the database, ask the user for confirmation before deploying. Then use the
.create-or-alter functiondefinitions in references/DEPLOY_IRQL_FUNCTIONS.md. Run the relevant.create-or-alterblock, then rerun the preflight check to confirm. - If you do not have alter permissions, tell the user which functions are missing and point them to
references/DEPLOY_IRQL_FUNCTIONS.mdfor manual deployment.
IRQL Graph Function Family
Lift_To_Graph(T, mappingJson)
Transforms any tabular KQL result into a unified node + edge table.
Input: Any table T + a JSON mapping string.
Output: Rows with EntityType = "node" or "edge", ready for make-graph.
Graph_Render_View(T)
Takes Lift_To_Graph output, splits nodes/edges, and calls make-graph to open Kusto Explorer's graph window.
Graph_Fold_By_Property(T, NodeType, PropertyName)
Collapses nodes of a given type sharing a property value into a single node. Rewires edges automatically.
Graph Extraction and Enrichment Functions
These are additional stored functions that must already be deployed on the target database. They are not bundled in references/DEPLOY_IRQL_FUNCTIONS.md. Use .show functions to verify availability before including in a pipeline.
| Function | Operation | Key Property |
Extract_Node_Email_Sender_Domain(T, displayName) | Adds Domain to node props | EmailSender |
Extract_Node_Employee_Firstname(T, displayName) | Adds Firstname to node props | Name |
Extract_Node_Event_Network_Domain(T, displayName) | Adds DomainName to node props | Url |
Enrich_Node_Ip_Employee(T, displayName) | Adds employee info to IP nodes | ClientIp |
Enrich_Node_Username_Employee(T, displayName) | Adds employee info to user nodes | Username |
Enrich_Node_Event_Authentication_Username(T, displayName) | Adds auth context | Username |
Enrich_Node_Ip_Domain(T, displayName) | Adds DNS domains | ClientIp |
Enrich_Node_Ip_Event_NetworkOutbound(T, displayName) | Adds outbound events | ClientIp |
Enrich_Graph_Ip_Employee(T, mappingJson) | Expands graph with employee nodes | ClientIp |
Enrich_Graph_Username_Employee(T, mappingJson) | Expands graph with employee nodes | Username |
Enrich_Graph_Event_Authentication_Username(T, mappingJson) | Expands with auth nodes | Username |
Mapping JSON Schema
The JSON mapping has two arrays: node_types and edges.
node_types[]
| Field | Required | Description |
type | Yes | Node type label (e.g. "User", "Host", "IP") |
id | Yes | Prefix for node ID; usually same as type |
key | Yes | Column name whose value becomes the node's identity |
props | Yes | Array of columns to carry as node properties |
defaults | No | Object of fallback values for null/empty properties |
defIcon | No | Default icon URL for this node type |
displayName | No | Column to use for display label (defaults to id) |
color | No | Column to source color from |
size | No | Column to source size from |
edges[]
| Field | Required | Description |
type | Yes | Edge type label (e.g. "AuthenticatesTo", "SentEmail") |
source | Yes | {"id": "<prefix>", "type": "<NodeType>"} |
target | Yes | {"id": "<prefix>", "type": "<NodeType>"} |
props | No | Array of columns to carry as edge properties |
displayName | No | Column for edge label |
color | No | Column for edge color |
Icon Repository
Use icons from https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/:
- IP:
Public-IP-Addresses-(Classic).svg - Host/VM:
Virtual-Machine.svg - User:
Users.svg - Email:
Mailbox.svg(orazure-cds/command-1070-Mail.svg) - Process:
App-Services.svg - File:
Storage-Accounts.svg - Alert:
Activity-Log.svg - Domain:
DNS-Zones.svg
Mapping Generation Rules
Given the supplied query columns and the user's graph description, generate the mapping JSON by:
- Identify entities -> each distinct noun becomes a
node_type - Identify relationships -> each verb/preposition becomes an
edge - Map to columns -> use actual columns produced by the supplied query; never assume unavailable columns
- Set direction -> source is the actor, target is the acted-upon
- Add properties -> include columns relevant to investigation (timestamps, results, hashes)
- Assign icons -> pick from the icon set above based on entity type
Column Reference (IRQL unified schema)
| Entity | Key Column | Available Props |
| User | Username | Username, Name, Role, Email |
| Host | Hostname | Hostname |
| IP | ClientIp | ClientIp |
| Email Message | Subject | EnvTime, Subject, Verdict, Url |
| Sender | EmailSender | EmailSender, Domain |
| Recipient | EmailRecipient | EmailRecipient |
| Process | ProcessName | EnvTime, ProcessName, ProcessCommandLine, ProcessHash |
| File | Filename | EnvTime, Filename, Path, Sha256 |
| Domain | DomainName | DomainName |
| Auth Event | (synthetic ID) | EnvTime, UserAgent, Result, Description |
Function Selection
- Start with the supplied KQL/IRQL tabular pipeline.
- Use
Lift_To_Graph(mapping)to create graph entities. - Add
Extract_Node_*,Enrich_Node_*, orEnrich_Graph_*only when requested and compatible with the mapped keys. - Add
Graph_Fold_By_Property()only when grouping/collapse is requested. - End visual output with
Graph_Render_View(). - Preflight the exact stored functions selected for the pipeline.
Pipeline Pattern
// 1. Preserve the supplied KQL or IRQL query
<input query>
// 2. Lift to graph
| invoke Lift_To_Graph(<mapping_json>)
// 3. Optionally extract or enrich graph entities
| invoke <Extract_Node_* | Enrich_Node_* | Enrich_Graph_*>()
// 4. Optionally fold nodes when requested
| invoke Graph_Fold_By_Property("<NodeType>", "<PropertyName>")
// 5. Render
| invoke Graph_Render_View()Examples
For additional prompts and worked examples, see references/EXAMPLES.md.
Authentication graph: IP -> AuthEvent -> User -> Host
Input query: Get_Event_Authentication_All | where Result == "Failed Login" | take 200
Graph request: "Show IPs, authentication events, users, and hosts; fold events by result."
let auth_mapping = '{"node_types":[{"type":"SrcIp","id":"SrcIp","key":"ClientIp","props":["ClientIp"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/Public-IP-Addresses-(Classic).svg"},{"type":"Host","id":"Host","key":"Hostname","props":["Hostname"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/Virtual-Machine.svg"},{"type":"User","id":"User","key":"Username","props":["Username"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/Users.svg"},{"type":"AuthEvent","id":"AuthEvent","key":"AuthEventId","props":["AuthEventId","EnvTime","UserAgent","Result","Description"],"defaults":{"Result":"unknown"},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/Activity-Log.svg"}],"edges":[{"type":"RequestsAuth","source":{"id":"SrcIp","type":"SrcIp"},"target":{"id":"AuthEvent","type":"AuthEvent"},"props":["EnvTime"]},{"type":"TargetsUser","source":{"id":"AuthEvent","type":"AuthEvent"},"target":{"id":"User","type":"User"},"props":["EnvTime"]},{"type":"AgainstHost","source":{"id":"AuthEvent","type":"AuthEvent"},"target":{"id":"Host","type":"Host"},"props":["EnvTime"]}]}';
Get_Event_Authentication_All
| extend AuthEventId = strcat(Username, "_", Hostname, "_", EnvTime)
| where Result == "Failed Login"
| take 200
| invoke Lift_To_Graph(auth_mapping)
| invoke Graph_Fold_By_Property("AuthEvent", "Result")
| invoke Graph_Render_View()Email graph: Sender -> Message -> Recipient
Input query: Get_Email_All | take 400
Graph request: "Visualize sender-to-message-to-recipient flow and fold messages by verdict."
let mail_mapping = '{"node_types":[{"type":"EmailMessage","id":"Message","key":"Subject","props":["EnvTime","Subject","Verdict"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/Media-File.svg"},{"type":"Sender","id":"Email","key":"EmailSender","props":["EmailSender"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-cds/command-1070-Mail.svg"},{"type":"Recipient","id":"Email","key":"EmailRecipient","props":["EmailRecipient"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-cds/command-1070-Mail.svg"}],"edges":[{"type":"SentBy","source":{"id":"Message","type":"EmailMessage"},"target":{"id":"Email","type":"Sender"},"props":["EnvTime","Verdict"]},{"type":"DeliveredTo","source":{"id":"Message","type":"EmailMessage"},"target":{"id":"Email","type":"Recipient"},"props":["EnvTime","Verdict"]}]}';
Get_Email_All
| take 400
| invoke Lift_To_Graph(mail_mapping)
| invoke Graph_Fold_By_Property("EmailMessage", "Verdict")
| invoke Graph_Render_View()Suspicious domain investigation (end-to-end)
Basic source request: "Use outbound network events for these suspicious domains and graph IP-to-domain connections enriched with employee names."
This is the limited fallback: one known selector, one extractor, and one direct filter.
let suspicious_domain_mapping = '{"node_types":[{"type":"IP","id":"IP","key":"ClientIp","props":["ClientIp"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/Public-IP-Addresses-(Classic).svg"},{"type":"Domain","id":"Domain","key":"DomainName","props":["DomainName"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/DNS-Zones.svg"}],"edges":[{"type":"ConnectsTo","source":{"id":"IP","type":"IP"},"target":{"id":"Domain","type":"Domain"},"props":["EnvTime"]}]}';
Get_Event_NetworkOutbound
| invoke Extract_Event_Network_Domain()
| where DomainName has_any ("raisinkanes.com", "nothing-to-see-here.net", "totally-legit-domain.com")
| invoke Lift_To_Graph(suspicious_domain_mapping)
| invoke Enrich_Node_Ip_Employee("Name")
| invoke Graph_Fold_By_Property("Domain", "DomainName")
| invoke Graph_Render_View()Process execution graph: User -> Process -> ParentProcess
Input query: Get_Event_Process_All | where ProcessCommandLine has "powershell" | take 300
Graph request: "Visualize process, parent process, host, and user relationships."
let proc_mapping = '{"node_types":[{"type":"Process","id":"Proc","key":"ProcessName","props":["ProcessName","ProcessCommandLine","ProcessHash"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/App-Services.svg"},{"type":"ParentProcess","id":"Proc","key":"ParentProcessName","props":["ParentProcessName","ParentProcessHash"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/App-Services.svg"},{"type":"Host","id":"Host","key":"Hostname","props":["Hostname"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/Virtual-Machine.svg"},{"type":"User","id":"User","key":"Username","props":["Username"],"defaults":{},"defIcon":"https://raw.githubusercontent.com/benc-uk/icon-collection/master/azure-icons/Users.svg"}],"edges":[{"type":"SpawnedBy","source":{"id":"Proc","type":"Process"},"target":{"id":"Proc","type":"ParentProcess"},"props":["EnvTime"]},{"type":"RanOn","source":{"id":"Proc","type":"Process"},"target":{"id":"Host","type":"Host"},"props":["EnvTime"]},{"type":"ExecutedBy","source":{"id":"Proc","type":"Process"},"target":{"id":"User","type":"User"},"props":["EnvTime"]}]}';
Get_Event_Process_All
| where ProcessCommandLine has "powershell"
| take 300
| invoke Lift_To_Graph(proc_mapping)
| invoke Graph_Render_View()Query Results -> Mapping Translation
When the user supplies a query and describes the graph:
- Inspect the query's final output columns
- Parse the entity nouns and relationship verbs
- Generate the mapping JSON using only those columns
- Preserve the supplied pipeline and append
Lift_To_Graph() - Include
Graph_Render_View()at the end - If the user mentions grouping/collapsing and the function exists, add
Graph_Fold_By_Property()
Output the complete KQL -- the supplied query plus mapping JSON inline as a string let binding -- after the required-function preflight passes. Clearly mark unverified function dependencies when the target database cannot be checked.
Opening Queries in Kusto Explorer (Windows Only)
Optional convenience feature. The default workflow is to output the KQL in chat and let the user copy it into Kusto Explorer or the VS Code Kusto extension manually. Auto-launch is opt-in only.
Always output the complete KQL query in the chat response with Step 1 (connect) and Step 2 (query) clearly labeled:
// Step 1: Connect to your cluster (skip if already connected)
// Example: uncomment to connect to the KC7 training cluster
// #connect cluster('kc7001.eastus.kusto.windows.net').database('ValdyTimes')
// Or replace with your own cluster:
// #connect cluster('<YOUR_CLUSTER>').database('<YOUR_DATABASE>')
// Step 2: Run the query below
<KQL_QUERY>If the user asks to save or open in Kusto Explorer, follow the procedure in references/KUSTO_EXPLORER_LAUNCH.md. Key rules:
- Use
ask_userto confirm before writing files or launching executables - Display file contents in chat so the user can review before opening
- Never use shell interpolation or here-strings — write files via
Set-Content/Add-Content - Never encode queries into browser URLs
- On macOS/Linux, save the
.kqlfile and suggest the VS Code Kusto extension or ADX Web Explorer
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

