Clickzetta Server
An MCP server bridging to ClickZetta databases for executing SQL queries, exploring schema information, and documenting insights via natural language interaction.
About this tool
Clickzetta Server
A Model Context Protocol (MCP) server for interacting with ClickZetta Lakehouse databases, enabling SQL query execution, schema exploration, and documentation of data insights via natural language interfaces.
Features
- MCP Server Implementation: Acts as a bridge between MCP clients and ClickZetta Lakehouse databases.
- SQL Query Execution:
read_query: Execute read-only SQL queries.write_query: Execute write SQL queries when enabled with--allow-write.create_table: Create tables in the database (requires--allow-write).
- Schema Exploration:
list_tables: List all available tables in the database.describe-table: Get schema details for a specific table.
- Data Insights Memo: Interact with a memo resource that documents and presents insights from the database.
- Natural Language Interaction: Designed for use with tools like Claude Desktop, allowing users to ask questions in natural language and receive insights or query results.
- Stdio Communication: Runs as a local server and communicates with MCP clients over standard input/output.
- Credential Management: Requires configuration of ClickZetta Lakehouse credentials via a
.envfile. - Integration: Can be integrated with Claude Desktop and potentially other MCP-compatible clients.
- Installation Methods:
- Via direct package installation (tested on MacOS).
- Planned/experimental support for installation via Smithery and UVX.
Pricing
No pricing information is provided; the source code is available as an open source project.
Source
Loading more......
Information
Categories
Tags
Similar Products
6 result(s)A Model Context Protocol server enabling LLMs to interact with SQLite and SQL Server databases, supporting schema inspection and SQL query execution, as an exemplary database MCP server.
A Model Context Protocol server for MongoDB, enabling LLMs to query, insert, delete, and aggregate documents via natural language—demonstrating MCP server database integration.
An MCP Server for Microsoft Azure SQL Database, allowing Model Context Protocol clients to interact with managed Azure SQL databases in the cloud.
An MCP Server for bit.io, providing Model Context Protocol access to bit.io’s zero‑config, shareable cloud databases.
Provides a JSON-RPC interface to Datomic databases through the MCP protocol, enabling schema exploration and Datalog query execution. This makes it a specialized MCP server for interacting with Datomic.
A Model Context Protocol (MCP) implementation for connecting to and working with various database systems, serving as a versatile MCP server.