Connect ClickHouse MCP to your AI Agents

Real-time analytics on ClickHouse at any scale, in plain English.

Example prompts

Everything you can ask your agent about your ClickHouse data.

Ask in plain English — Sequel translates it into a ClickHouse query, runs it, and your agent hands back the answer. No SQL, no dashboards, no CSV exports.

Connect to your agent
What you can ask your agent
  • How many events did we receive per hour yesterday?
  • What's the funnel conversion rate from signup to first purchase?
  • Show me the top 10 users by event count this week
  • Which event types have increased most in the last 7 days?
  • What's the day-1 retention rate for users who signed up last month?

Sequel CLI

Install ClickHouse MCP to your agent

The Sequel CLI installs ClickHouse into your coding agent in one step — it signs you in, provisions a scoped API key, and writes the right config to the right place. No keys to copy by hand.

Prefer npm? npm install -g @sequelsh/cli@latest works too.

  1. 1

    Install the Sequel CLI

    One line installs the latest CLI with whatever package manager you have.

    curl -fsSL https://sequel.sh/install | sh
  2. 2

    Sign in

    Authenticate in your browser and pick an organization.

    sequel login
  3. 3

    Install into your agent

    Run install and pick an agent from the list, or target one directly by its slug.

    sequel install
    Claude Code
    sequel install claude-code
    Claude
    sequel install claude
    Cursor
    sequel install cursor
    VS Code
    sequel install vscode
    Windsurf
    sequel install windsurf
    Zed
    sequel install zed
    Codex
    sequel install codex
    OpenClaw
    sequel install openclaw
    Hermes
    sequel install hermes

Frequently asked questions

How do I connect ClickHouse?

Click 'New Connection', select ClickHouse, and enter your host, port, database, username, and password. Sequel supports both HTTP and native interfaces.

Which ClickHouse versions are supported?

Sequel supports ClickHouse 21.x and above, including ClickHouse Cloud.

Can Sequel handle large ClickHouse tables?

Yes. Sequel adds LIMIT clauses by default and warns you before running queries that may trigger full table scans on large datasets. ClickHouse's columnar storage makes even large queries fast.

Does Sequel use ClickHouse-specific SQL features?

Yes. Sequel generates ClickHouse-compatible SQL including toStartOfHour, toDate, arrayJoin, and other ClickHouse functions when appropriate.

Can I connect ClickHouse Cloud?

Yes. Enter your ClickHouse Cloud hostname, port 8443, and credentials. Make sure to allowlist Sequel's IP in your ClickHouse Cloud instance settings.

Is my ClickHouse connection read-only?

Yes. Sequel is read-only by default and will not execute write operations unless you explicitly request them.

Start analyzing your ClickHouse data today

Connect in minutes — then ask across all your data, not just one source.