Clickzetta

About

Clickzetta is a Model Context Protocol (MCP) server implementation that facilitates interaction with Clickzetta Lakehouse. It allows users to execute SQL queries, manage tables, and access a continuously updated data insights memo. Integrated tools streamline querying, schema exploration, and insight generation, enhancing data analysis workflows within Claude Desktop or any compatible MCP client.

Key Features

• Provides tools for listing and describing database tables
• Supports both read and write operations (with `--allow-write` flag)
• Executes SQL queries (SELECT, INSERT, UPDATE, DELETE, CREATE TABLE)
• Offers a dynamic resource for accessing data insights
• Integrates with Claude Desktop

Use Cases

• Querying Clickzetta Lakehouse data for analysis
• Generating and managing data insights within a collaborative environment
• Integrating Clickzetta data sources with Claude Desktop for advanced analytics