Serveur MCP

Databricks

io.github.mcp-dir/databricks-mcp

Ce que fait ce MCP

Connects to Databricks workspaces to browse Unity Catalog metadata, execute SQL, inspect tables and warehouses, and manage long-running statements.

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.
Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'token': {'type': 'string'}}}
connect
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.
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
databricks_cancel_statement
Cancela um ou mais statements em execução por id. Aceita lista (`statement_ids`).
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['statement_ids'], 'properties': {'account': {'type': 'string'}, 'statement_ids': {'type': 'array', 'items': {'type': 'string'}}}}
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.
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'account': {'type': 'string'}}}
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`).
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['statement_ids'], 'properties': {'account': {'type': 'string'}, 'statement_ids': {'type': 'array', 'items': {'type': 'string'}}}}
databricks_get_table
Detalha uma ou mais tabelas (colunas, tipos) por nome completo `catalog.schema.table`. Aceita lista (`full_names`).
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['full_names'], 'properties': {'account': {'type': 'string'}, 'full_names': {'type': 'array', 'items': {'type': 'string'}}}}
databricks_get_warehouse
Detalha um ou mais SQL warehouses por id. Aceita lista (`ids`).
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['ids'], 'properties': {'ids': {'type': 'array', 'items': {'type': 'string'}}, 'account': {'type': 'string'}}}
databricks_list_accounts
Lista os workspaces Databricks conectados a este install — host, label.
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'account': {'type': 'string'}}}
databricks_list_catalogs
Lista os catálogos do Unity Catalog visíveis ao PAT (name, comment, owner).
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'account': {'type': 'string'}}}
databricks_list_schemas
Lista os schemas (databases) de um catálogo Unity. Informe `catalog_name`.
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['catalog_name'], 'properties': {'account': {'type': 'string'}, 'catalog_name': {'type': 'string'}}}
databricks_list_tables
Lista as tabelas de um schema Unity (name, table_type, data_source_format). Informe `catalog_name` e `schema_name`.
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['catalog_name', 'schema_name'], 'properties': {'account': {'type': 'string'}, 'schema_name': {'type': 'string'}, 'catalog_name': {'type': 'string'}}}
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).
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'account': {'type': 'string'}}}
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.
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['statement'], 'properties': {'schema': {'type': 'string'}, 'account': {'type': 'string'}, 'catalog': {'type': 'string'}, 'row_limit': {'type': 'number'}, 'statement': {'type': 'string'}, 'parameters': {'type': 'array', 'items': {'type': 'object', 'required': ['name', 'value'], 'properties': {'name': {'type': 'string'}, 'type': {'type': 'string'}, 'value': {'type': 'string'}}}}, 'wait_timeout': {'type': 'string'}, 'warehouse_id': {'type': 'string'}, 'warehouse_ids': {'type': 'array', 'items': {'type': 'string'}}, 'on_wait_timeout': {'enum': ['CONTINUE', 'CANCEL'], 'type': 'string'}}}
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.
Accès externe
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'limit': {'type': 'number', 'default': 10}, 'query': {'type': 'string', 'default': ''}, 'action': {'enum': ['search', 'describe', 'install', 'uninstall', 'subscribe', 'cancel', 'resume', 'report_bug', 'request_mcp', 'list_tools', 'invoke', 'search_prompts', 'get_prompt', 'publish_prompt'], 'type': 'string', 'default': 'search'}, 'mcp_id': {'type': 'string', 'default': ''}, 'message': {'type': 'string', 'default': ''}, 'tool_id': {'type': 'string', 'default': ''}, 'arguments': {'type': 'string', 'default': '{}'}, 'immediate': {'type': 'boolean', 'default': False}, 'tier_slug': {'type': 'string', 'default': ''}, 'prompt_body': {'type': 'string', 'default': ''}, 'prompt_slug': {'type': 'string', 'default': ''}, 'prompt_tool': {'type': 'string', 'default': ''}, 'prompt_vars': {'type': 'string', 'default': '{}'}, 'conversation': {'type': 'string', 'default': '[]'}, 'prompt_title': {'type': 'string', 'default': ''}, 'request_name': {'type': 'string', 'default': ''}, 'cancel_reason': {'enum': ['too_expensive', 'missing_features', 'switched_service', 'unused', 'customer_service', 'too_complex', 'low_quality', 'other'], 'type': 'string'}, 'cancel_comment': {'type': 'string', 'default': ''}, 'prompt_targets': {'type': 'array', 'items': {'enum': ['claude', 'chatgpt', 'cursor', 'lovable'], 'type': 'string'}, 'default': []}, 'report_context': {'type': 'string', 'default': ''}, 'prompt_category': {'type': 'string', 'default': ''}, 'request_details': {'type': 'string', 'default': ''}, 'prompt_description': {'type': 'string', 'default': ''}}}
report_bug
Report a bug, missing feature, or send feedback. Include the conversation array with recent messages for reproduction.
Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['message'], 'properties': {'context': {'type': 'string', 'default': ''}, 'message': {'type': 'string'}, 'conversation': {'type': 'string', 'default': '[]'}}}
show_version
Show the current MCP platform and adapter versions.
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
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.
Lecture seule Idempotent
Schéma d’entrée
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
Ajouté
authenticate
17 September 2026 12:43
Ajouté
marketplace
17 September 2026 12:43
Ajouté
toolkit_info
17 September 2026 12:43
Ajouté
connect
17 September 2026 12:43
Ajouté
report_bug
17 September 2026 12:43
Ajouté
show_version
17 September 2026 12:43
Ajouté
databricks_get_table
17 September 2026 12:43
Ajouté
databricks_list_tables
17 September 2026 12:43
Ajouté
databricks_list_schemas
17 September 2026 12:43
Ajouté
databricks_list_catalogs
17 September 2026 12:43
Ajouté
databricks_cancel_statement
17 September 2026 12:43
Ajouté
databricks_get_statement
17 September 2026 12:43
Ajouté
databricks_run_sql
17 September 2026 12:43
Ajouté
databricks_get_warehouse
17 September 2026 12:43
Ajouté
databricks_list_warehouses
17 September 2026 12:43
Ajouté
databricks_current_user
17 September 2026 12:43
Ajouté
databricks_list_accounts
17 September 2026 12:43