Clickzetta MCP Server

What is Clickzetta MCP Server?

Clickzetta MCP Server is a Model Context Protocol (MCP) server implementation that facilitates database interactions with Clickzetta Lakehouse, allowing users to run SQL queries and access a memo of data insights.

How to use Clickzetta MCP Server?

To use the Clickzetta MCP Server, clone the repository from GitHub, install the package, configure your credentials in a .env file, and run the server using the command uv run mcp_clickzetta_server.

Key features of Clickzetta MCP Server?

• Execute SQL queries (SELECT, INSERT, UPDATE, DELETE) on the database.
• Dynamic resource for continuously updated data insights.
• Tools for querying, schema management, and data analysis.

Use cases of Clickzetta MCP Server?

1. Running complex SQL queries to extract data insights.
2. Managing database schemas and tables.
3. Aggregating and analyzing data insights for reporting.

FAQ from Clickzetta MCP Server?

• Can I run write operations on the database?

Yes, but you need to use the --allow-write flag for write operations.

• Is there a way to visualize the data insights?

Yes, the server can be integrated with clients that support data visualization.

• How do I secure my credentials?

Ensure your .env file is kept secure and not committed to version control.