Azure Data Explorer integration for AI agents
Query and manage Azure Data Explorer (Kusto) clusters with KQL
Azure Data Explorer is a Sim integration in the Databases category. Sim is the AI workspace where teams build and deploy AI agents. Sim's Azure Data Explorer integration provides 14 tools that AI agents can use inside Sim's visual workflow builder. Azure Data Explorer connects with an API key. Free to start at sim.ai.
Last updated
What Sim agents can do with Azure Data Explorer
Run Kusto Query Language queries against Azure Data Explorer and Fabric Eventhouse clusters, discover databases, tables, and schemas, push small batches of rows inline, and run management commands. Authenticates with a Microsoft Entra service principal using client credentials, so no interactive sign-in is needed.
- Category
- Databases
- Authentication
- API key
- Tools
- 14
- Triggers
- 0
- Documentation
- Azure Data Explorer docs
How to automate Azure Data Explorer with Sim
Create a free account
Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.
Add an Azure Data Explorer block
Open your workspace, drag an Azure Data Explorer block onto the workflow builder, and paste in your Azure Data Explorer API key.
Configure, connect, and run
Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your Azure Data Explorer automation is live.
Agent templates
Ready-to-use templates featuring Azure Data Explorer. Click any to build it instantly.
Azure Data Explorer tools
14 Azure Data Explorer tools available to Sim agents.
Run Query
Run a Kusto Query Language (KQL) query against an Azure Data Explorer database and return the primary result table.
List Databases
List the databases on an Azure Data Explorer cluster that the service principal can access.
List Tables
List the tables in an Azure Data Explorer database, with their folder and docstring.
Show Table Schema
Read the column schema of an Azure Data Explorer table in CSL form (e.g., "Timestamp:datetime,Level:string"). Use this before writing a KQL query against an unfamiliar table.
Show Database Schema
Read the full schema of an Azure Data Explorer database as a flat list of every table and column, so an agent can discover the data model in one call.
Show Table Details
Read size, row count, hot-cache footprint, and effective policies for a table — or for every table in the database when no table is given. Use it to see how much data a table actually holds before querying it.
List Functions
List the stored functions in an Azure Data Explorer database, with their parameters and bodies, so an agent can reuse existing logic instead of rewriting it.
Ingest Rows Inline
Push rows directly into an Azure Data Explorer table with .ingest inline. Data is parsed as CSV against the table schema unless an ingestion property says otherwise. Intended for small batches — use queued or streaming ingestion for production volumes.
Ingest From Query
Materialize the result of a KQL query into a table with .set, .append, .set-or-append, or .set-or-replace. Use this to build rollup or summary tables instead of pushing rows from a workflow. Kusto matches the query result to the target table by column type and position, NOT by column name, so project the columns in exactly the table's order or the data lands in the wrong columns.
Create Table
Create a table in an Azure Data Explorer database from a CSL column schema. Succeeds without changing anything if a table of the same name already exists.
Drop Table
Drop a table from an Azure Data Explorer database. The table becomes unavailable to queries; data recovery depends on the retention policy. Returns the tables that remain.
Show Ingestion Failures
List ingestion failures recorded for a database, with the failing table, error code, root cause detail, and whether the failure is permanent or transient. Failures are retained for 14 days.
Show Operations
Check the state of administrative operations on a cluster, such as an async ingestion. Given an operation ID it returns that operation latest update; with no ID it returns the operations from the last two weeks.
Management Command (advanced)
Run an Azure Data Explorer management command (a control command starting with ".") such as .show, .create, .alter, or .drop. Write commands can change data or configuration; use the Query operation for reads.
Frequently asked questions
Sim's Azure Data Explorer integration adds 14 tools to the AI agents you build in Sim's visual workflow builder. Query and manage Azure Data Explorer (Kusto) clusters with KQL.
