広告掲載
MCP.so
ログイン

Clickzetta MCP Server

@MCP-Mirror

リポジトリ

基本情報

カテゴリ

その他

ライセンス

GPL-3.0 license

トランスポート

stdio

作者

MCP-Mirror

Clickzetta MCP Server について

Mirror of

Clickzetta MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

Clickzetta MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは 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

よくある質問

1

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.

2

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.

3

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.

4

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.

5

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.

コメント

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

N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

広告掲載