Kustory

A Visual Studio Code extension for executing Kusto (KQL) queries with Azure Data Explorer integration.

Features

KQL Syntax Highlighting - Full syntax highlighting for .kql, .kustory, and .csl files
Connection Management - Manage multiple Azure Data Explorer cluster connections
Azure AD Authentication - Interactive browser login and Azure CLI authentication support
Inline Query Execution - Run queries directly from the editor with CodeLens buttons
Results Visualization - Rich results panel with table view, pagination, and time-series charts
Database Explorer - Browse databases, tables, and columns in the sidebar
Query History - Track and re-run recent queries
Intellisense - Schema-aware autocomplete for tables, columns, and KQL operators
Query Formatting - Auto-format KQL queries for improved readability
Load Query from Link - Import queries from Azure Data Explorer share links or Kusto Explorer clipboard

Kustory supports three authentication methods:

VSCode Account (Recommended) - Uses your signed-in Microsoft account in VSCode
Interactive Browser - Opens a browser window for Azure AD authentication with persistent session
Azure CLI - Uses credentials from an existing az login session (falls back to interactive browser if CLI unavailable)

Use the "Load Query" command to import queries from Azure Data Explorer. Supports two input formats:

Direct URL:

https://dataexplorer.azure.com/clusters/mycluster.westus2/databases/MyDB?query=H4sI...

Kusto Explorer clipboard format (URL on first line, empty line, then query):

https://dataexplorer.azure.com/clusters/mycluster.westus2/databases/MyDB?query=H4sI...

// My query
MyTable
| where Timestamp > ago(1h)

The command automatically creates or reuses a connection for the cluster and saves the query as a snippet.

MIT