# Kql

> Kql is an open-source agent skill for knowledge and memory. KQL language expertise for writing correct, efficient Kusto Query Language queries. It is available on Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose.

- **Kind:** Skill
- **Pricing:** Open source
- **Platforms:** Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- **Website:** https://github.com/microsoft/skills/tree/main/.github/skills/kql
- **Repository:** https://github.com/microsoft/skills
- **GitHub stars:** 3,214
- **License:** MIT
- **Skill name:** kql
- **Collection:** https://github.com/microsoft/skills
- **Categories:** knowledge and memory
- **Listing updated:** 2026-11-17

## About

KQL language expertise for writing correct, efficient Kusto Query Language queries. Covers syntax gotchas, join patterns, dynamic types, datetime pitfalls, regex patterns, serialization, memory management, result-size discipline, and advanced functions (geo, vector, graph). USE THIS SKILL whenever writing, debugging, or reviewing KQL queries — even simple ones — because the gotchas section prevents the most common errors that waste tool calls and cause expensive retry cascades. Trigger on: KQL, Kusto, ADX, Azure Data Explorer, Fabric Real-Time Intelligence, EventHouse, Log Analytics, log analysis, data exploration, time series, anomaly detection, summarize, where clause, join, extend, project, let statement, parse operator, extract function, any mention of pipe-forward query syntax.

## When your agent uses it

> KQL language expertise for writing correct, efficient Kusto Query Language queries. Covers syntax gotchas, join patterns, dynamic types, datetime pitfalls, regex patterns, serialization, memory management, result-size discipline, and advanced functions (geo, vector, graph). USE THIS SKILL whenever writing, debugging, or reviewing KQL queries — even simple ones — because the gotchas section prevents the most common errors that waste tool calls and cause expensive retry cascades. Trigger on: KQL, Kusto, ADX, Azure Data Explorer, Fabric Real-Time Intelligence, EventHouse, Log Analytics, log analysis, data exploration, time series, anomaly detection, summarize, where clause, join, extend, project, let statement, parse operator, extract function, any mention of pipe-forward query syntax.

## What it can access

From a static check of the files on GitHub; nothing was run.

- [Instructions only, no scripts](https://github.com/microsoft/skills/tree/HEAD/.github/skills/kql)
- [License: MIT](https://github.com/microsoft/skills/tree/HEAD/.github/skills/kql)

## Install

### Claude Code

Copy the skill folder to `~/.claude/skills/kql` to use it in all your projects:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/microsoft/skills.git "$tmp" &&
mkdir -p ~/.claude/skills &&
rm -rf ~/.claude/skills/kql &&
cp -R "$tmp/.github/skills/kql" ~/.claude/skills/kql &&
rm -rf "$tmp"
```

For one project only, put the folder in `.claude/skills/kql` inside it instead.

### Codex

Copy the skill folder to `~/.agents/skills/kql` to use it in every repository:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/microsoft/skills.git "$tmp" &&
mkdir -p ~/.agents/skills &&
rm -rf ~/.agents/skills/kql &&
cp -R "$tmp/.github/skills/kql" ~/.agents/skills/kql &&
rm -rf "$tmp"
```

For one repository only, put the folder in `.agents/skills/kql` inside it instead.

### Cursor

Copy the skill folder to `~/.cursor/skills/kql` to use it in every project:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/microsoft/skills.git "$tmp" &&
mkdir -p ~/.cursor/skills &&
rm -rf ~/.cursor/skills/kql &&
cp -R "$tmp/.github/skills/kql" ~/.cursor/skills/kql &&
rm -rf "$tmp"
```

For one project only, put the folder in `.cursor/skills/kql` inside it instead.

### Gemini CLI

Run in a terminal (add `--scope workspace` to install it for the current workspace only):

```sh
gemini skills install https://github.com/microsoft/skills.git --path .github/skills/kql
```

Or copy the folder to `~/.gemini/skills/kql` yourself.

### VS Code

For GitHub Copilot in VS Code, copy the skill folder to `~/.copilot/skills/kql`:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/microsoft/skills.git "$tmp" &&
mkdir -p ~/.copilot/skills &&
rm -rf ~/.copilot/skills/kql &&
cp -R "$tmp/.github/skills/kql" ~/.copilot/skills/kql &&
rm -rf "$tmp"
```

For one project only, put the folder in `.github/skills/kql` inside it instead.

### Other agents

Get the folder:

```sh
git clone --depth 1 https://github.com/microsoft/skills.git
```

Then copy `skills/.github/skills/kql` into your agent's skills folder as `kql`. Agents that support SKILL.md read one folder per skill.

## FAQ

### How do I install Kql in Claude Code?

Copy the skill folder from GitHub to ~/.claude/skills/kql to use it in all your projects, or to .claude/skills/kql in one project.

### Does Kql run scripts?

No. It is instructions only, with no scripts. This comes from a static check of the files on GitHub; nothing was run. Read the files before you install it.

### Which AI agents can use Kql?

Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose. Each reads skills in the SKILL.md format from its own folder; the install steps on this page list them.

### What are the best alternatives to Kql?

The closest alternatives to Kql are Claude API, Qdrant horizontal scaling, Qdrant search quality diagnosis, Pinecone rag and Embedding anisotropy check.

## Alternatives

- [Claude API](https://ai-powered.com/skills/claude-api): Claude API is an agent skill for ai models and llm tooling.
- [Qdrant horizontal scaling](https://ai-powered.com/skills/qdrant-horizontal-scaling): Qdrant horizontal scaling is an open-source agent skill for knowledge and memory.
- [Qdrant search quality diagnosis](https://ai-powered.com/skills/qdrant-search-quality-diagnosis): Qdrant search quality diagnosis is an open-source agent skill for knowledge and memory.
- [Pinecone rag](https://ai-powered.com/skills/pinecone-rag): Pinecone rag is an open-source agent skill for knowledge and memory.
- [Embedding anisotropy check](https://ai-powered.com/skills/embedding-anisotropy-check): Embedding anisotropy check is an open-source agent skill for knowledge and memory.
- [Qdrant memory usage optimization](https://ai-powered.com/skills/qdrant-memory-usage-optimization): Qdrant memory usage optimization is an open-source agent skill for knowledge and memory.
- [Qdrant vertical scaling](https://ai-powered.com/skills/qdrant-vertical-scaling): Qdrant vertical scaling is an open-source agent skill for knowledge and memory.
- [Qdrant minimize latency](https://ai-powered.com/skills/qdrant-minimize-latency): Qdrant minimize latency is an open-source agent skill for knowledge and memory.

---
Source: https://ai-powered.com/skills/kql
