hypequery ClickHouse — Claude Code MCP server: what it does
hypequery ClickHouse — an MCP server for Claude Code that connects agents to ClickHouse via governed datasets and metrics. It blocks raw SQL execution and hides direct database credentials.
no license ★ 106 updated 2026-11-16
claude mcp add mcp-server -- npx -y @hypequery/mcpWhat hypequery ClickHouse does
Exposes analytical schemas to assistants through four dedicated tools: list_datasets, get_dataset_schema, query_metric, and query_dataset. Models inspect predefined metrics and dimensions instead of constructing arbitrary database queries.
The server launches locally via a compiled Node.js configuration file or connects to an existing Python backend using hypequery.serve. When integrating with Python over HTTP, it requires HYPEQUERY_CLIENT_CONTRACT_URL and HYPEQUERY_API_KEY.
HTTP execution enforces a 30-second budget, a 1 MiB response ceiling, and a maximum of 1,000 returned rows. Internal database exceptions and underlying SQL syntax stay redacted behind MCP_EXECUTION_FAILED.
What it helps with
- block agents from running unconstrained SQL queries in ClickHouse
- calculate business KPIs using standardized metric definitions
- inspect schema structures and table relationships safely
- enforce strict data transfer caps and query execution timeouts
Example prompts for the agent
- List available ClickHouse datasets and their descriptions
- Query monthly revenue broken down by region using query_metric
- Inspect dimensions and measures for the Orders dataset
How to install hypequery ClickHouse
Platform CLI
claude mcp add mcp-server -- npx -y @hypequery/mcpPlatform CLI
codex mcp add mcp-server -- npx -y @hypequery/mcpConfig file
{
"mcpServers": {
"mcp-server": {
"command": "npx",
"args": [
"-y",
"@hypequery/mcp"
]
}
}
}Config file
{
"servers": {
"mcp-server": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@hypequery/mcp"
]
}
}
}Platform CLI
gemini mcp add mcp-server npx -y @hypequery/mcpStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about hypequery ClickHouse
How to install hypequery ClickHouse in Claude Code?
Run claude mcp add mcp-server -- npx -y @hypequery/mcp in your terminal.
What does hypequery ClickHouse do?
It bridges AI clients with ClickHouse through curated metrics and predefined datasets, keeping raw database credentials and arbitrary queries out of reach.
What is required to run hypequery ClickHouse?
It requires a compiled Node.js config file or a Python backend exposing the contract endpoint, alongside HYPEQUERY_CLIENT_CONTRACT_URL and HYPEQUERY_API_KEY.