skills.rest
p-potvin
p-potvinCOMMUNITY
Explore all skills by this author →
GitHub

azure-kusto

Execute KQL queries and inspect schemas in Azure Data Explorer.

1|Updated Apr 4, 2026
Search Tags:#time series#telemetry#log analytics#kql#kusto#azure data explorer
One-click install
npx skills add https://github.com/p-potvin/vaultwares-pipelines --skill azure-kusto-p-potvin
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: azure-kusto
Source: https://github.com/p-potvin/vaultwares-pipelines/tree/main/.github/agents/agents/azure-kusto
Command: npx skills add https://github.com/p-potvin/vaultwares-pipelines --skill azure-kusto-p-potvin

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes friction from exploring and analyzing large-scale telemetry, log, and time series data stored in Azure Data Explorer by providing guided KQL query execution, schema discovery, and resource listing so analysts and engineers can get answers quickly.

Core Features & Use Cases

  • KQL Query Execution: Run ad-hoc and analytic Kusto Query Language statements against ADX databases to filter, aggregate, and visualize results.
  • Schema & Resource Discovery: List clusters, enumerate databases, and retrieve table schemas to inform query building and data modeling.
  • Time Series & Telemetry Analysis: Perform windowed aggregations, percentiles, and anomaly checks for IoT and APM telemetry use cases.
  • Fallback & Diagnostics: Use Azure CLI or REST endpoints for diagnostics and long-running query fallbacks when direct tools fail.

Quick Start

Ask the skill to "Run a KQL query on cluster mycluster and database mydb to count Error events in the last 1 hour grouped by EventType".

Frequently Asked Questions about azure-kusto

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run KQL queries on Azure Data Explorer to analyze telemetry data?▼

Run KQL queries on Azure Data Explorer by executing ad-hoc Kusto Query Language statements against ADX databases to filter, aggregate, and visualize large-scale telemetry and log data. The Skill uses authenticated Azure access to process the requests.

What is the best way to inspect table schemas and list databases in ADX?▼

Inspect table schemas and list databases in ADX using guided schema and resource discovery features. Enumerate clusters, list databases, and retrieve table schemas to inform query building and data modeling.

Can I perform time series aggregation and anomaly detection in Azure Data Explorer?▼

Perform time series aggregation and anomaly detection in Azure Data Explorer by running windowed aggregations, percentiles, and anomaly checks. This supports IoT and APM telemetry analysis use cases directly through KQL.

Does this approach work when direct KQL execution tools fail or time out?▼

When direct KQL execution tools fail or time out, this approach works by falling back to Azure CLI or REST endpoints for diagnostics and long-running query fallbacks, ensuring you can still retrieve ADX results.

Do I need authenticated Azure access to execute KQL statements on ADX clusters?▼

Authenticated Azure access is required to execute KQL statements on ADX clusters. It allows the Skill to securely connect, list clusters, enumerate databases, inspect table schemas, and run telemetry queries.

Related Skills

Explore More Data & Analytics Skills→
qprjack86qprjack86

azure-kusto

Query and analyze Azure Data Explorer data using KQL.

Community
Advanced
microsoftmicrosoft
242

azure-kusto

Run KQL queries and analyze data in Azure Data Explorer.

Official
Advanced
jongiojongio
6

azure-kusto

Query and analyze Azure Data Explorer data using KQL.

Community
Intermediate
mahmoud20138mahmoud20138
10

azure-kusto

Query and analyze Azure Data Explorer data with KQL.

Community
Intermediate