Clickzetta MCP Server

by MCP-Mirror

126 downloads

Not rated

GitHub

Other

About

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…

Details

Author: MCP-Mirror
Downloads: 126
Categories: Other

- 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

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name Clickzetta MCP Server

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

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

JSON

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

JSON

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

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

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

JSON

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

JSON

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

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

From the repository

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).

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

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

McpServers

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

Clickzetta MCP Server

Overview

A Model Context Protocol (MCP) server implementation that provides database interaction with Clickzetta Lakehouse. This server enables running SQL queries with tools and intereacting with a memo of data insights presented as a resource.

Components

Resources

The server exposes a single dynamic resource: - memo://insights: A continuously updated data insights memo that aggregates discovered insights during analysis - Auto-updates as new insights are discovered via the append-insight tool

Tools

The server offers six core tools:

Query Tools

- read_query - Execute SELECT queries to read data from the database - Input: - query (string): The SELECT SQL query to execute - Returns: Query results as array of objects

- write_query (with --allow-write flag)
- Execute INSERT, UPDATE, or DELETE queries
- Input:
- query (string): The SQL modification query
- Returns: { affected_rows: number }

- create_table (with --allow-write flag)
- Create new tables in the database
- Input:
- query (string): CREATE TABLE SQL statement
- Returns: Confirmation of table creation

Schema Tools

- list_tables - Get a list of all tables in the database - No input required - Returns: Array of table names

- describe-table
- View column information for a specific table
- Input:
- table_name (string): Name of table to describe (can be fully qualified)
- Returns: Array of column definitions with names and types

Analysis Tools

- append_insight - Add new data insights to the memo resource - Input: - insight (string): data insight discovered from analysis - Returns: Confirmation of insight addition - Triggers update of memo://insights resource

Usage with Claude Desktop

Installing as local MCP Server(This way has been tested and verified on MacOS)

Clone this repository:

git clone https://github.com/yunqiqiliang/mcp-clickzetta-server.git
cd mcp-clickzetta-server

Install the package:

uv pip install -e . -i https://pypi.tuna.tsinghua.edu.cn/simple/

Config credentials

Create a .env file based on .env.example with your Clickzetta Lakehouse credentials:

CLICKZETTA_USERNAME = ""
CLICKZETTA_PASSWORD = ""
CLICKZETTA_SERVICE = "api.clickzetta.com"
CLICKZETTA_INSTANCE = ""
CLICKZETTA_WORKSPACE = ""
CLICKZETTA_SCHEMA = ""
CLICKZETTA_VCLUSTER = ""
XINFERENCE_BASE_URL = "http://:9998"
XINFERENCE_EMBEDDING_MODEL_512 = "bge-small-zh"
Similar_table_name = "github_event_issuesevent_embedding.github_event_issuesevent_embedding_512"
Similar_embedding_column_name = "issue_body_embedding"
Similar_content_column_name = "issue_body"
Similar_partition_scope = "partition_date  >= '2024-01-01' and partition_date  <= '2024-01-15'"

Usage

Running with uv

After installing the package, you can run the server directly with:

uv run mcp_clickzetta_server

If this is the first time you are running the server, you could run the following command to acclerate the package installation:

UV_INDEX_URL=https://pypi.tuna.tsinghua.edu.cn/simple/ uv run mcp_clickzetta_server

This will start the stdio-based MCP server, which can be connected to Claude Desktop or any MCP client that supports stdio communication.

You should see output similar to:

