MCP connector · Data warehouse

ClickHouse-fast answers for your AI

ClickHouse crunches billions of rows in milliseconds; mcpMyAdmin makes that power safely available to Claude, ChatGPT, and any MCP client. A native HTTP adapter runs governed, read-only single-statement SQL with everything audited.

  • Free 7-day trial — 14 days for teams
  • Not charged until your trial ends
  • Cancel anytime
Capabilities

What you get with ClickHouse

Everything below is enforced server-side — the AI client only ever sees governed tools and their results.

  • Live read-only SQL over ClickHouse's native HTTP interface (default port 8123; flip SSL + port for TLS endpoints)
  • Schema browsing across databases, tables, and column types
  • Data Sets refreshed on an interval or cron, with incremental refresh
  • Opt-in writes on connections you own — off by default, fully audited
  • SSRF-guarded, IP-pinned dialing and AES-256-GCM encrypted credentials
  • OAuth 2.1 + PKCE for every MCP client, plus read-only team sharing
How it works

From sign-up to querying ClickHouse in minutes

No infrastructure to stand up — connect, authorize, and start asking questions.

  1. 01

    Start your free trial.

  2. 02

    Add the ClickHouse connection — self-hosted (port 8123) or ClickHouse Cloud (HTTPS port 8443 with SSL on) — using a read-only user.

  3. 03

    Connect Claude, ChatGPT, or another MCP client over OAuth 2.1 + PKCE.

  4. 04

    Let your AI run analytical SQL live, or snapshot heavy aggregations into Data Sets.

FAQ

ClickHouse + mcpMyAdmin, answered

More connectors

Related engines

mcpMyAdmin connects to relational databases, warehouses, NoSQL stores, and SaaS sources — all through one governed MCP server.

Put ClickHouse to work for your AI today

Governed access, encrypted credentials, and a full audit trail — up and running in minutes, free while you try it.

Start your free trial