Explores Databricks Unity Catalog metadata and lineage and runs SQL queries through the Statement Execution API.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add databricks-server-rafaelcartenet --env DATABRICKS_HOST='<DATABRICKS_HOST>' --env DATABRICKS_SQL_WAREHOUSE_ID='<DATABRICKS_SQL_WAREHOUSE_ID>' --env DATABRICKS_TOKEN='<DATABRICKS_TOKEN>' -- uv pip install -r requirements.txt~/.codex/config.toml
[mcp_servers.databricks-server-rafaelcartenet]
command = "uv"
args = ["pip", "install", "-r", "requirements.txt"]
env = { DATABRICKS_HOST = "<DATABRICKS_HOST>", DATABRICKS_SQL_WAREHOUSE_ID = "<DATABRICKS_SQL_WAREHOUSE_ID>", DATABRICKS_TOKEN = "<DATABRICKS_TOKEN>" }
# codex mcp add databricks-server-rafaelcartenet --env DATABRICKS_HOST='<DATABRICKS_HOST>' --env DATABRICKS_SQL_WAREHOUSE_ID='<DATABRICKS_SQL_WAREHOUSE_ID>' --env DATABRICKS_TOKEN='<DATABRICKS_TOKEN>' -- uv pip install -r requirements.txt~/.cursor/mcp.json
{
"mcpServers": {
"databricks-server-rafaelcartenet": {
"command": "uv",
"args": [
"pip",
"install",
"-r",
"requirements.txt"
],
"env": {
"DATABRICKS_HOST": "<DATABRICKS_HOST>",
"DATABRICKS_SQL_WAREHOUSE_ID": "<DATABRICKS_SQL_WAREHOUSE_ID>",
"DATABRICKS_TOKEN": "<DATABRICKS_TOKEN>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"databricks-server-rafaelcartenet": {
"type": "stdio",
"command": "uv",
"args": [
"pip",
"install",
"-r",
"requirements.txt"
],
"env": {
"DATABRICKS_HOST": "<DATABRICKS_HOST>",
"DATABRICKS_SQL_WAREHOUSE_ID": "<DATABRICKS_SQL_WAREHOUSE_ID>",
"DATABRICKS_TOKEN": "<DATABRICKS_TOKEN>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"databricks-server-rafaelcartenet": {
"command": "uv",
"args": [
"pip",
"install",
"-r",
"requirements.txt"
],
"env": {
"DATABRICKS_HOST": "<DATABRICKS_HOST>",
"DATABRICKS_SQL_WAREHOUSE_ID": "<DATABRICKS_SQL_WAREHOUSE_ID>",
"DATABRICKS_TOKEN": "<DATABRICKS_TOKEN>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"databricks-server-rafaelcartenet": {
"command": "uv",
"args": [
"pip",
"install",
"-r",
"requirements.txt"
],
"env": {
"DATABRICKS_HOST": "<DATABRICKS_HOST>",
"DATABRICKS_SQL_WAREHOUSE_ID": "<DATABRICKS_SQL_WAREHOUSE_ID>",
"DATABRICKS_TOKEN": "<DATABRICKS_TOKEN>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"databricks-server-rafaelcartenet": {
"command": "uv",
"args": [
"pip",
"install",
"-r",
"requirements.txt"
],
"env": {
"DATABRICKS_HOST": "<DATABRICKS_HOST>",
"DATABRICKS_SQL_WAREHOUSE_ID": "<DATABRICKS_SQL_WAREHOUSE_ID>",
"DATABRICKS_TOKEN": "<DATABRICKS_TOKEN>"
}
}
}
}Environment variables
DATABRICKS_HOSTDATABRICKS_SQL_WAREHOUSE_IDDATABRICKS_TOKEN
Replace the placeholders with your own credentials and keep them out of version control.