Skip to main content
Feedback

Databricks MCP connector

Databricks is a unified data and AI platform that provides compute infrastructure, job orchestration, and Unity Catalog governance for data teams. The Databricks MCP connector allows AI agents to manage clusters, cluster policies, and node types, as well as monitor and control job execution across a workspace. It also supports retrieving available runtime versions and workspace configurations, giving agents broad visibility into compute resources and governance settings.

Authentication type

  • OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.

Uses

Use the Databricks MCP connector to perform the following actions:

  • Launch and monitor Databricks clusters across running, pending, and terminated states
  • Schedule and trigger data pipeline jobs without manual intervention
  • Enforce cost and security controls through custom cluster policies
  • Automate job run tracking, cancellation, and history cleanup
  • Standardize cluster environments with instance pools and instance profiles
  • Deploy global init scripts to configure clusters at startup
  • Audit library installations across every cluster in the workspace
  • Select optimal runtime versions and node types for new clusters

Example prompts

Use the following example prompts to invoke Databricks MCP connector tools from your AI assistant or Boomi Connect workflow:

  • Show me every cluster running in our Databricks workspace right now.
  • Kick off a run of our nightly ETL job in Databricks.
  • What jobs failed in Databricks over the last 24 hours?
  • Create a new cluster policy in Databricks to cap instance costs.
  • List all instance pools available in our Databricks workspace.
  • Cancel the job run that's stuck in Databricks.
  • What Databricks Runtime versions can I use for a new cluster?
  • Show me the global init scripts configured in Databricks.
  • Delete the old test job and its history in Databricks.
  • Which instance profiles are registered in our Databricks workspace.

Databricks MCP connector tools

The Databricks MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

