databricks-mcp-server-by-cdata logo

databricks-mcp-server-by-cdata

by CDataSoftware

CData's Model Context Protocol (MCP) Server for Databricks allows LLMs to query live Databricks data. It exposes Databricks as relational SQL models through a simple MCP interface, enabling LLMs to retrieve information using natural language.

View on GitHub

Last updated: N/A

What is databricks-mcp-server-by-cdata?

This is a read-only MCP Server that wraps the CData JDBC Driver for Databricks, making Databricks data accessible through a simple MCP interface. It enables LLMs to retrieve live information by asking natural language questions without needing SQL.

How to use databricks-mcp-server-by-cdata?

  1. Clone the repository. 2. Build the server using Maven. 3. Download and license the CData JDBC Driver for Databricks. 4. Configure the connection to Databricks using the Connection String utility. 5. Create a .prp file with connection properties. 6. Configure your client (e.g., Claude Desktop) to use the MCP server.

Key features of databricks-mcp-server-by-cdata

  • Read-only access to Databricks data

  • MCP interface for easy integration with LLMs

  • Natural language querying

  • Uses CData JDBC Driver for Databricks

  • Exposes Databricks data as relational SQL models

Use cases of databricks-mcp-server-by-cdata

  • Allowing LLMs to answer questions about Databricks data

  • Integrating Databricks data into AI applications

  • Providing a natural language interface to Databricks data

  • Enabling data-driven decision making with LLMs

FAQ from databricks-mcp-server-by-cdata

What is the purpose of this server?

To allow LLMs to query live data from Databricks using natural language questions.

What is the CData JDBC Driver for Databricks?

It connects to Databricks and exposes it as relational SQL models.

How do I configure the connection to Databricks?

Use the Connection String utility provided with the CData JDBC Driver to create a connection string and then configure the connection in a .prp file.

How do I integrate this server with Claude Desktop?

Create or modify the claude_desktop_config.json file to include the MCP server configuration, specifying the path to the Java executable, the JAR file, and the .prp file.

What do I do if I cannot see the CData MCP Server in Claude Desktop?

Ensure that you have fully quit Claude Desktop and restarted it.