Koskamo

mcp-dir Databricks MCP

An MCP server that allows AI agents to interact with the Databricks Lakehouse via the official workspace REST API. It enables running SQL on SQL warehouses, tracking long-running queries, and exploring Unity Catalog structures like catalogs, schemas, tables, and columns using natural language prompts.

Endpoint and access

No sign-in to connect and list tools. Individual tools may still need a vendor account, credentials, or permissions; check the documented prerequisites.

mcp-dir Databricks MCP logo, by mcp-dirCommunity listingStreamable HTTPNo sign-inEndpoint checked 2026-11-07Published by mcp-dir
MCP endpoint (Streamable HTTP)
https://api.mcp.ai/p_databricks
Vendor documentation

What its tools do

17 tools, grouped by the hints the server advertises. Hints are self-declared, not verified behavior.

Read-only (12)

Can change data (5)

17 of 17 have a description · 17 of 17 declare behavior hints · 0 of 14 with parameters document them all

Checks and signals

Each line is separate evidence, not a trust score.

  • Passed Endpoint answered the live check ·
  • Availability 1 of 1 checks passed in 30 days

What you can do with it

  • List SQL warehouses in the Databricks workspace
  • Execute SQL queries on SQL warehouses
  • Explore Unity Catalog catalogs, schemas, and tables
  • Track status and results of long-running queries

Source and maintenance

Community listingRegistry 0.1.0
mcp-registry: io.github.mcp-dir/databricks-mcp@0.1.0Source repository
Maintenance checked

Protocol and capabilities

Server
mcp-ai 0.9.410
MCP protocol negotiated in check
2025-11-25
Tools
17 advertised
Resources
Not advertised
Resource templates
Not advertised
Prompts
Not advertised
Server-advertised capabilities
{
  "tools": {
    "listChanged": true
  }
}

Server-provided instructions

Untrusted server output shown for inspection. It is not Koskamo guidance and is excluded from knowledge search.

MCP.AI platform v0.9.410 | Adapters: databricks vunknown. When the user asks about the version (e.g. "qual a versão", "which version"), call the show_version tool. NEW MCPs/tools/integrations (capabilities not already in this toolkit) come from the official mcp.ai catalog: the `marketplace` tool (action=search) finds and runs them. You are not authenticated yet. Call the authenticate tool first — it will give the user a browser link to log in and copy a token. No other tools will work until authenticated.

Tools

17 advertised

databricks_list_accounts
Advertised by the server during the last successful anonymous check.
Advertised read-only

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

databricks_list_accounts input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "properties": {
    "account": {
      "type": "string"
    }
  }
}
databricks_list_accounts annotations
{
  "title": "databricks_list_accounts",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
databricks_current_user
Advertised by the server during the last successful anonymous check.
Advertised read-only

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

databricks_current_user input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "properties": {
    "account": {
      "type": "string"
    }
  }
}
databricks_current_user annotations
{
  "title": "databricks_current_user",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
databricks_list_warehouses
Advertised by the server during the last successful anonymous check.
Advertised read-only

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).

databricks_list_warehouses input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "properties": {
    "account": {
      "type": "string"
    }
  }
}
databricks_list_warehouses annotations
{
  "title": "databricks_list_warehouses",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
databricks_get_warehouse
Advertised by the server during the last successful anonymous check.
Advertised read-only

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

databricks_get_warehouse input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "required": [
    "ids"
  ],
  "properties": {
    "ids": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "account": {
      "type": "string"
    }
  }
}
databricks_get_warehouse annotations
{
  "title": "databricks_get_warehouse",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
databricks_run_sql
Advertised by the server during the last successful anonymous check.

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.

databricks_run_sql input schema
{
  "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"
    }
  }
}
databricks_run_sql annotations
{
  "title": "databricks_run_sql",
  "readOnlyHint": false,
  "openWorldHint": false,
  "idempotentHint": false,
  "destructiveHint": false
}
databricks_get_statement
Advertised by the server during the last successful anonymous check.
Advertised read-only

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

