kli — Interactive KQL Shell for Azure Data Explorer

kli is a terminal REPL for querying Azure Data Explorer clusters using KQL (Kusto Query Language). It provides syntax highlighting, schema-aware autocomplete, and multi-cluster profile management — all from your terminal.

Prerequisites

• .NET 8 SDK or newer

Installation

dotnet tool install -g kli

Update

dotnet tool update -g kli

Uninstall

dotnet tool uninstall -g kli

Quick Start

1. Add a cluster profile:

   kli config add-cluster my-cluster https://<your-cluster>.kusto.windows.net --database <database>

2. Activate the profile:

   kli config use my-cluster

3. Start the REPL:

   kli

4. Run a query:

   MyTable | take 10

Configuration Commands

Command	Description
kli config add-cluster <name> <url> --database <db>	Add a new cluster profile
kli config use <name>	Switch to a cluster profile
kli config set-database <database>	Change the active database
kli config list	List all configured profiles
kli config remove <name>	Remove a cluster profile

Authentication

kli uses Azure.Identity and authenticates via your local Azure credentials. Make sure you are logged in:

az login

License

MIT