Clickzetta MCP Server

Name: Clickzetta MCP Server
Author: MCP-Mirror

@MCP-Mirror

代码仓库

关于 Clickzetta MCP Server

Mirror of

基本信息

分类

其他

许可证

GPL-3.0 license

运行时

python

传输方式

stdio

发布者

MCP-Mirror

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "yunqiqiliang_mcp-clickzetta-server": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "-e",
        ".",
        "-i",
        "https://pypi.tuna.tsinghua.edu.cn/simple/"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Clickzetta MCP Server?

A Model Context Protocol (MCP) server that provides database interaction with Clickzetta Lakehouse, enabling SQL query execution and management of a data insights memo. It is built for developers and analysts who need to query and analyze data in Clickzetta through AI assistants like Claude Desktop.

How to use Clickzetta MCP Server?

Install locally by cloning the repository and running uv pip install -e ., then configure credentials in a .env file. Start the stdio-based server with uv run mcp_clickzetta_server and integrate it into Claude Desktop's MCP Servers settings using the uv executable path. Optionally install via Smithery (npx -y @smithery/cli@latest install @yunqiqiliang/mcp-clickzetta-server) or UVX (uvx mcp_clickzetta_server with command-line arguments).

Key features of Clickzetta MCP Server

Execute SELECT queries to read database data
Perform INSERT, UPDATE, DELETE with --allow-write flag
Create new tables via create_table tool
List all tables and describe table schemas
Append data insights to a continuously updated memo resource
Read-only operations enforced by default with auto-added LIMIT clauses

Use cases of Clickzetta MCP Server

Querying Clickzetta Lakehouse data through natural language via Claude Desktop
Exploring table schemas and relationships across schemas
Building analysis reports and dashboards from query results
Documenting data insights in a persistent memo that updates automatically

FAQ from Clickzetta MCP Server

What tools does Clickzetta MCP Server provide?

Six core tools: read_query for SELECT queries, write_query for modifications (with --allow-write), create_table (with --allow-write), list_tables, describe-table for schema inspection, and append_insight for adding insights to the memo.

What are the security precautions?

Write operations (INSERT, UPDATE, DELETE, CREATE TABLE) require explicit --allow-write flag. The server automatically adds LIMIT clauses to prevent large result sets and uses service account authentication. Input validation guards against SQL injection.

What credentials are required?

A .env file must contain Clickzetta username, password, service URL, instance, workspace, schema, and vcluster. Keep this file secure and never commit it to version control.

How does the memo resource work?

The memo://insights resource aggregates data insights discovered during analysis. Insights are added via the append_insight tool, and the memo auto-updates as new insights are appended.