databricks_get_statement input schema
{
  "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_statement annotations
{
  "title": "databricks_get_statement",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
databricks_cancel_statement
Advertised by the server during the last successful anonymous check.

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

databricks_cancel_statement input schema
{
  "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_cancel_statement annotations
{
  "title": "databricks_cancel_statement",
  "readOnlyHint": false,
  "openWorldHint": false,
  "idempotentHint": false,
  "destructiveHint": false
}
databricks_list_catalogs
Advertised by the server during the last successful anonymous check.
Advertised read-only

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

databricks_list_catalogs input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "properties": {
    "account": {
      "type": "string"
    }
  }
}
databricks_list_catalogs annotations
{
  "title": "databricks_list_catalogs",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
databricks_list_schemas
Advertised by the server during the last successful anonymous check.
Advertised read-only

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

databricks_list_schemas input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "required": [
    "catalog_name"
  ],
  "properties": {
    "account": {
      "type": "string"
    },
    "catalog_name": {
      "type": "string"
    }
  }
}
databricks_list_schemas annotations
{
  "title": "databricks_list_schemas",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
databricks_list_tables
Advertised by the server during the last successful anonymous check.
Advertised read-only

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

databricks_list_tables input schema
{
  "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_tables annotations
{
  "title": "databricks_list_tables",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
databricks_get_table
Advertised by the server during the last successful anonymous check.
Advertised read-only

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

databricks_get_table input schema
{
  "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_table annotations
{
  "title": "databricks_get_table",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
show_version
Advertised by the server during the last successful anonymous check.
Advertised read-only

Show the current MCP platform and adapter versions.

show_version input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "properties": {}
}
show_version annotations
{
  "title": "Show Version",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
report_bug
Advertised by the server during the last successful anonymous check.

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

report_bug input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "required": [
    "message"
  ],
  "properties": {
    "context": {
      "type": "string",
      "default": ""
    },
    "message": {
      "type": "string"
    },
    "conversation": {
      "type": "string",
      "default": "[]"
    }
  }
}
report_bug annotations
{
  "title": "Report Bug",
  "readOnlyHint": false,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
connect
Advertised by the server during the last successful anonymous check.
Advertised read-only

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.

connect input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "properties": {}
}
connect annotations
{
  "title": "Connection Status",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
toolkit_info
Advertised by the server during the last successful anonymous check.
Advertised read-only

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

toolkit_info input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "properties": {}
}
toolkit_info annotations
{
  "title": "Toolkit Info",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
marketplace
Advertised by the server during the last successful anonymous check.
Open-world

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.

marketplace input schema
{
  "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": ""
    }
  }
}
marketplace annotations
{
  "title": "Marketplace",
  "readOnlyHint": false,
  "openWorldHint": true,
  "idempotentHint": false,
  "destructiveHint": false
}
authenticate
Advertised by the server during the last successful anonymous check.

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.

authenticate input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "properties": {
    "token": {
      "type": "string"
    }
  }
}
authenticate annotations
{
  "title": "Authenticate",
  "readOnlyHint": false,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}

Prompts

Not advertised

No prompt definitions available.

Resources

Not advertised

No resource definitions available.

30-day availability

Aggregated from read-only remote checks; this is not a tool-execution or security guarantee.

Successful checks
1 of 1 (100%)
Average latency
987 ms
95th percentile latency
987 ms

Maintenance history

Public check and source-refresh events. Editorial and ownership records remain private.

  • · probe · passed · 987 ms · metadata changed · 17 tool(s)

Connect from your client

Each snippet registers the same endpoint; pick the client you use.

This server is operated by the named third party. Listing and endpoint checks are not an endorsement or a security audit. Review the operator's permissions, terms, and data handling before connecting. How listings are checked and corrected.

Claude Code

Run this once in a terminal. It registers the remote server. Use --scope project to write .mcp.json for the repo.
Claude Code configuration
claude mcp add --transport http databricks-mcp https://api.mcp.ai/p_databricks

Codex

Run this once. Codex stores MCP servers in ~/.codex/config.toml (or .codex/config.toml in a trusted project).
Codex configuration
codex mcp add databricks-mcp --url https://api.mcp.ai/p_databricks

Cursor

Merge this server into .cursor/mcp.json in your project, then enable databricks-mcp in your MCP settings.
Cursor configuration
{
  "mcpServers": {
    "databricks-mcp": {
      "url": "https://api.mcp.ai/p_databricks"
    }
  }
}

Cline

Merge this into cline_mcp_settings.json (Cline → MCP Servers → Configure).
Cline configuration
{
  "mcpServers": {
    "databricks-mcp": {
      "type": "streamableHttp",
      "url": "https://api.mcp.ai/p_databricks",
      "disabled": false
    }
  }
}

VS Code

Merge this server into .vscode/mcp.json. Use MCP: List Servers to start databricks-mcp and inspect its tools.
VS Code configuration
{
  "servers": {
    "databricks-mcp": {
      "type": "http",
      "url": "https://api.mcp.ai/p_databricks"
    }
  }
}

Gemini CLI

Run this once. It writes .gemini/settings.json in the current project; pass --scope user for ~/.gemini/settings.json.
Gemini CLI configuration
gemini mcp add --transport http databricks-mcp https://api.mcp.ai/p_databricks

Claude Desktop

Open Claude Settings > Connectors > Add custom connector, enter this server URL and enable it for the conversation. This is a manual remote-connector handoff, not a desktop JSON configuration.
Claude Desktop configuration
https://api.mcp.ai/p_databricks

Windsurf

Merge this into ~/.codeium/windsurf/mcp_config.json, then refresh MCP in Cascade. Windsurf remote servers use serverUrl, not url.
Windsurf configuration
{
  "mcpServers": {
    "databricks-mcp": {
      "serverUrl": "https://api.mcp.ai/p_databricks"
    }
  }
}

Let your agent find its tools

Find servers like mcp-dir Databricks MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.

Connect Koskamo Explore workflows
See all 6,981