Overview
mcp-server-unitycatalog is a Model Context Protocol (MCP) server that bridges Unity Catalog with LLM-driven workflows. It exposes Unity Catalog Functions as MCP tools, enabling large language models to discover, inspect, create, delete, and execute catalog functions directly from prompts. The server centrally exposes all Unity Catalog Functions registered in Unity Catalog and ships with predefined tools: uc_list_functions, uc_get_function, uc_create_function (experimental), and uc_delete_function, with the capability to execute functions as MCP tools. The uc_create_function API is experimental and may change in future versions. Running the server is straightforward with uv, and configuration supports required Unity Catalog server, catalog, and schema, plus optional access token and verbosity. Configuration can be done via CLI options or environment variables: UC_SERVER, UC_CATALOG, UC_SCHEMA (required); UC_TOKEN (optional); UC_VERBOSITY (optional; default warn); UC_LOG_DIRECTORY (optional). The README shows usage patterns for Claude Desktop or VSCode CLI and Docker-based deployment; a Docker image (mcp/unitycatalog) is provided. Current progress includes list/get/create/execute/delete function support; semantic catalog explorer tools are not yet implemented. The project is MIT licensed.
Features
List Unity Catalog functions (uc_list_functions)
Lists functions within the specified parent catalog and schema; returns a list of functions retrieved from Unity Catalog.
Get function (uc_get_function)
Gets a function within a parent catalog and schema. Input: name (string). Returns: details of the function retrieved from Unity Catalog.
Create function (uc_create_function)
Creates a function within a parent catalog and schema. Input: name (string), script (string). Returns: details of the created function. NOTE: This API is experimental and will change in future versions.
Delete function (uc_delete_function)
Deletes a function within a parent catalog and schema. Input: name (string). Returns: None.
Execute function (execute_function)
Executes a Unity Catalog function as an MCP tool.
Docker image
Docker image is provided for quick deployment (mcp/unitycatalog).
Who Is This For?
- LLM developers:Expose Unity Catalog Functions as MCP tools to enable prompt-driven function discovery, invocation, and management within LLM workflows.
- Data engineers:Integrate Unity Catalog function management into data platforms via MCP for CRUD operations and function execution.