ToolDescription
listClustersList all clusters visible to the caller, including running, pending, and terminated clusters.
listSparkVersionsList the Databricks Runtime versions available for use with new clusters.
listNodeTypesList the node types available for use with new clusters in this workspace.
listClusterPoliciesList all cluster policies defined in the workspace.
getClusterPolicyByIdRetrieve a single cluster policy.
createClusterPolicyCreate a new cluster policy.
updateClusterPolicyUpdate an existing cluster policy.
deleteClusterPolicyDelete a cluster policy.
listJobsList jobs visible to the caller.
getJobByIdRetrieve the details for a single job.
createJobCreate a new job.
updateJobOverwrite all settings for an existing job.
patchJobApply a partial update to an existing job's settings, adding/changing only the fields provided and optionally removing n...
deleteJobDelete a job and its run history.
runJobNowTrigger an immediate run of a job.
listJobRunsList runs, most recent first.
getJobRunByIdRetrieve the metadata for a single run.
cancelJobRunCancel an in-progress run.
deleteJobRunDelete a non-active run's metadata.
listInstancePoolsList all instance pools visible to the caller.
listInstanceProfilesList the instance profiles registered in the workspace.
createInstanceProfileRegister a new instance profile for use by clusters.
updateInstanceProfileUpdate an existing instance profile's settings.
deleteInstanceProfileRemove an instance profile so clusters can no longer use it.
listAllClusterLibraryStatusesList library installation statuses across all clusters in the workspace.
listGlobalInitScriptsList all global init scripts configured for the workspace.
createGlobalInitScriptCreate a new global init script.
getGlobalInitScriptByIdRetrieve a single global init script, including its content.
updateGlobalInitScriptUpdate an existing global init script.
deleteGlobalInitScriptDelete a global init script.
listDbfsPathList the contents of a directory, or details of a file, on DBFS.
listWorkspaceObjectsList the contents of a workspace directory.
getWorkspaceObjectStatusGet metadata for a workspace object without its content.
createWorkspaceDirectoryCreate a directory (and any missing parents) in the workspace.
importWorkspaceObjectImport a notebook or file into the workspace.
exportWorkspaceObjectExport a notebook or file from the workspace.
deleteWorkspaceObjectDelete a workspace object.
listReposList Git repositories linked into the workspace.
createRepoClone a Git repository into the workspace.
getRepoByIdRetrieve details of a linked repository.
updateRepoUpdate the checked-out branch or tag of a linked repository.
deleteRepoRemove a linked repository from the workspace.
listGitCredentialsList the caller's stored Git credentials.
createGitCredentialStore a new Git credential for the caller.
getGitCredentialByIdRetrieve a single stored Git credential.
updateGitCredentialUpdate a stored Git credential.
deleteGitCredentialDelete a stored Git credential.
listSecretScopesList all secret scopes visible to the caller.
createSecretScopeCreate a new secret scope.
deleteSecretScopeDelete a secret scope and all secrets within it.
listSecretsList the metadata of secrets within a scope.
createOrUpdateSecretCreate or overwrite a secret value within a scope.
deleteSecretDelete a secret from a scope.
listSecretAclsList the ACLs configured on a secret scope.
createOrUpdateSecretAclGrant or update a principal's permission on a secret scope.
deleteSecretAclRevoke a principal's permission on a secret scope.
listTokensList metadata for the caller's personal access tokens.
createTokenCreate a new personal access token for the caller.
deleteTokenRevoke a personal access token.
listAllTokensList all personal access tokens in the workspace (admin only).
getTokenByIdRetrieve admin-visible metadata for a single token.
deleteAnyTokenRevoke any user's token (admin only).
listSqlWarehousesList the SQL warehouses in the workspace.
createSqlWarehouseCreate a new SQL warehouse.
getSqlWarehouseByIdRetrieve the details of a SQL warehouse.
deleteSqlWarehouseDelete a SQL warehouse.
updateSqlWarehouseUpdate the configuration of a SQL warehouse.
startSqlWarehouseStart a stopped SQL warehouse.
stopSqlWarehouseStop a running SQL warehouse.
listSqlQueriesList saved SQL queries visible to the caller.
createSqlQueryCreate a new saved SQL query.
getSqlQueryByIdRetrieve a single saved SQL query.
updateSqlQueryUpdate an existing saved SQL query.
deleteSqlQueryDelete a saved SQL query.
listSqlAlertsList SQL alerts visible to the caller.
createSqlAlertCreate a new SQL alert.
getSqlAlertByIdRetrieve a single SQL alert.
updateSqlAlertUpdate an existing SQL alert.
deleteSqlAlertDelete a SQL alert.
listQueryHistoryList the execution history of Databricks SQL queries.
executeSqlStatementExecute a SQL statement on a SQL warehouse and optionally wait synchronously for results.
getSqlStatementByIdRetrieve the current status and, once available, the results of a previously submitted statement.
getSqlStatementResultChunkRetrieve a specific chunk of a completed statement's result set.
cancelSqlStatementRequest cancellation of a running statement.
listCatalogsList catalogs visible to the caller.
getCatalogByNameRetrieve details of a single Catalog.
listSchemasList schemas visible to the caller.
createSchemaCreate a new Schema.
getSchemaByFullNameRetrieve details of a single Schema.
updateSchemaUpdate an existing Schema.
deleteSchemaDelete a Schema.
listTablesList tables visible to the caller.
getTableByFullNameRetrieve details of a single Table.
updateTableUpdate mutable metadata (e.g.
deleteTableDelete a Table.
listVolumesList volumes visible to the caller.
createVolumeCreate a new Volume.
getVolumeByFullNameRetrieve details of a single Volume.
updateVolumeUpdate an existing Volume.
deleteVolumeDelete a Volume.
listFunctionsList functions visible to the caller.
createFunctionRegister a new SQL/Python function in Unity Catalog.
getFunctionByFullNameRetrieve details of a single Function.
deleteFunctionDelete a Function.
listConnectionsList connections visible to the caller.
createConnectionCreate a new Connection.
getConnectionByNameRetrieve details of a single Connection.
updateConnectionUpdate an existing Connection.
deleteConnectionDelete a Connection.
listStorageCredentialsList storage credentials visible to the caller.
createStorageCredentialCreate a new StorageCredential.
getStorageCredentialByNameRetrieve details of a single StorageCredential.
updateStorageCredentialUpdate an existing StorageCredential.
deleteStorageCredentialDelete a StorageCredential.
listExternalLocationsList external locations visible to the caller.
getExternalLocationByNameRetrieve details of a single ExternalLocation.
getCurrentMetastoreAssignmentRetrieve the Unity Catalog metastore assigned to this workspace.
listServingEndpointsList the model serving endpoints in the workspace.
getServingEndpointByNameRetrieve the details and state of a serving endpoint.
getServingEndpointOpenApiRetrieve the OpenAPI 3.1 schema describing how to invoke a serving endpoint.
listMlflowExperimentsList MLflow experiments visible to the caller.
getMlflowExperimentByIdRetrieve a single MLflow experiment.
createMlflowExperimentCreate a new MLflow experiment.
deleteMlflowExperimentDelete an MLflow experiment.
getObjectPermissionsRetrieve the access-control list for a Databricks object.
setObjectPermissionsReplace the access-control list for a Databricks object.
updateObjectPermissionsGrant additional permissions on a Databricks object without removing existing ones.
listScimUsersList Users in the workspace.
createScimUserCreate a new scimuser.
getScimUserByIdRetrieve a single scimuser.
patchScimUserApply a partial update to a User via SCIM PatchOp operations.
deleteScimUserDelete a scimuser.
listScimGroupsList Groups in the workspace.
createScimGroupCreate a new scimgroup.
getScimGroupByIdRetrieve a single scimgroup.
deleteScimGroupDelete a scimgroup.
listScimServicePrincipalsList ServicePrincipals in the workspace.
createScimServicePrincipalCreate a new scimserviceprincipal.
getScimServicePrincipalByIdRetrieve a single scimserviceprincipal.
deleteScimServicePrincipalDelete a scimserviceprincipal.
getMeRetrieve the SCIM identity of the currently authenticated principal.
listPipelinesList Delta Live Tables pipelines visible to the caller.
createPipelineCreate a new Delta Live Tables pipeline.
getPipelineByIdRetrieve the details and state of a pipeline.
updatePipelineUpdate the configuration of an existing pipeline.
deletePipelineDelete a pipeline.
startPipelineUpdateStart a new update (run) of a pipeline.
stopPipelineStop a running pipeline update.
listLakeviewDashboardsList AI/BI dashboards visible to the caller.
createLakeviewDashboardCreate a new AI/BI dashboard.
getLakeviewDashboardByIdRetrieve a single AI/BI dashboard.
updateLakeviewDashboardUpdate an existing AI/BI dashboard.
deleteLakeviewDashboardMove an AI/BI dashboard to the trash.
listVectorSearchEndpointsList Vector Search endpoints in the workspace.
createVectorSearchEndpointCreate a new Vector Search endpoint.
getVectorSearchEndpointByNameRetrieve the details of a Vector Search endpoint.
deleteVectorSearchEndpointDelete a Vector Search endpoint.
getWorkspaceConfRetrieve the value of one or more workspace configuration keys.
updateWorkspaceConfSet one or more workspace configuration keys.
On this Page