Overview
Features
Execute SQL Queries
Run arbitrary SQL queries using the Databricks SDK via execute_sql_query(sql: str) and return formatted results.
UC Catalog Discovery Tools
List and describe Unity Catalog assets (catalogs, schemas, and tables) to discover available data sources.
Schema and Table Description with Columns
Describe schemas and tables; optionally include column-level details for query construction.
Table Lineage and Code Discovery
Describe table lineage including upstream/downstream tables, notebooks, and jobs; enables code exploration of data transformations.
Markdown Output for LLMs
All descriptive tools return information in Markdown format optimized for consumption by LLMs.
Agent Workflow Support
Supports iterative agent workflows: catalog/schema discovery, table inspection, lineage analysis, and query execution.
Metadata-as-Code with Terraform
Illustrates managing Unity Catalog metadata as code with Terraform resources and import workflows.
Long-Running Query Handling
Notes a 50-second wait_timeout for SQL execution and how long-running queries are polled.
Who Is This For?
- LLM agents:Enable autonomous discovery of Unity Catalog metadata and lineage for SQL generation.
- Data engineers:Govern Unity Catalog assets and query lineage via MCP tooling and Terraform.
- Data scientists:Understand data context and transformation logic for exploratory analysis via notebooks.
- Cursor users:Integrate with Cursor to manage MCP workflows and agent queries.




