AI agents for Databricks SQL

Run a SQL query

Runs one read-only Databricks SQL statement (SELECT, SHOW, DESCRIBE or EXPLAIN; one statement, no semicolons inside) on the warehouse and waits up to wait_seconds for it.

List tables

Lists the tables and views in a catalog (optionally one schema of it) from Unity Catalog's system.information_schema, up to 500.

Describe a table

Lists a table's columns in order from system.information_schema: each column's name, full data type, whether it can be null, its default and its comment.

Get a statement's status and results

Checks a statement by its statement_id: status.state.

Get more result rows

Reads one more chunk of a finished statement's rows, by statement_id and the chunk index from result.next_chunk_index (chunk 0 came with the statement).

List SQL warehouses

Lists the SQL warehouses the token's user can use, as warehouses.

Insert, update or create

Runs one statement that adds or changes data: INSERT INTO (not INSERT OVERWRITE or REPLACE WHERE / REPLACE USING), UPDATE, or CREATE (not CREATE OR REPLACE): a table, view, schema or function.

Run any SQL statementDeletes data

Runs any one Databricks SQL statement the token's user may run, including MERGE, DELETE, DROP, TRUNCATE, ALTER, INSERT OVERWRITE, INSERT ...

Cancel a running statement

Asks Databricks to cancel a statement that is still running, by its statement_id.