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.
Install
/plugin marketplace add dstreefkerk/claude-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add dstreefkerk/claude-skills --skill kql-expertgit 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-expertPersonal 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` |
Details
- Skill name
kql-expert- Repository
- dstreefkerk/claude-skills
- 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
5dstreefkerk/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.
Cyber Impact Statement
5dstreefkerk/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.
Powershell
5dstreefkerk/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.
Sentinel Use Case Documentor
5dstreefkerk/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.
Dependabot Remediation
9flurdy/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.
Threat Modeling
5dstreefkerk/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
Browse the most popular Claude skills, all security skills, or write your own with the skills generator.