What is Databricks Genie API MCP Server?
It is a Model Context Protocol (MCP) server that exposes Databricks Genie API capabilities as tools. It enables integration of Databricks' no-code AI/BI assistant with other applications, allowing natural language querying of Databricks data through a standardized interface.
How to use Databricks Genie API MCP Server?
Install Python 3.10+, clone the repository, navigate to genie_api/, install dependencies (pip install -r requirements.txt), and configure authentication via a .env file with Databricks host and credentials (PAT or OAuth). Run python server.py locally. Then configure an MCP client like Claude Desktop to launch the server using the absolute path to server.py and the correct working directory.
Key features of Databricks Genie API MCP Server
- Expose Databricks Genie API functions as MCP tools.
- Enable natural language querying of Databricks data.
- Start and manage Genie conversations.
- Create and retrieve messages.
- Execute and fetch SQL query results from Genie.
- Secure authentication with Databricks.
Use cases of Databricks Genie API MCP Server
- Query Databricks system tables using natural language (e.g., "What was our DBU consumption last month?").
- Investigate data access logs (e.g., "Who accessed the PII table yesterday?").
- Integrate Databricks Genie assistant into custom MCP-compatible client applications.
- Automate data exploration and reporting via conversational interfaces.
コメント