Frequently Asked Questions about Clickzetta MCP Server

Q: What is the Clickzetta MCP Server? A: 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.

Q: What is MCP? A: MCP stands for Model Context Protocol. It’s an open protocol that standardizes how applications provide context to LLMs (Large Language Models).

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

Q: What are the key features of the Clickzetta MCP Server? A: Key features include SQL query execution, schema exploration, a data insight memo, security considerations, and easy installation/configuration.

Q: What tools are available in the Clickzetta MCP Server? A: The server offers tools such as read_query, write_query, create_table, list_tables, describe-table, and append_insight.

Q: How do I install the Clickzetta MCP Server? A: You can install the server using various methods, including cloning from GitHub, using Smithery, or using UVX. Detailed instructions are provided in the documentation.

Q: How do I configure the server? A: You need to create a .env file with your Clickzetta Lakehouse credentials, including username, password, service, instance, workspace, and schema.

Q: What security measures are in place? A: 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.

Q: Can I write data to the database? A: Yes, but you need to use the --allow-write flag when running the server. This is disabled by default for security reasons.

Q: How does the Clickzetta MCP Server integrate with UBOS? A: 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.

Q: What is UBOS? A: 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.

Q: Where can I find more information? A: You can find more information in the server’s documentation on GitHub, Smithery, or UVX. Also, visit the UBOS website at https://ubos.tech for more about their platform.