Databricks SQL FAQs

Question 1

What is Databricks SQL MCP Server?

Accepted Answer

The Databricks SQL MCP Server is a Model Context Protocol (MCP) server designed to enable AI assistants, such as Claude, to directly execute SQL queries and manage data within your Databricks SQL Warehouses.

Question 2

What are the prerequisites for setting up Databricks SQL MCP Server?

Accepted Answer

To use the server, you'll need Docker installed and running, access to a Databricks workspace with a SQL Warehouse, a Databricks personal access token, and either Claude Desktop or Claude Code (CLI) installed.

Question 3

What specific data operations can AI assistants perform using this tool?

Accepted Answer

AI assistants can perform a wide range of operations including executing any SQL query, listing databases, schemas, and tables, and describing table schemas with column names, types, and comments. It also offers full support for Databricks Unity Catalog.

Question 4

How easy is it to install and configure this tool?

Accepted Answer

Installation is streamlined with quick setup scripts available for Mac/Linux and Windows PowerShell. For those who prefer manual control, detailed instructions for Docker deployment and configuring Claude Desktop or Claude Code are also provided.

Question 5

How does Databricks SQL MCP Server integrate with Databricks Unity Catalog?

Accepted Answer

It provides comprehensive Unity Catalog support, allowing AI assistants to list catalogs, schemas within specific catalogs, and tables using full 3-part naming conventions (e.g., `catalog.schema.table`) for precise data exploration and management.

Databricks SQL

Databricks SQL

Key Features

Use Cases

Key Features

Use Cases