Databricks Smart SQL
Created 5 months ago
MCP server for Databricks enabling AI agents to utilize Unity Catalog metadata.
What is Databricks Smart SQL?
Leveraging Databricks Unity Catalog metadata, perform smart efficient SQL queries to solve Ad-hoc queries and explore data.
Documentation
Databricks MCP Server
Motivation
Databricks Unity Catalog (UC) allows for detailed documentation of your data assets...
Overview
This Model Context Protocol (MCP) server is designed to interact with Databricks...
Practical Benefits of UC Metadata for AI Agents
The tools provided by this MCP server are designed to parse and present the descriptions...
Available Tools and Features
This MCP server provides a suite of tools designed to empower an LLM agent...
Setup# System Requirements
- Python 3.10+
Installation
- Install the required dependencies:
pip install -r requirements.txt
Permissions Requirements
Before using this MCP server, ensure that the identity associated with the DATABRICKS_TOKEN...
Running the Server# Standalone Mode
To run the server in standalone mode...
Example Usage Workflow (for an LLM Agent)
This MCP server empowers an LLM agent to autonomously navigate your Databricks environment...
Managing Metadata as Code with Terraform
While manually entering metadata through the Databricks UI is an option...
Handling Long-Running Queries
The execute_sql_query tool utilizes the Databricks SDK's execute_statement method...
Dependencies
databricks-sdk: For interacting with the Databricks REST APIs and Unity Catalog.
Server Config
{
"mcpServers": {
"databricks-smart-sql-server": {
"command": "npx",
"args": [
"databricks-smart-sql"
]
}
}
}