Yunqiqiliang MCP Clickzetta Server

🚀 Click-to-Get Data - Clickzetta Data Source Integration Guide

This guide provides a comprehensive introduction to integrating the Clickzetta data source in Claude Desktop, enabling efficient data analysis and visualization.

🚀 Quick Start

Clickzetta is a platform that offers a variety of data analysis services. The following will detail how to integrate the Clickzetta data source in Claude Desktop for data analysis and visualization.

📦 Installation

Installing the Clickzetta MCP Server Using a USB Drive

The specific steps are as follows:

1. Clone the code repository to your local machine:

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

2. Configure environment variables:

   • Create and edit the .env file, and fill in your Clickzetta account information:

     SERVICE_NAME=the_service
     INSTANCE_ID=the_instance
     VCENTER_NAME=the_vcluster
     WORKSPACE_NAME=the_workspace
     SCHEMA_NAME=the_schema
     USER_NAME=the_user
     PASSWORD=the_password
     

3. Start the MCP service:

   uv run mcp_clickzetta_server --directory ./mcp-clickzetta-server
   

4. Configure the server connection in Claude Desktop:

   • Open the Claude settings interface → Click on the "MCP Server" section.
   • Add a new server configuration and fill in the following information:

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

   • After saving the configuration, the server will take effect.

Other Installation Methods

Automated Installation Using Smithery

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

Configuration Using UVX

Add the server configuration to claude_desktop_config.json:

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

💻 Usage Examples

Basic Usage

In Claude Desktop, you can execute the following types of queries:

• Simple Queries:

  • "List all databases under my Clickzetta account."
  • "Show the table structure in the PUBLIC database."

• Complex Analysis:

  • "Help me read data from Clickzetta, analyze the number of users per company in the github_users table under the public schema. Return the results in Chinese and visualize the results."

• SQL Execution:

  SELECT customer_id, SUM(order_total) as total_spend FROM SALES.ORDERS GROUP BY customer_id ORDER BY total_spend DESC LIMIT 10;
  

🔧 Technical Details

This server implements the following security measures:

• Read-only Operations: By default, only SELECT statements are supported.
• Result Set Limitation: Automatically adds a LIMIT clause to prevent large data volume returns.
• Authentication: Uses a service account for connection authentication.
• Input Validation: Guards against SQL injection attacks.
• Logging: Provides optional log directory and log level configuration.

📚 Documentation

Image and Table Explanations

• Example Screenshots:

  • Configuration interface screenshot:
  • Query result display:

• Comparison Table: | Property | Details | |----------|---------| | Security Level | Level A (High Security) | | Supported Protocols | HTTP/HTTPS | | Maximum Number of Connections | Unlimited |

📄 Summary

Through the above steps, you can easily integrate the Clickzetta data source into Claude Desktop for efficient data analysis and visualization. If you have any questions, please refer to the official documentation or contact the technical support team.