Connecting VS Code and GitHub Copilot to the Databricks Managed MCP Server

Community Articles

Dive into a collaborative space where members like YOU can exchange knowledge, tips, and best practices. Join the conversation today and unlock a wealth of collective wisdom to enhance your experience and drive success.

Recently, Databricks released a preview version of the Managed MCP Server. Upon seeing this, I immediately wanted to integrate Databricks Genie with VS Code and GitHub Copilot agent mode. Below, I will briefly share the setup process:

Step 1: Prepare Genie on Databricks.

In this case, I used the sample table samples.nyctaxi.trips to create Genie.

Step 2: Configure VS Code

Depending on your requirements, edit either .vscode/mcp.json or .vscode/settings.json in your VS Code workspace. Please refer to the following example for guidance:

{
    "chat.mcp.enabled": true,
    "mcp": {
        "inputs": [],
        "servers": {
            "my-genie": {
                "type": "http",
                "url": "https://<your-workspace-hostname>/api/2.0/mcp/genie/{genie_space_id}",
                "headers": {
                    "Authorization": "Bearer <your-personal-access-token>"
                }
            }
        }
    }
}

You can obtain a personal access token according to the documentation.