aymenfurter/bricks-use
If you are the rightful owner of bricks-use and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A powerful Model Context Protocol (MCP) server for executing Databricks SQL queries and comparing table data.
The Model Context Protocol (MCP) server is designed to facilitate seamless execution of SQL queries and data comparison on Databricks. It provides a robust platform for users to interact with Databricks SQL, offering functionalities such as executing queries, retrieving table information, and comparing table data. The server is built with a focus on ease of use and integration, making it an ideal tool for data analysts and engineers working with Databricks. With its ability to handle complex SQL operations and provide detailed insights into table structures and data, the MCP server is a valuable asset for any data-driven organization. The server is compatible with Python 3.11 and above, ensuring it leverages the latest features and improvements of the Python ecosystem. Additionally, it supports integration with VS Code, allowing users to manage their Databricks interactions directly from their development environment.
Features
- Execute SQL Queries: Run any SQL query on Databricks with configurable result limits.
- Table Information: Get detailed information about tables including schema and row counts.
- Table Comparison: Compare two tables by downloading their data and running CLI diff.
- Quick Comparison: Fast metadata-only comparison of tables.
Tools
execute_query
Execute SQL queries with parameters like query and limit.
get_table_info
Retrieve metadata about a specific table.
compare_tables
Perform a full data comparison between two tables.
quick_compare_tables
Conduct a quick metadata-only comparison of two tables.