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.

How can I exclude tools?

Use the --exclude_tools flag followed by tool name(s) when starting the server via UVX. Multiple tools can be excluded by repeating the argument.

「その他」の他のコンテンツ

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

Peekaboo MCP – lightning-fast macOS screenshots for AI agents

steipete

Peekaboo is a macOS CLI & optional MCP server that enables AI agents to capture screenshots of applications, or the entire system, with optional visual question answering through local or remote AI models.

4.8K