uv run mcp_clickzetta_server --no-prefetch 2025-03-25 10:11:20,799 - mcp_clickzetta_server - INFO - Starting Clickzetta MCP Server 2025-03-25 10:11:20,799 - mcp_clickzetta_server - INFO - Allow write operations: False 2025-03-25 10:11:20,799 - mcp_clickzetta_server - INFO - Prefetch table descriptions: True 2025-03-25 10:11:20,799 - mcp_clickzetta_server - INFO - Excluded tools: [] 2025-03-25 10:11:20,799 - mcp_clickzetta_server - INFO - Prefetching table descriptions 2025-03-25 10:11:21,726 - clickzetta.zettapark.session - INFO - Zettapark Session information: "version" : 0.1.3, "python.version" : 3.12.2, "python.connector.version" : 0.8.89.0, "python.connector.session.id" : dd46bd27-920d-4760-94a6-6f994d31e63e, "os.name" : Darwin
2025-03-25 10:11:21,728 - clickzetta.connector.v0.client - INFO - clickzetta connector submitting job, id:2025032510112172821098301 2025-03-25 10:11:23,059 - clickzetta.connector.v0.client - INFO - clickzetta connector submitting job, id:2025032510112305897947697 2025-03-25 10:11:23,728 - mcp_clickzetta_server - INFO - Allowed tools: ['read_query', 'append_insight'] 2025-03-25 10:11:23,732 - mcp_clickzetta_server - INFO - Server running with stdio transport

Claude Desktop Integration
- In Claude Desktop, go to Settings → MCP Servers - Add a new server with the full path to your uv executable:

{
   "mcpServers": {
      "clickzetta-mcp-server" : {
         "command": "/Users/*/anaconda3/bin/uv",
         "args": [
            "--directory",
            "/Users//Documents/GitHub/mcp-clickzetta-server",
            "run",
            "mcp_clickzetta_server"
         ]
      }
   }
}

- You can find your uv path by running which uv in your terminal
- Save the server configuration

Example Queries

When using with Claude, you can ask questions like:

- "Can you list all the schemas in my Clickzetta account?"
- "List all views in the PUBLIC schema"
- "Describe the structure of the CUSTOMER_ANALYTICS view in the SALES schema"
- "Show me sample data from the REVENUE_BY_REGION view in the FINANCE schema"
- "Run this SQL query: SELECT customer_id, SUM(order_total) as total_spend FROM SALES.ORDERS GROUP BY customer_id ORDER BY total_spend DESC LIMIT 10"
- "Query the MARKETING database to find the top 5 performing campaigns by conversion rate"
- "帮我从Clickzetta中读取数据，分析下在public这个schema下github_users表里每个公司的用户数。请用中文返回结果，并对结果进行数据可视化展现"
- "帮我从Clickzetta中读取数据，分析下在public这个schema下github_event_issuesevent表里有多少条记录？"

Example Result

- '帮我从Clickzetta数据源中读取数据，先分析基于public这个schema下github_users表里的数据可以做哪些分析？包括指标、统计、趋势、以及各种经典的用户分析模型比如用户价值分析、用户生命周期分析、用户segment等，然后根据这些分析内容生成一个分析报告的dashboard'

- The result of "帮我从Clickzetta中读取数据，分析下在public这个schema下github_users表里每个公司的用户数。请用中文返回结果，并对结果进行数据可视化展现":

- The result of "帮我从Clickzetta中读取数据，分析下在public这个schema下github_users表里每个位置的用户数。请用中文返回结果，并对结果进行数据可视化展现":

Security Considerations
This server:
- Enforces read-only operations (only SELECT statements are allowed)
- Automatically adds LIMIT clauses to prevent large result sets
- Uses service account authentication for secure connections
- Validates inputs to prevent SQL injection
- ⚠️ Important: Keep your .env file secure and never commit it to version control. The .gitignore file is configured to exclude it.

Installing via Smithery(This way is tobe tested and verified)

To install Clickzetta Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli@latest install @yunqiqiliang/mcp-clickzetta-server --client claude --key *

Installing via UVX(This way is tobe tested and verified)

```python

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

McpServers

Clickzetta MCP Server

Overview

Components

Resources

Tools

Query Tools

Schema Tools

Analysis Tools

Usage with Claude Desktop

Installing as local MCP Server(This way has been tested and verified on MacOS)

Clone this repository:

Install the package:

Config credentials

Usage

Running with uv

Claude Desktop Integration

Example Queries

Example Result

Security Considerations

Installing via Smithery(This way is tobe tested and verified)

Installing via UVX(This way is tobe tested and verified)

Install

More like this

Sequential Thinking

Filesystem

EverArt

Google Drive

Reactive Resume

FastMCP v2 🚀