drio
Open app

Databricks MCP Server

Source

Catalog onlyCatalog onlySTDIO

Overview

Databricks MCP Server is a Model Context Protocol (MCP) server that connects to the Databricks API, enabling users to run SQL queries, list jobs, and check job statuses within Databricks.

To use the Databricks MCP Server, clone the repository, set up a virtual environment, install dependencies, configure your Databricks credentials in a .env file, and run the server using the command python main.py.

  • Execute SQL queries on Databricks SQL warehouses - List all jobs in Databricks - Retrieve the status of specific jobs - Access detailed information about jobs
  1. Running SQL queries to analyze data in Databricks.
  2. Monitoring job statuses for data processing tasks.
  3. Integrating with LLMs for natural language queries about data and jobs.

Add to your AI client

Use these steps to connect Databricks MCP Server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "databricks-mcp-server-jordineil": {
      "command": "python3",
      "args": [
        "main.py"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "databricks-mcp-server-jordineil": {
      "command": "python3",
      "args": [
        "main.py"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "databricks-mcp-server-jordineil": {
      "command": "python3",
      "args": [
        "main.py"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "databricks-mcp-server-jordineil": {
      "type": "stdio",
      "command": "python3",
      "args": [
        "main.py"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "databricks-mcp-server-jordineil": {
      "command": "python3",
      "args": [
        "main.py"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "databricks-mcp-server-jordineil": {
      "command": "python3",
      "args": [
        "main.py"
      ]
    }
  }
}

FAQ

What are the prerequisites to use the server?

You need Python 3.7+, a Databricks workspace with a personal access token, and permissions to run queries.

How do I obtain Databricks credentials?

You can create a personal access token in Databricks under User Settings, and find your SQL warehouse HTTP path in the SQL Warehouses section.

Is there a way to test the connection?

Yes, you can run the included test script `python test_connection.py` to verify your connection.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":3688,"uuid":"5ca8a909-17dc-4dd3-ab6f-2373d8ec3fc3","name":"databricks-mcp-server","title":"Databricks MCP Server","description":"","avatar_url":"https://1000marcas.net/wp-content/uploads/2025/01/Databricks-Emblem.png","created_at":"2025-03-21T03:29:52.455Z","updated_at":"2025-03-21T03:34:52.289Z","status":"created","author_name":"JordiNeil","author_avatar_url":null,"tags":"databricks,mcp-server,sql-queries","category":"developer-tools","is_featured":false,"sort":1,"url":"https://github.com/JordiNeil/mcp-databricks-server","target":"_self","content":"$29","summary":"$2a","img_url":null,"type":null,"metadata":null,"user_uuid":"0128600e-3429-417b-84ac-7f8941a2ce8b","tools":null,"sse_url":null,"sse_provider":null,"sse_params":null,"is_official":false,"server_command":"python3 main.py","server_params":"{}","server_config":"{\n \"mcpServers\": {\n \"databricks\": {\n \"command\": \"python3\",\n \"args\": [\n \"main.py\"\n ]\n }\n }\n}","allow_call":false,"is_innovation":false,"is_dxt":false,"dxt_manifest":null,"dxt_file_url":null,"is_audit":false},"randomProjects":[],"currentServerKey":"$undefined"}]]}]

Developer tools