Kql Grounded Queries

Use whenever the user asks for a KQL query for Microsoft Sentinel, Log Analytics or Defender XDR Advanced Hunting — writing one, fixing one, modifying one, or explaining one — including requests that never say "KQL" (for example "query SigninLogs", "hunt for phishing URLs in Defender", "write a Sentinel detection"). Verify every table and column BEFORE composing any query — against Microsoft documentation, or against the tenant's own schema where the table is custom and Microsoft does not document it.

110 stars 122 forksWriting & ContentOfficial

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add microsoft/cat-agent-skills --skill kql-grounded-queries
Manual install
git clone --depth 1 https://github.com/microsoft/cat-agent-skills.git /tmp/cat-agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/cat-agent-skills/submissions/kql-grounded-queries ~/.claude/skills/kql-grounded-queries

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

From the SKILL.md

Never emit a table or column name you have not verified in this session. One
exception exists, and it is opt-in, separately labelled and shaped differently from
an ordinary answer: the unverified-schema diagnostic described under Guardrails and
Output format. It is never produced unless the user asks for it by name. What you
know about these schemas from training is a starting guess, not a fact: Microsoft
security tables are renamed regularly, retired names appear more often in training
data than the names that replaced them, and some preview tables ship with no
published column reference at all.

## Instructions

1. **Confirm the surface.** Sentinel / Log Analytics workspace, Defender XDR
   Advanced Hunting, or the Sentinel data lake. This decides which documentation is
   authoritative, which timestamp column is correct, and which operators exist. If
   the user did not say, state the assumption you are making.

2. **Keep candidate table names inside the tenant until their public status is
   established.** Read the surface's index first — that sends nothing of the
   user's — and check every candidate against it. Presence in the index is the
   whole test, and it is the only one.

   A table the index lists is **published**. It goes out to its reference page and
   into searches normally, and it makes no difference whether you proposed the name
   or the user did: `SigninLogs` is `SigninLogs` either way, and asking someone for
Read the full skill on GitHub

Details

Skill name
kql-grounded-queries
Path
submissions/kql-grounded-queries/SKILL.md
License
MIT
Repo updated
15 November 2026

FAQ

What does the Kql Grounded Queries skill do?

Use whenever the user asks for a KQL query for Microsoft Sentinel, Log Analytics or Defender XDR Advanced Hunting — writing one, fixing one, modifying one, or explaining one — including requests that never say "KQL" (for example "query SigninLogs", "hunt for phishing URLs in Defender", "write a Sentinel detection"). Verify every table and column BEFORE composing any query — against Microsoft documentation, or against the tenant's own schema where the table is custom and Microsoft does not document it.

How do I install the Kql Grounded Queries skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add microsoft/cat-agent-skills --skill kql-grounded-queries. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Kql Grounded Queries popular?

It lives in microsoft/cat-agent-skills, which has 110 GitHub stars and 122 forks.

Related skills

3 Statements

110

microsoft/cat-agent-skills

Completes existing income statement, balance sheet and cash flow templates while preserving layout, grounding historical inputs and linking forecast formulas with reconciliation checks. Use for "fill in a 3-statement template", "complete an IS/BS/CF framework", "populate my integrated financial model", "link statements in this template", or "finish the forecasts in my three-statement workbook". Do NOT use for blank-slate models or general workbook edits (use xlsx), DCF valuation (use dcf-valuation), or buyout modeling (use lbo-model).

AI, LLMs & Agents122

Accessibility Pass

110

microsoft/cat-agent-skills

Use this skill whenever the user asks to check, review, or fix the accessibility of a PowerPoint deck, Word document, HTML page, or Markdown file, and before handing over any deck or document this agent just generated, so it does not ship with missing alt text, untitled slides, or unreadable colour contrast.

Frontend & Design122

Accessible Learning Materials

110

microsoft/cat-agent-skills

Maintains instructionally equivalent, accessible variants of a set of learning materials — lessons, readings, slides, and handouts — with parity checks against the original learning goals and recorded approvals. Use when the user asks to "make these materials accessible", "audit this lesson set for accessibility", "create an accessible version of this reading", "check reading level and alt text", or "keep my accessible variants in sync". Do NOT use for individual student accommodation or support-plan decisions (IEP, EHCP, or local equivalent), and do NOT use for generic document formatting (us

Learning & Education122

Linkedin Content System

110

microsoft/cat-agent-skills

Use this skill when the user asks to create LinkedIn posts, promotional posts, thought-leadership posts, newsletter introductions, article intros, or long-form LinkedIn content from source notes, facts, or drafts.

Writing & Content122

Knowledge Source Router

110

microsoft/cat-agent-skills

Required whenever a knowledge request names or implies a country, asks what applies "here," or compares countries. Treat Country as document metadata, not as a content-search term. Before any content search, general-knowledge answer, or clarification, use sharepoint_metadata_filter to discover and filter the Country column. Then pass every matching document URL to knowledge_search_sharepoint through scopeUrls.

Writing & Content122

Linkedin Content Writer

110

microsoft/cat-agent-skills

Create, polish, rewrite, review, repurpose, brainstorm, or configure evidence-led LinkedIn posts, captions, comments, hooks, ideas, and conversation-scoped writing profiles from facts, notes, drafts, research, announcements, or lived experience. Use for the initial LinkedIn request and every follow-up clarification, revision, correction, constraint, or preference in the active task.

Writing & Content122

Browse the most popular Claude skills, all writing & content skills, or write your own with the skills generator.