Skip to main content
MCP server CX Codex

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

Install into Claude Code · Platform CLI All methods and platforms ↓
claude mcp add mcp-server -- npx -y @hypequery/mcp
Open on GitHub

What 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/mcp

Step 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.

Similar MCP servers

All MCP servers for Data and databases →

Project sponsors

Companies that keep this analytics open