execute_sql
Execute SQL
Execute a SQL statement on a SQL warehouse and return the results. Supports catalog and schema context, and can wait for completion or return a statement ID for asynchronous polling.
execute_sql
Execute a SQL statement on a SQL warehouse and return the results. Supports catalog and schema context, and can wait for completion or return a statement ID for asynchronous polling.
list_experiments
List MLflow experiments in the workspace. Experiments are containers for organizing ML runs.
manage_secrets
Manage secret scopes and secrets. Create/delete scopes, put/delete secrets, or list scopes and secret keys. Secret values cannot be read back — only metadata is returned.
list_pipelines
List Delta Live Tables pipelines in the workspace. Optionally filter by name or other criteria.
get_job_run
Retrieve details and status of a specific job run, including task states, timing, and output. Can also list recent runs for a given job.
manage_job
Create, update, or delete a multi-task workflow job. Supports notebook, Python, and SQL task types with dependencies, scheduling, and notification settings.
browse_workspace
List notebooks, folders, and other objects in a workspace directory. Can also get the status (metadata) of a specific workspace object.
list_warehouses
List all SQL warehouses in the workspace with their status and configuration.
manage_warehouse
Create, start, stop, or delete a SQL warehouse. SQL warehouses are compute resources for running SQL queries in Databricks SQL.
browse_catalog
Navigate the Unity Catalog hierarchy: list catalogs, schemas within a catalog, tables within a schema, or get details of a specific table. Provides governance metadata including owners, comments, and data types.
manage_pipeline
Create, start, stop, or delete Delta Live Tables pipelines. Pipelines define declarative data transformations as directed acyclic graphs.
search_runs
Search for MLflow runs across one or more experiments. Filter by metrics, parameters, and tags using the MLflow search syntax. Returns run metadata, metrics, and parameters.
manage_cluster
Create, edit, start, restart, stop, or permanently delete an Apache Spark cluster. To **create** a new cluster, omit `clusterId` and provide `clusterName`, `sparkVersion`, and `nodeTypeId`. To **edit** an existing cluster, provide `clusterId` along with the fields to update. To **start/restart/stop/delete**, provide `clusterId` and the corresponding `action`.
manage_dbfs
Interact with the Databricks File System (DBFS). List, read, upload, create directories, and delete files or folders.
list_jobs
List jobs defined in the workspace. Optionally filter by name and expand task details.
manage_notebook
Import, export, or delete notebooks and create workspace directories. Use **import** to upload notebook content (base64-encoded). Use **export** to download a notebook as a Slate attachment. Use **delete** to remove a notebook or folder.
query_serving_endpoint
Send an inference request to a model serving endpoint. Works with both custom ML models and Foundation Model APIs. The request format follows OpenAI-compatible chat/completions or generic model input schemas.
run_job
Trigger an immediate run of an existing job, optionally with override parameters. Also supports cancelling a running job run.
list_clusters
List all available Apache Spark clusters in the workspace. Returns cluster details including state, configuration, and scaling settings.
list_serving_endpoints
List all model serving endpoints in the workspace. Serving endpoints host ML models and foundation models as REST APIs.
manage_files
Manage files and directories with the current Databricks Files API for workspace files and Unity Catalog Volumes. Supports listing directories, creating and deleting directories, uploading files, downloading files as Slate attachments, and deleting files.
manage_vector_search
Manage and query Databricks Vector Search endpoints and indexes. Supports listing, getting, creating, and deleting endpoints; listing and getting indexes; deleting indexes; and querying an index with text or vector input.
Manage Databricks workspaces, clusters, jobs, and data assets. Create, start, stop, and configure Apache Spark clusters. Orchestrate multi-task workflows and data pipelines with scheduled or triggered jobs. Execute SQL statements on SQL warehouses. Manage Unity Catalog resources including catalogs, schemas, tables, and volumes for data governance. Track ML experiments, manage model registry, and deploy model serving endpoints. Create and manage vector search indexes. Import, export, and organize notebooks and workspace files. Upload and download files via DBFS and Unity Catalog Volumes. Manage users, groups, service principals, and permissions. Create and publish Lakeview dashboards. Share data across organizations with Delta Sharing. Store and manage secrets for secure credential access. Receive webhook notifications for model registry events and job lifecycle events.
Common questions about connecting Databricks to AI agents with Metorial.