Runs SQL queries and lists Databricks jobs and their run details.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add databricks --env DATABRICKS_HOST='<DATABRICKS_HOST>' --env DATABRICKS_HTTP_PATH='<DATABRICKS_HTTP_PATH>' --env DATABRICKS_TOKEN='<DATABRICKS_TOKEN>' -- python3 main.py~/.codex/config.toml
[mcp_servers.databricks]
command = "python3"
args = ["main.py"]
env = { DATABRICKS_HOST = "<DATABRICKS_HOST>", DATABRICKS_HTTP_PATH = "<DATABRICKS_HTTP_PATH>", DATABRICKS_TOKEN = "<DATABRICKS_TOKEN>" }
# codex mcp add databricks --env DATABRICKS_HOST='<DATABRICKS_HOST>' --env DATABRICKS_HTTP_PATH='<DATABRICKS_HTTP_PATH>' --env DATABRICKS_TOKEN='<DATABRICKS_TOKEN>' -- python3 main.py~/.cursor/mcp.json
{
"mcpServers": {
"databricks": {
"command": "python3",
"args": [
"main.py"
],
"env": {
"DATABRICKS_HOST": "<DATABRICKS_HOST>",
"DATABRICKS_HTTP_PATH": "<DATABRICKS_HTTP_PATH>",
"DATABRICKS_TOKEN": "<DATABRICKS_TOKEN>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"databricks": {
"type": "stdio",
"command": "python3",
"args": [
"main.py"
],
"env": {
"DATABRICKS_HOST": "<DATABRICKS_HOST>",
"DATABRICKS_HTTP_PATH": "<DATABRICKS_HTTP_PATH>",
"DATABRICKS_TOKEN": "<DATABRICKS_TOKEN>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"databricks": {
"command": "python3",
"args": [
"main.py"
],
"env": {
"DATABRICKS_HOST": "<DATABRICKS_HOST>",
"DATABRICKS_HTTP_PATH": "<DATABRICKS_HTTP_PATH>",
"DATABRICKS_TOKEN": "<DATABRICKS_TOKEN>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"databricks": {
"command": "python3",
"args": [
"main.py"
],
"env": {
"DATABRICKS_HOST": "<DATABRICKS_HOST>",
"DATABRICKS_HTTP_PATH": "<DATABRICKS_HTTP_PATH>",
"DATABRICKS_TOKEN": "<DATABRICKS_TOKEN>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"databricks": {
"command": "python3",
"args": [
"main.py"
],
"env": {
"DATABRICKS_HOST": "<DATABRICKS_HOST>",
"DATABRICKS_HTTP_PATH": "<DATABRICKS_HTTP_PATH>",
"DATABRICKS_TOKEN": "<DATABRICKS_TOKEN>"
}
}
}
}Environment variables
DATABRICKS_HOSTDATABRICKS_HTTP_PATHDATABRICKS_TOKEN
Replace the placeholders with your own credentials and keep them out of version control.