Question 1

What is the Clickzetta MCP Server?

Accepted Answer

The Clickzetta MCP Server is an implementation of the Model Context Protocol (MCP) that allows AI models to interact with a Clickzetta Lakehouse. It provides tools for running SQL queries, accessing data insights, and integrating with platforms like Claude Desktop and UBOS.

Question 2

What is MCP?

Accepted Answer

MCP stands for Model Context Protocol. It's an open protocol that standardizes how applications provide context to LLMs (Large Language Models).

Question 3

What is Clickzetta Lakehouse?

Accepted Answer

Clickzetta Lakehouse is a data warehouse solution that unifies data storage and processing, enabling organizations to analyze and gain insights from their data.

Question 4

What are the key features of the Clickzetta MCP Server?

Accepted Answer

Key features include SQL query execution, schema exploration, a data insight memo, security considerations, and easy installation/configuration.

Question 5

What tools are available in the Clickzetta MCP Server?

Accepted Answer

The server offers tools such as `read_query`, `write_query`, `create_table`, `list_tables`, `describe-table`, and `append_insight`.

Question 6

How do I install the Clickzetta MCP Server?

Accepted Answer

You can install the server using various methods, including cloning from GitHub, using Smithery, or using UVX. Detailed instructions are provided in the documentation.

Question 7

How do I configure the server?

Accepted Answer

You need to create a `.env` file with your Clickzetta Lakehouse credentials, including username, password, service, instance, workspace, and schema.

Question 8

What security measures are in place?

Accepted Answer

The server enforces read-only operations by default, automatically adds LIMIT clauses to prevent large result sets, uses service account authentication, and validates inputs to prevent SQL injection.

Question 9

Can I write data to the database?

Accepted Answer

Yes, but you need to use the `--allow-write` flag when running the server. This is disabled by default for security reasons.

Question 10

How does the Clickzetta MCP Server integrate with UBOS?

Accepted Answer

Integrating with UBOS allows you to build, orchestrate, and deploy AI agents that can interact with your Clickzetta data. UBOS provides a full-stack AI Agent development platform for creating intelligent AI solutions.

Question 11

What is UBOS?

Accepted Answer

UBOS is a Full-stack AI Agent Development Platform focused on bringing AI Agents to every business department. It helps orchestrate AI Agents, connect them with your enterprise data, build custom AI Agents with your LLM model and Multi-Agent Systems.

Clickzetta Server

Resources

Project Details

Recomended MCP Servers

Featured Templates

Pharmacy Admin Panel

Calculate Time Complexity with ChatGPT API

Python Bug Fixer

AI-Powered Product List Manager

Unified Authorization Template

Image Generation with Stable Diffusion

Start your free trial