Databricks

io.github.mcp-dirPublished by GitHub account mcp-dirv0.1.0Updated Oct 26, 2026

Your Databricks Lakehouse in natural language: run SQL on your SQL warehouses, track long-running qu

VerifiedStreamable HTTPWeb executableDatabasesDeveloper ToolsData & Analytics

Overview

AI-generated overview

Connects an assistant to Databricks workspaces so it can run SQL on SQL warehouses and browse Unity Catalog metadata.

What you can do
  • List connected Databricks workspaces and identify the current user of the token
  • List and inspect SQL warehouses, and run SQL statements on a chosen or auto-selected running warehouse
  • Poll statement status and results, or cancel running statements
  • Browse Unity Catalog catalogs, schemas and tables, and read table columns and types
  • Check platform versions, report bugs or feedback, and inspect toolkit connection status
  • Search a marketplace of MCPs and authenticate with an access token
When to use it
Useful when an assistant should query data in a Databricks lakehouse, explore Unity Catalog structure, or manage long-running SQL statements without leaving the chat.
Requirements
A remote MCP endpoint; no local package or runtime is needed. A Databricks workspace with a personal access token (PAT) and access to SQL warehouses and Unity Catalog objects. Authentication is done by logging in through the browser and supplying an access token, ideally as an Authorization Bearer header.
Before you install
The token grants access to your Databricks workspace, so treat it as a secret and prefer the header configuration over pasting it into a session. SQL statements run with the token's permissions and can change or delete data, and statements can be cancelled. Bug reports can include recent conversation messages. The marketplace and toolkit tools reach third-party services.

Installation

In SourceWeft

  1. Open Databricks in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/io.github.mcp-dir%2Fdatabricks-mcp/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config.

{
  "mcpServers": {
    "databricks": {
      "type": "http",
      "url": "https://api.mcp.ai/p_databricks"
    }
  }
}

README

This repository has no README.

Tools

17

databricks_list_accounts

Lista os workspaces Databricks conectados a este install — host, label.

Parametersaccount

databricks_current_user

Identifica o usuário do PAT no workspace (whoami via SCIM Me). Útil pra confirmar qual conta/host está conectado e validar o token.

Parametersaccount

databricks_list_warehouses

Lista os SQL warehouses do workspace (id, name, state, cluster_size, warehouse_type). Use o `id` em databricks_run_sql (ou deixe o run_sql escolher um RUNNING automaticamente).

Parametersaccount

databricks_get_warehouse

Detalha um ou mais SQL warehouses por id. Aceita lista (`ids`).

Parametersidsrequiredaccount

databricks_run_sql

Executa uma instrução SQL num SQL warehouse (Statement Execution API). Retorna colunas + linhas quando termina dentro do wait_timeout; senão devolve statement_id + state pra polling via databricks_get_statement. Se `warehouse_id` não for informado, escolhe um warehouse RUNNING automaticamente. PREFIRA queries parametrizadas (`parameters`) a interpolar valores na string (proteção contra SQL injection). SQL é arbitrário (pode DML/DDL) — confirme antes de mutar dados. Bulk support: accepts warehouse_ids for batched execution.

Parametersschemaaccountcatalogrow_limitstatementrequiredparameterswait_timeoutwarehouse_idwarehouse_idson_wait_timeout

databricks_get_statement

Status + resultado de um ou mais statements por id (polling de queries longas que voltaram PENDING/RUNNING do run_sql). Aceita lista (`statement_ids`).

Parametersaccountstatement_idsrequired

databricks_cancel_statement

Cancela um ou mais statements em execução por id. Aceita lista (`statement_ids`).

Parametersaccountstatement_idsrequired

databricks_list_catalogs

Lista os catálogos do Unity Catalog visíveis ao PAT (name, comment, owner).

Parametersaccount

databricks_list_schemas

Lista os schemas (databases) de um catálogo Unity. Informe `catalog_name`.

Parametersaccountcatalog_namerequired

databricks_list_tables

Lista as tabelas de um schema Unity (name, table_type, data_source_format). Informe `catalog_name` e `schema_name`.

Parametersaccountschema_namerequiredcatalog_namerequired

databricks_get_table

Detalha uma ou mais tabelas (colunas, tipos) por nome completo `catalog.schema.table`. Aceita lista (`full_names`).

Parametersaccountfull_namesrequired

show_version

Show Version

Show the current MCP platform and adapter versions.

Takes no parameters.

report_bug

Report Bug

Report a bug, missing feature, or send feedback. Include the conversation array with recent messages for reproduction.

Parameterscontextmessagerequiredconversation

connect

Connection Status

Returns connection status and URLs. When all providers are connected, returns authenticated:true and empty pending[]. When credentials are missing, returns connect_url for the toolkit and per-install URLs.

Takes no parameters.

toolkit_info

Toolkit Info

Returns the current toolkit state: installed MCPs, their connection status, the accounts connected to each one, and how many catalog tools each exposes.

Takes no parameters.

marketplace

Marketplace

The official mcp.ai marketplace — the in-platform catalog of every MCP/tool, AND the way to run them. Covers capability requests like "find an MCP that does X", "consulta um CPF", "is there a tool for Y". Core flow: action=search discovers MCPs by intent → describe returns one MCP's full profile (every tool with its id + params, pricing, auth) so you pick the right tool_id → invoke RUNS that tool. KEY: invoke works even when the MCP is NOT installed — it runs the tool pontualmente (one-off), without adding the MCP to the toolkit and without bloating the tool list. If the MCP needs a credential/login, invoke returns a connect link; if it is paid and the wallet is empty, invoke returns a checkout/top-up link (the user opens it, then you retry). Use install only to make an MCP PERMANENT in the active toolkit (its tools then show up natively in future sessions); prefer invoke for a single/occasional use. list_tools lists what is callable right now. subscribe/cancel handle per-MCP billing; report_bug sends feedback; request_mcp asks us to build a NEW MCP when nothing fits. Search/describe flag installed_in_toolkit vs installed_in_workspace. Writes (install/uninstall/subscribe/cancel and the one-off install behind invoke) require workspace owner/admin. It also carries the mcp.ai PROMPT LIBRARY, which is about ready-made prompt TEXT rather than MCPs: search_prompts finds one, get_prompt returns its full text with {{variables}} filled, and publish_prompt saves a prompt and returns a shareable mcp.ai/p/<slug> link that opens without login.

Parameterslimitqueryactionmcp_idmessagetool_idargumentsimmediatetier_slugprompt_bodyprompt_slugprompt_tool+11 more

authenticate

Authenticate

MCP.AI for IDE agents (Cursor, etc.): log in in the browser, copy the access token. Best: add it to this server's config as a header `Authorization: Bearer <token>` for a permanent, non-expiring connection. Or paste it here for a session-only login: call with { token: "<jwt>" } after the user pastes, or with no args to get the link.

Parameterstoken

Version history

1
  1. v0.1.0LatestSep 16, 2026

Score

75% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 daysRequired25 pts
  • Auth declaredRequired10 pts
  • Tools listedRequired15 pts
  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts

    Declare a GitHub repository with a README, or serve resource_documentation in the OAuth protected-resource metadata.

  • License10 pts

    Declare a license in the repository or the registry entry.