Clickzetta MCP ServerServer

yunqiqiliang
GitHub
SQLDatabaseAI

Loading subscription status...

💡 Description

A Model Context Protocol server that enables interaction with Clickzetta Lakehouse for executing SQL queries and managing databases, as well as maintaining dynamic data analysis memos.

📝 JSON Entries

{
  "mcpServers": [
    {
      "clickzetta-mcp-server": {
        "env": {
          "CLICKZETTA_SCHEMA": "your clickzetta schema",
          "CLICKZETTA_SERVICE": "api.clickzetta.com",
          "Similar_table_name": "clickzegithub_event_issuesevent_embedding.github_event_issuesevent_embedding_512tta_table",
          "CLICKZETTA_INSTANCE": "your clickzetta instance",
          "CLICKZETTA_PASSWORD": "your clickzetta password",
          "CLICKZETTA_USERNAME": "your clickzetta username",
          "CLICKZETTA_VCLUSTER": "your clickzetta vcluster",
          "CLICKZETTA_WORKSPACE": "your clickzetta workspace",
          "Similar_partition_scope": "partition_date >= '2024-01-01' and partition_date <= '2024-01-15'",
          "Similar_content_column_name": "issue_body",
          "Similar_embedding_column_name": "issue_body_embedding"
        },
        "args": [
          "run",
          "-i",
          "--rm",
          "-e",
          "LOG_LEVEL=INFO",
          "-e",
          "CLICKZETTA_SERVICE",
          "-e",
          "CLICKZETTA_INSTANCE",
          "-e",
          "CLICKZETTA_WORKSPACE",
          "-e",
          "CLICKZETTA_SCHEMA",
          "-e",
          "CLICKZETTA_USERNAME",
          "-e",
          "CLICKZETTA_PASSWORD",
          "-e",
          "CLICKZETTA_VCLUSTER",
          "-e",
          "Similar_table_name",
          "-e",
          "Similar_embedding_column_name",
          "-e",
          "Similar_content_column_name",
          "-e",
          "Similar_partition_scope",
          "czqiliang/mcp-clickzetta-server:latest"
        ],
        "command": "docker"
      }
    }
  ]
}

🛠 Tools

QueryToolAnalysisToolDataImportTool

⚡ Features

  • SQL query execution
  • Database management
  • Dynamic data analysis memos

💬 Example Queries

  • Can you list all schemas in my Clickzetta account?
  • Show me the structure of the view CUSTOMER_ANALYTICS in the SALES schema.
  • What is the sample data for the view REVENUE_BY_REGION in the FINANCE schema?