What permissions are required to use this skill?

Users must have appropriate Azure RBAC roles, typically starting with 'Database Viewer' permissions, to execute queries against the target Kusto cluster.

Can I use this for Azure SQL or PostgreSQL databases?

No, this skill is specifically for Azure Data Explorer (Kusto). For relational databases, you should use specialized skills like azure-postgres.

How does the skill handle large result sets?

The skill follows best practices by encouraging the use of 'take' or 'limit' operators and 'summarize' for aggregations to ensure performance and prevent timeouts.

What happens if the primary query tools fail?

The skill includes a robust fallback strategy using Azure CLI commands (az kusto or az rest) to ensure continuous operation if standard tools are unavailable.

What query language does this skill use?

This skill exclusively uses Kusto Query Language (KQL), which is optimized for querying large-scale telemetry, logs, and time series data.

Azure Data Explorer (Kusto)

Name: Azure Data Explorer (Kusto)
Author: microsoft

bymicrosoft

•

109

•

Analytics & Monitoring

Queries and analyzes big data in Azure Data Explorer using Kusto Query Language (KQL) for logs, telemetry, and time series insights.

This skill empowers Claude to interact directly with Azure Data Explorer (ADX) clusters and databases to perform high-performance analytics on massive datasets. It enables users to discover database schemas, execute complex KQL queries, and analyze results for logs, IoT telemetry, and security events. By bridging the gap between natural language and Kusto Query Language, it facilitates real-time monitoring, rapid troubleshooting, and advanced anomaly detection within the Azure ecosystem.

Key Features

01109 GitHub stars

02Analyze logs and telemetry data with built-in KQL best practices

03Execute high-performance KQL queries on billions of records

04Perform advanced time series analysis and anomaly detection

05Discover cluster schemas and database table structures

06Manage and list ADX clusters and databases across subscriptions

Use Cases

01Monitoring IoT device telemetry to identify trends and detect anomalies

02Troubleshooting application performance by analyzing real-time error logs and traces

03Correlating security events across multiple datasets for rapid root cause analysis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microsoft/github-copilot-for-azure azure-kusto

For use in Claude.ai and ChatGPT

Download Skill