description: "Set up and deploy a Databricks MCP server from this template"

🚀 Databricks MCP Server Setup

I'll help you set up your own Databricks MCP (Model Context Protocol) server so Claude can interact with your Databricks workspace!

📋 What We'll Do

⏺ Step 1: Environment Setup - Configure Databricks authentication

⏺ Step 2: Deploy MCP Server - Deploy to Databricks Apps

⏺ Step 3: Add to Claude - Configure Claude to use your MCP server

⏺ Step 4: Test Connection - Verify everything works

⏺ Step 5: Customize - Add your own prompts and tools (optional)

Step 0: Check Configuration and Existing MCP Setup

First, let me check your MCP server configuration:

[I'll read config.yaml to get your server name]

# config.yaml
servername: [your-server-name]  # Default is 'databricks-mcp'

Now let me check if your MCP server is already set up:

# Check if MCP server is already added to Claude
SERVER_NAME="[server-name-from-config]"
echo "list your mcp servers" | claude | grep -q "$SERVER_NAME" && echo "✅ MCP server '$SERVER_NAME' already configured!" || echo "❌ MCP server '$SERVER_NAME' not found"

[I'll run this check with the actual server name]

If the MCP server is already configured AND .env.local exists:

✅ Your MCP server '$SERVER_NAME' is already set up! What would you like to do?

1. Skip to customization - Jump to Step 5 to add custom prompts and tools
2. Test the connection - Go to Step 4 to verify everything works
3. Redeploy with changes - Continue with Step 2 to update deployment
4. Start fresh - Remove and reinstall: claude mcp remove $SERVER_NAME
5. Continue from the beginning - Go through all steps

Please let me know which option you'd prefer!

If .env.local doesn't exist:

• 🆕 This looks like a fresh clone - let's start from Step 1!

Step 1: Environment Setup

Let me check if your environment is already configured:

[I'll check for .env.local file existence]

# Check if .env.local exists
if [ -f ".env.local" ]; then
    echo "✅ Great! .env.local found - environment is already configured"
    # Test authentication
    source .env.local && export DATABRICKS_HOST && export DATABRICKS_TOKEN && databricks current-user me
else
    echo "📋 Starting fresh - let's create your .env.local with setup"
fi

If .env.local doesn't exist, I'll run the interactive setup script:

# Open a new terminal for interactive setup
CURRENT_DIR=$(pwd)
if [ -d "/Applications/iTerm.app" ]; then
    osascript <<EOF
tell application "iTerm"
    create window with default profile
    tell current session of current window
        write text "cd $CURRENT_DIR && ./setup.sh --auto-close"
    end tell
    activate
end tell
EOF
else
    osascript <<EOF
tell application "Terminal"
    do script "cd $CURRENT_DIR && ./setup.sh --auto-close"
    activate
end tell
EOF
fi

[I'll wait for you to complete the setup and say "done" when you're ready to continue]

Please say "done" when the setup script completes!

Step 2: Deploy MCP Server

After you've said "done", I'll deploy your MCP server:

a) Check if app exists:

[I'll run ./app_status.sh to check current status]

b) Create and deploy app:

# Deploy (creates app if needed)
nohup ./deploy.sh --create --verbose > /tmp/mcp-deploy.log 2>&1 &

c) Monitor deployment:

[I'll tail the log file and monitor progress]

# Monitor deployment log
tail -f /tmp/mcp-deploy.log

d) Wait for app to be fully ready:

[I'll keep checking app status until it's RUNNING]

# Keep checking until app is ready
while true; do
    STATUS=$(./app_status.sh | grep "App Status:" | awk '{print $NF}')
    if [ "$STATUS" = "RUNNING" ]; then
        echo "✅ App is now RUNNING!"
        break
    else
        echo "⏳ App status: $STATUS - waiting..."
        sleep 10
    fi
done

e) Get your app URL:

[Once the app is RUNNING, I'll show you the deployed app]

# Get and display app URL
export DATABRICKS_APP_URL=$(./app_status.sh | grep "App URL" | awk '{print $NF}')
echo "
✅ Your MCP server is deployed!
🌐 App URL: $DATABRICKS_APP_URL
🔗 You can visit your app at: $DATABRICKS_APP_URL
"

Step 3: Add MCP Server to Claude

Only after the app is fully deployed and RUNNING, we'll add it to Claude:

Now let's add your MCP server to Claude!

[I'll read the configuration from .env.local and app_status.sh]

# Get configuration
source .env.local
export DATABRICKS_APP_URL=$(./app_status.sh | grep "App URL" | awk '{print $NF}')

# Add MCP server to Claude
claude mcp add $SERVER_NAME --scope user -- \
  uvx --refresh --from git+ssh://git@github.com/databricks-solutions/custom-mcp-databricks-app.git \
  dba-mcp-proxy \
  --databricks-host $DATABRICKS_HOST \
  --databricks-app-url $DATABRICKS_APP_URL

[I'll execute this command with your actual values]

Step 4: Test Connection