@MCP-Mirror
Basic information
Mirror of
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"yunqiqiliang_mcp-clickzetta-server": {
"command": "uv",
"args": [
"pip",
"install",
"-e",
".",
"-i",
"https://pypi.tuna.tsinghua.edu.cn/simple/"
]
}
}
}Tool list not available yet
This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
A Model Context Protocol (MCP) server that provides database interaction with Clickzetta Lakehouse, enabling SQL query execution and management of a data insights memo. It is built for developers and analysts who need to query and analyze data in Clickzetta through AI assistants like Claude Desktop.
Install locally by cloning the repository and running uv pip install -e ., then configure credentials in a .env file. Start the stdio-based server with uv run mcp_clickzetta_server and integrate it into Claude Desktop's MCP Servers settings using the uv executable path. Optionally install via Smithery (npx -y @smithery/cli@latest install @yunqiqiliang/mcp-clickzetta-server) or UVX (uvx mcp_clickzetta_server with command-line arguments).
--allow-write flagcreate_table toolSix core tools: `read_query` for SELECT queries, `write_query` for modifications (with `--allow-write`), `create_table` (with `--allow-write`), `list_tables`, `describe-table` for schema inspection, and `append_insight` for adding insights to the memo.
Write operations (INSERT, UPDATE, DELETE, CREATE TABLE) require explicit `--allow-write` flag. The server automatically adds LIMIT clauses to prevent large result sets and uses service account authentication. Input validation guards against SQL injection.
A .env file must contain Clickzetta username, password, service URL, instance, workspace, schema, and vcluster. Keep this file secure and never commit it to version control.
The `memo://insights` resource aggregates data insights discovered during analysis. Insights are added via the `append_insight` tool, and the memo auto-updates as new insights are appended.
Use the `--exclude_tools` flag followed by tool name(s) when starting the server via UVX. Multiple tools can be excluded by repeating the argument.
Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3
A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi
PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct
Open-source MCP to use Blender with any LLM
A search tool helps dev to solve the naming things problem.
Comments