yunqiqiliang_mcp-clickzetta-server
1
The Clickzetta MCP Server is designed for database interaction with Clickzetta Lakehouse, featuring dynamic resource management and a suite of tools for executing SQL queries. It offers integration and security features for client applications like Claude Desktop.
Overview
A Model Context Protocol (MCP) server implementation that provides database interaction with Clickzetta Lakehouse. This server enables running SQL queries with tools and interacting with a memo of data insights presented as a resource.
Components
Resources
memo://insights: A continuously updated data insights memo aggregating discovered insights during analysis.
Tools
Query Tools
- Execute SELECT, INSERT, UPDATE, DELETE queries, and create new tables.
Schema Tools
- List all tables and view column information for a specific table.
Analysis Tools
- Add new data insights to the memo resource.
Usage
- Instructions include cloning the repository, installing the package, configuring credentials, and running the server.
Claude Desktop Integration
- Describes how to connect the server with Claude Desktop.
Security Considerations
- Enforces read-only operations and validates inputs to prevent SQL injection.