Databricks SQL

About

This tool serves as a Model Context Protocol (MCP) server, allowing AI assistants like Claude to seamlessly interact with Databricks SQL Warehouses. By running as a Docker container and communicating over stdin/stdout, it provides a robust set of functionalities for querying data, listing databases, schemas, and tables, and describing table structures within Databricks, including full support for Unity Catalog's hierarchical naming conventions. It empowers AI to perform complex data operations and retrieval on Databricks with minimal setup.

Key Features

• 1 GitHub stars
• Execute any SQL query against a Databricks SQL Warehouse
• List databases, schemas, and tables in Databricks
• Describe table schemas, including column names, types, and comments
• Full support for Unity Catalog: list catalogs, schemas, and tables using 3-part naming
• Easy installation via Docker and quick setup scripts for Mac/Linux and Windows PowerShell

Use Cases

• Allowing AI assistants to browse and understand the data landscape within Databricks Unity Catalog.
• Enabling AI to execute ad-hoc SQL queries and retrieve specific data from Databricks SQL Warehouses.
• Integrating Databricks data querying capabilities directly into AI-driven workflows for data analysis and reporting.