Databricks MCP Server

Databricks MCP Server

A comprehensive Model Context Protocol (MCP) server for Databricks, built on the official Databricks Python SDK.

Provides 263 tools and 8 prompt templates across 28 service domains, giving AI assistants full access to the Databricks platform.

Features

• SDK-first: Uses databricks-sdk for type safety and automatic API freshness
• Comprehensive: Covers Unity Catalog, SQL, Compute, Jobs, Pipelines, Serving, Vector Search, Apps, Lakebase, Dashboards, Genie, Secrets, IAM, Connections, Experiments, and Delta Sharing
• Zero custom auth: Delegates authentication entirely to the SDK (PAT, OAuth, Azure AD, service principal -- all automatic)
• Selective loading: Include/exclude tool modules via environment variables
• MCP Resources: Read-only workspace context (URL, current user, auth type)

Quick Start

Installation

pip install databricks-sdk-mcp

Or run with Docker:

docker run -i -e DATABRICKS_HOST=... -e DATABRICKS_TOKEN=... databricks-mcp

Or install from source:

git clone https://github.com/pramodbhatofficial/databricks-mcp-server.git

cd databricks-mcp-server pip install -e ".[dev]"

Authentication

Authentication is handled by the Databricks SDK. Set one of:

Personal Access Token (simplest):

export DATABRICKS_HOST=https://your-workspace.databricks.com

export DATABRICKS_TOKEN=dapi...

OAuth (M2M -- service principal):

export DATABRICKS_HOST=https://your-workspace.databricks.com

export DATABRICKS_CLIENT_ID=... export DATABRICKS_CLIENT_SECRET=...

OAuth (U2M -- interactive browser login):

Authenticate as yourself with short-lived, auto-refreshing OAuth tokens. Log in once with the Databricks CLI, which caches the token under a named profile in ~/.databrickscfg:

databricks auth login --host https://your-workspace.databricks.com --profile my-profile

Then point the server at that profile instead of setting a token:

export DATABRICKS_CONFIG_PROFILE=my-profile

Note: If DATABRICKS_TOKEN is set, the SDK uses it in preference to the profile.

Leave DATABRICKS_TOKEN/DATABRICKS_HOST unset when authenticating via a profile.

Other methods: Azure AD, Azure Managed Identity -- all auto-detected by the SDK.

Running

databricks-mcp

This starts the MCP server using stdio transport.

Integrations

Claude Code (Terminal)

Add to ~/.claude/settings.json or your project's .claude/settings.json:

{

"mcpServers": { "databricks": { "command": "databricks-mcp", "env": { "DATABRICKS_HOST": "https://your-workspace.databricks.com", "DATABRICKS_TOKEN": "dapi..." } } } }

To use OAuth U2M instead of a token, reference a logged-in profile (see Authentication) and omit DATABRICKS_HOST/DATABRICKS_TOKEN:

{

"mcpServers": { "databricks": { "command": "databricks-mcp", "env": { "DATABRICKS_CONFIG_PROFILE": "my-profile" } } } }

Then restart Claude Code. Verify with /mcp to see the registered tools.

Claude Desktop

Add to your Claude Desktop config file:

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Windows: %APPDATA%\Claude\claude_desktop_config.json

{

"mcpServers": { "databricks": { "command": "databricks-mcp", "env": { "DATABRICKS_HOST": "https://your-workspace.databricks.com", "DATABRICKS_TOKEN": "dapi..." } } } }

Restart Claude Desktop. The Databricks tools will appear in the tool picker.

Cursor

Add to .cursor/mcp.json in your project root (or ~/.cursor/mcp.json for global):

{

"mcpServers": { "databricks": { "command": "databricks-mcp", "env": { "DATABRICKS_HOST": "https://your-workspace.databricks.com", "DATABRICKS_TOKEN": "dapi..." } } } }

Open Cursor Settings > MCP to verify the server is connected.

Windsurf

Add to ~/.codeium/windsurf/mcp_config.json:

{

"mcpServers": { "databricks": { "command": "databricks-mcp", "env": { "DATABRICKS_HOST": "https://your-workspace.databricks.com", "DATABRICKS_TOKEN": "dapi..." } } } }

VS Code (Copilot)

Add to .vscode/mcp.json in your project:

{

"servers": { "databricks": { "command": "databricks-mcp", "env": { "DATABRICKS_HOST": "https://your-workspace.databricks.com", "DATABRICKS_TOKEN": "dapi..." } } } }

Zed

Add to Zed's settings (~/.config/zed/settings.json):

{

"context_servers": { "databricks": { "command": { "path": "databricks-mcp", "env": { "DATABRICKS_HOST": "https://your-workspace.databricks.com", "DATABRICKS_TOKEN": "dapi..." } } } } }

Any MCP Client (Generic stdio)

The server uses stdio transport. Connect from any MCP-compatible client:

# Set auth env vars

export DATABRICKS_HOST=https://your-workspace.databricks.com export DATABRICKS_TOKEN=dapi...

Start the server (communicates via stdin/stdout)

databricks-mcp

Tip: Load Only What You Need

If your MCP client struggles with many tools, use selective loading to reduce the tool count:

{

"mcpServers": { "databricks": { "command": "databricks-mcp", "env": { "DATABRICKS_HOST": "https://your-workspace.databricks.com", "DATABRICKS_TOKEN": "dapi...", "DATABRICKS_MCP_TOOLS_INCLUDE": "unity_catalog,sql,compute,jobs" } } } }

Tool Modules

Selective Tool Loading

With 263 tools, it's recommended to load only the modules you need. This improves agent performance and tool selection accuracy.

Role-Based Presets (Recommended)

Pick a preset that matches your role:

Example using a preset in Claude Code:

{

"mcpServers": { "databricks": { "command": "databricks-mcp", "env": { "DATABRICKS_HOST": "https://your-workspace.databricks.com", "DATABRICKS_TOKEN": "dapi...", "DATABRICKS_MCP_TOOLS_INCLUDE": "unity_catalog,sql,compute,jobs,pipelines,files,quality_monitors" } } } }

Custom Filtering

# Only include specific modules

export DATABRICKS_MCP_TOOLS_INCLUDE=unity_catalog,sql,serving

Exclude specific modules (cannot combine with INCLUDE)

export DATABRICKS_MCP_TOOLS_EXCLUDE=iam,sharing,experiments

If INCLUDE is set, only those modules load. If EXCLUDE is set, everything except those modules loads. INCLUDE takes precedence if both are set.

Tool Discovery (For AI Agents)

The server includes built-in tool discovery to help AI agents find the right tools:

MCP Resources

Agents can read databricks://tools/guide at connection time to understand what's available.

Discovery Tool

The databricks_tool_guide tool helps agents find the right tools during a conversation:

# Find tools for a specific task

databricks_tool_guide(task="run a SQL query") databricks_tool_guide(task="deploy an ML model") databricks_tool_guide(task="create a user")

Get role-based recommendations

databricks_tool_guide(role="data_engineer") databricks_tool_guide(role="ml_engineer")

This returns matching modules with descriptions and usage hints, so the agent knows exactly which databricks_* tools to call.

MCP Prompts (Guided Workflows)

The server includes 8 prompt templates that guide AI agents through multi-step Databricks workflows:

| setup_data_pipeline | Create a DLT pipeline with s