Set up the Databricks MCP server
Databricks ships managed MCP servers built into the platform — Unity Catalog functions, Genie spaces, SQL warehouses, and AI Search indexes — with no infrastructure to deploy. MintMCP exposes these as four recommended connectors (Databricks Functions, Genie, SQL, AI Search), and this guide covers finding your workspace URLs, registering a Databricks App Connection (or generating a PAT), and installing the connectors you need.
Prerequisites
- A MintMCP admin account
- A Databricks workspace with the Managed MCP Servers public preview enabled
Set up authentication
Every connector authenticates one of two ways — pick the one that fits, then paste the result into each connector you install. An OAuth App Connection keeps permissions per user and suits production; a PAT is quicker when a single shared service identity is good enough.
- OAuth App Connection
- Personal access token
An account admin registers one OAuth app in the Databricks account console. The same Client ID and Client Secret get pasted into each of the recommended Databricks connectors you install.
-
Go to the Databricks account console → Settings → App Connections.
-
Click Add connection.
-
Fill the form:
Field Value Name A descriptive identifier (for example, mintmcp-databricks)Client type Confidential (with secret) Scopes genie,ai-search,sql,unity-catalogRedirect URL https://app.mintmcp.com/oauth/callbackAccess Token TTL 1440(24 hours)Refresh Token TTL 129600(90 days)Note on scopes:
all-apisstill works as a scope but is broader than necessary.vector-searchremains supported as the legacy alias forai-search. -
Click Save, then copy the Client ID and Client Secret. Databricks shows the Client Secret only once — copy it before you close the dialog.
A PAT is the simplest option when a single shared service identity is good enough — no account-admin involvement, no per-user OAuth.
- In your Databricks workspace, click your username in the top bar and select Settings.
- Click Developer.
- Next to Access tokens, click Manage.
- Click Generate new token.
- Enter a description (for example,
MintMCP gateway) and set a token lifetime. 90 days is a reasonable upper bound; plan to rotate before expiry. - Click Generate and copy the token — it's shown only once.
Note on PAT scope: A PAT inherits every permission the token owner has in the workspace — wider than any of the narrow OAuth scopes. Prefer OAuth for production.
Install a Databricks connector
In your Databricks workspace, go to Agents > MCP Servers to find your workspace URLs. Each MintMCP recommended connector wraps one Databricks managed server — pick the tab for the one you're setting up.
- Databricks Functions
- Databricks Genie
- Databricks SQL
- Databricks AI Search
Runs Unity Catalog functions as MCP tools — a whole schema, or a single function.
| Field | Value |
|---|---|
| URL | https://<workspace-hostname>/api/2.0/mcp/functions/{catalog}/{schema} (append /{function_name} for one function) |
| Scope | unity-catalog |
| Access | Read and execute, bounded by EXECUTE on the catalog, schema, or function |
Add to MintMCP
- In MCP store → Manage store → Recommended servers, search Databricks and Install the Databricks Functions connector.
- In Server URL, paste the URL above.
- Under Authorization Method, choose your auth and finish:
- OAuth
- Bearer Token
- Select OAuth (detected from server).
- Open OAuth Client Advanced Settings and paste your App Connection's Client ID and Client Secret.
- Set Connection type to Per-user credentials.
- Click Install.
- Select Bearer Token.
- Paste your PAT.
- Set Connection type to Shared credentials.
- Click Install.
Other endpoints: expose the system Python interpreter (https://<workspace-hostname>/api/2.0/mcp/functions/system/ai) or a single-function URL outside the catalog/schema pattern through + Add an MCP to your registry → Connect to an MCP by URL — the auth choices work the same way.
Security considerations
- Per-user
EXECUTEwith OAuth + per-user credentials — each user's Unity Catalog grants apply. - Prefer OAuth — a PAT inherits every workspace permission its owner has.
- Public preview — no production SLA yet; allowlist MintMCP's outbound IPs if the workspace restricts inbound. Unity AI Gateway (April 2026) adds Databricks-side governance to pair with MintMCP gateway logs.
Queries a single Genie space in natural language.
| Field | Value |
|---|---|
| URL | https://<workspace-hostname>/api/2.0/mcp/genie/{genie_space_id} |
| Scope | genie |
| Access | Read-only, bounded by the Genie space's underlying dataset permissions |
Add to MintMCP
- In MCP store → Manage store → Recommended servers, search Databricks and Install the Databricks Genie connector.
- In Server URL, paste the URL above.
- Under Authorization Method, choose your auth and finish:
- OAuth
- Bearer Token
- Select OAuth (detected from server).
- Open OAuth Client Advanced Settings and paste your App Connection's Client ID and Client Secret.
- Set Connection type to Per-user credentials.
- Click Install.
- Select Bearer Token.
- Paste your PAT.
- Set Connection type to Shared credentials.
- Click Install.
All spaces at once: front every Genie space the user can access through the workspace-aggregated Genie One endpoint https://<workspace-hostname>/api/2.0/mcp/genie (no space ID) via + Add an MCP to your registry → Connect to an MCP by URL — same auth choices.
Security considerations
- Read-only — no write path through the Genie MCP server.
- Dataset permissions apply — Genie returns only rows the connected identity can see.
- Prefer OAuth — a PAT inherits every workspace permission its owner has.
- Public preview — no production SLA yet; allowlist MintMCP's outbound IPs if the workspace restricts inbound. Unity AI Gateway (April 2026) adds Databricks-side governance to pair with MintMCP gateway logs.
Runs SQL against Databricks SQL warehouses.
| Field | Value |
|---|---|
| URL | https://<workspace-hostname>/api/2.0/mcp/sql |
| Scope | sql |
| Access | Read and write SQL, bounded by warehouse access and Unity Catalog table permissions |
Add to MintMCP
- In MCP store → Manage store → Recommended servers, search Databricks and Install the Databricks SQL connector.
- In Server URL, paste the URL above.
- Under Authorization Method, choose your auth and finish:
- OAuth
- Bearer Token
- Select OAuth (detected from server).
- Open OAuth Client Advanced Settings and paste your App Connection's Client ID and Client Secret.
- Set Connection type to Per-user credentials.
- Click Install.
- Select Bearer Token.
- Paste your PAT.
- Set Connection type to Shared credentials.
- Click Install.
Security considerations
- Supports writes — agents can run mutating SQL; restrict write tools via Tool customization if that's a concern.
- Warehouse + table permissions apply — only reachable tables are readable or writable.
- Prefer OAuth — a PAT inherits every workspace permission its owner has.
- Public preview — no production SLA yet; allowlist MintMCP's outbound IPs if the workspace restricts inbound. Unity AI Gateway (April 2026) adds Databricks-side governance to pair with MintMCP gateway logs.
Runs semantic search against an AI Search index.
| Field | Value |
|---|---|
| URL | https://<workspace-hostname>/api/2.0/mcp/ai-search/{catalog}/{schema}/{index_name} |
| Scope | ai-search |
| Access | Semantic-search read, bounded by index access permissions |
Renamed service: Databricks renamed Vector Search to AI Search. The legacy /api/2.0/mcp/vector-search/ URL prefix and vector-search scope still work for backward compatibility.
Add to MintMCP
- In MCP store → Manage store → Recommended servers, search Databricks and Install the Databricks AI Search connector.
- In Server URL, paste the URL above.
- Under Authorization Method, choose your auth and finish:
- OAuth
- Bearer Token
- Select OAuth (detected from server).
- Open OAuth Client Advanced Settings and paste your App Connection's Client ID and Client Secret.
- Set Connection type to Per-user credentials.
- Click Install.
- Select Bearer Token.
- Paste your PAT.
- Set Connection type to Shared credentials.
- Click Install.
Security considerations
- Read-only — semantic search only, no write path.
- Index permissions apply — the connected identity needs read on the AI Search index.
- Prefer OAuth — a PAT inherits every workspace permission its owner has.
- Public preview — no production SLA yet; allowlist MintMCP's outbound IPs if the workspace restricts inbound. Unity AI Gateway (April 2026) adds Databricks-side governance to pair with MintMCP gateway logs.
Troubleshooting
redirect_uri_mismatchon OAuth install — the App Connection's redirect URL must be exactlyhttps://app.mintmcp.com/oauth/callback.401 Unauthorizedwith a PAT — the token expired or was revoked, so regenerate it in Databricks and update the connector.- Empty tool list after install — the connected identity lacks the permission the connector needs:
EXECUTEon the catalog or schema (Functions), Genie space membership and dataset permissions (Genie), warehouse and table access (SQL), or read on the index (AI Search). vector-searchscope rejected — the account admin disabled legacy scopes, so switch the App Connection toai-search.
Next steps
- Tool customization — Control which Databricks tools are exposed to users
- MCP gateway administration — Manage access and permissions
- Unity AI Gateway docs — Databricks-side governance for MCP traffic