Kql Expert

KQL expert for Microsoft Sentinel, Azure Monitor, and M365 Defender. Use proactively when the user works with any .kql file, writes or reviews KQL queries, develops analytics or detection rules, performs threat hunting, needs DCR transformation KQL, or asks to optimise, validate, or convert a KQL query. Covers query optimisation, schema validation, ASIM normalisation, SPL migration, and best practices.

5 starsSecurity Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add dstreefkerk/claude-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add dstreefkerk/claude-skills --skill kql-expert
Manual install
git clone --depth 1 https://github.com/dstreefkerk/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/plugins/sentinel/skills/kql-expert ~/.claude/skills/kql-expert

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# KQL Expert - Microsoft Sentinel & Azure Monitor Query Specialist

Expert guidance for Kusto Query Language (KQL) covering query optimization, schema validation against M365/Sentinel tables, analytics rule development, ASIM normalization, threat hunting, and SPL migration.

## Capabilities

- **Schema Validation**: Validate queries against M365 Defender and Sentinel table schemas via `schema_validator.py`
- **Query Optimization**: Analyze and optimize queries following filter-early principles and term indexing
- **Analytics Rules**: Develop scheduled/NRT rules with entity mapping, MITRE ATT&CK tags, watchlist integration
- **ASIM Normalization**: Source-agnostic detection using unifying parsers with filtering parameters
- **SPL Migration**: Convert Splunk queries to KQL with proper command mapping
- **Threat Hunting**: Create hypothesis-driven hunting queries with anomaly detection
- **False Positive Tuning**: Reduce alert fatigue via watchlists and automation rules
- **Cost Optimization**: Table plan selection, DCR transformations, commitment tiers

## Proactive Usage

**INVOKE THIS SKILL IMMEDIATELY when any of these conditions are met:**

### Primary Triggers (Invoke First)
| Condition | User Phrasing Examples |
|-----------|------------------------|
| **`.kql` file extension** | "Check @file.kql", "Review this .kql", "Look at @Detection.kql" |
| **KQL operators in content** | File contains `| where`, `| extend`, `| summarize`, `| join` |
Read the full skill on GitHub

Details

Skill name
kql-expert
Path
plugins/sentinel/skills/kql-expert/SKILL.md
License
MIT
Repo updated
17 September 2026

FAQ

What does the Kql Expert skill do?

KQL expert for Microsoft Sentinel, Azure Monitor, and M365 Defender. Use proactively when the user works with any .kql file, writes or reviews KQL queries, develops analytics or detection rules, performs threat hunting, needs DCR transformation KQL, or asks to optimise, validate, or convert a KQL query. Covers query optimisation, schema validation, ASIM normalisation, SPL migration, and best practices.

How do I install the Kql Expert skill?

Claude Code plugin: /plugin marketplace add dstreefkerk/claude-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Kql Expert popular?

It lives in dstreefkerk/claude-skills, which has 5 GitHub stars and 0 forks.

Related skills

Codeless Connectors

5

dstreefkerk/claude-skills

Use before writing any Microsoft Sentinel connector ARM template, DCR, KQL transform, or createUiDefinition.json. Provides the complete CCF (Codeless Connector Framework) reference for RestApiPoller, Push, and GCP connector types — including escaping rules, authentication, pagination, UI definitions, and deployment gotchas. Also use when debugging connector deployment failures or reviewing existing CCP templates.

Software Development

Cyber Impact Statement

5

dstreefkerk/claude-skills

Generates concise, CISO-level impact statements for security control failures. Use when the user asks for an impact statement, wants to explain the business consequences of a security control failure, needs to document risk for a risk register or audit finding, or wants to translate a technical vulnerability into executive language for a CISO or board.

Security

Powershell

5

dstreefkerk/claude-skills

Enterprise PowerShell coding standards. Use when writing, reviewing, or generating any PowerShell code, creating PS1 scripts or functions, debugging PowerShell, or asked to help with PowerShell. Enforces best practices for structure, error handling, security, performance, and output patterns.

Software Development

Sentinel Use Case Documentor

5

dstreefkerk/claude-skills

Documents Microsoft Sentinel analytics rules as comprehensive SOC use cases. Use when the user wants to document a Sentinel rule, create SOC documentation, generate use case docs from an ARM template, or document a KQL detection query.

Security

Dependabot Remediation

9

flurdy/agent-skills

Plan Dependabot security remediation for one repository into a few beads (a bead per urgent fix, small compatible batches, one dated follow-up), then fix one selected bead with native verification, one confirmed push and observed alert state.

Security

Threat Modeling

5

dstreefkerk/claude-skills

Design-time threat-modelling reference based on Shostack (Wiley 2014), extended for AI/ML (ATLAS, OWASP LLM/ASI Top 10, NIST AI RMF, EU AI Act, prompt injection), cloud-native (ATT&CK Cloud/Containers, Kubernetes, SLSA, Sigstore, IAM), CI/CD supply chain (OWASP CI/CD Top 10, SSDF, Scorecard, SolarWinds/XZ/tj-actions patterns), API security (OWASP API Top 10, OAuth/JWT BCPs, GraphQL, BOLA/BFLA, webhooks), sprint-pace TM (Manifesto, SAMM, BSIMM, SDL, continuous-TM), Australian regulated industry (Privacy Act 2024 amendments, APRA CPS 234/230, AUSTRAC, OAIC PIA, AI Safety Standard), OT/ICS (IEC 6

Security

Browse the most popular Claude skills, all security skills, or write your own with the skills generator.