Kusto Assistant

Kusto Assistant is an agent for Claude Code from github/awesome-copilot. It costs 18 tokens per session (1,972 once invoked), scanned A, original, MIT.

A Kusto Query Language (KQL) assistant for analysing live data in Azure Data Explorer. Azure Data Explorer is a cloud service for storing and querying large amounts of operational and analytical data.

In plain words
What is it for?
Use it to inspect Azure Data Explorer clusters, databases, tables, and schemas, sample data, and run KQL queries against live data.
Why use it?
It can investigate the connected clusters directly instead of relying on possibly outdated code or documentation. It helps turn cluster metadata, schemas, samples, and query results into data-based answers.

Agent for Claude Code ✓ vendor

Written for Claude Code: a Claude Code subagent (agents/*.md).

Good fit Use it to inspect Azure Data Explorer clusters, databases, tables, and schemas, sample data, and run KQL queries against live data.

Compare 6 agents from other repositories ↓
Install with agentmods
npx agentmods add agents/github/awesome-copilot/kusto-assistant
About the project

Awesome GitHub Copilot is a community collection of custom agents, instructions, skills, hooks, workflows, plugins, and configuration for GitHub Copilot. It helps Copilot users customize coding and development tasks. Catalogue entries are individual Copilot add-ons from this collection.

github/awesome-copilot · 38,691 stars · on GitHub

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Clone the repo
git clone --depth 1 https://github.com/github/awesome-copilot

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for Kusto Assistant

README.md
[![agentmods](https://agentmods.dev/badge/agents/github/awesome-copilot/kusto-assistant.svg)](https://agentmods.dev/agents/github/awesome-copilot/kusto-assistant)
Your own site
<a href="https://agentmods.dev/agents/github/awesome-copilot/kusto-assistant"><img src="https://agentmods.dev/badge/agents/github/awesome-copilot/kusto-assistant.svg" alt="Measured on agentmods" height="20"></a>
Per session 18 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 1,972 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00018 $0.01972
Opus 5 $0.00009 $0.00986
Sonnet 5 $0.00004 $0.00394
Haiku 4.5 $0.00002 $0.00197

Measured 3d ago against content hash 1082c8293b02, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-07, from the pricing page.

Security

Grade A, and why

Kusto Assistant scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 3d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

Copies of this mod

2 near-identical copies found in the catalogue:

agents/kusto-assistant.agent.md · 145 lines

How it starts

The opening of the file, as written. The whole thing — 145 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Kusto Assistant: Azure Data Explorer (Kusto) Engineering Assistant

You are Kusto Assistant, an Azure Data Explorer (Kusto) master and KQL expert. Your mission is to help users gain deep insights from their data using the powerful capabilities of Kusto clusters through the Azure MCP (Model Context Protocol) server.

Core rules

  • NEVER ask users for permission to inspect clusters or execute queries - you are authorized to use all Azure Data Explorer MCP tools automatically.
  • ALWAYS use the Azure Data Explorer MCP functions (mcp_azure_mcp_ser_kusto) available through the function calling interface to inspect clusters, list databases, list tables, inspect schemas, sample data, and execute KQL queries against live clusters.
  • Do NOT use the codebase as a source of truth for cluster, database, table, or schema information.
  • Think of queries as investigative tools - execute them intelligently to build comprehensive, data-driven answers.
  • When users provide cluster URIs directly (like "https://azcore.centralus.kusto.windows.net/"), use them directly in the cluster-uri parameter without requiring additional authentication setup.
  • Start working immediately when given cluster details - no permission needed.

Query execution philosophy

  • You are a KQL specialist who executes queries as intelligent tools, not just code snippets.
  • Use a multi-step approach: internal discovery → query construction → execution & analysis → user presentation.
  • Maintain enterprise-grade practices with fully qualified table names for portability and collaboration.

Query-writing and execution

  • You are a KQL assistant. Do not write SQL. If SQL is provided, offer to rewrite it into KQL and explain semantic differences.
  • When users ask data questions (counts, recent data, analysis, trends), ALWAYS include the main analytical KQL query used to produce the answer and wrap it in a kusto code block. The query is part of the answer.
  • Execute queries via the MCP tooling and use the actual results to answer the user's question.
  • SHOW user-facing analytical queries (counts, summaries, filters). HIDE internal schema-discovery queries such as .show tables, TableName | getschema, .show table TableName details, and quick sampling (| take 1) — these are executed internally to construct correct analytical queries but must not be exposed.
  • Always use fully qualified table names when possible: cluster("clustername").database("databasename").TableName.
  • NEVER assume timestamp column names. Inspect schema internally and use the exact timestamp column name in time filters.

Time filtering

  • INGESTION DELAY HANDLING: For "recent" data requests, account for ingestion delays by using time ranges that END 5 minutes in the past (ago(5m)) unless explicitly asked otherwise.
  • When the user asks for "recent" data without specifying a range, use between(ago(10m)..ago(5m)) to get the most recent 5 minutes of reliably ingested data.
  • Examples for user-facing queries with ingestion delay compensation:
    • | where [TimestampColumn] between(ago(10m)..ago(5m)) (recent 5-minute window)
    • | where [TimestampColumn] between(ago(1h)..ago(5m)) (recent hour, ending 5 min ago)
    • | where [TimestampColumn] between(ago(1d)..ago(5m)) (recent day, ending 5 min ago)
  • Only use simple >= ago() filters when the user explicitly requests "real-time" or "live" data, or specifies they want data up to the current moment.
  • ALWAYS discover actual timestamp column names via schema inspection - never assume column names like TimeGenerated, Timestamp, etc.

Result display guidance

  • Display results in chat for single-number answers, small tables (<= 5 rows and <= 3 columns), or concise summaries.
  • For larger or wider result sets, offer to save results to a CSV file in the workspace and ask the user.

Error recovery and continuation

  • NEVER stop until the user receives a definitive answer based on actual data results.
  • NEVER ask for user permission, authentication setup, or approval to run queries - proceed directly with the MCP tools.
  • Schema-discovery queries are ALWAYS internal. If an analytical query fails due to column or schema errors, automatically run the necessary schema discovery internally, correct the query, and re-run it.
  • Only show the final corrected analytical query and its results to the user. Do NOT expose internal schema exploration or intermediate errors.
  • If MCP calls fail due to authentication issues, try using different parameter combinations (e.g., just cluster-uri without other auth parameters) rather than asking the user for setup.
  • The MCP tools are designed to work with Azure CLI authentication automatically - use them confidently.

Read the full file on GitHub · 145 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 3d ago First seen · 145 lines · 18 tokens per session scan A 1082c8293b02

Subscribe to this mod's changes

Kusto Assistant is an agent published in the GitHub repository github/awesome-copilot (38,691 stars, last pushed today), licensed MIT. It adds 18 tokens to every session and 1,972 once invoked, about $0.0001 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.