• TidioReply faster to tickets across all channels
  • LyroHire AI to handle customer servicecheck
  • Hubi AIRun on-brand marketing with an AI coworker
  • LabsTidio LabsGet a custom AI solution built by experts
  • Master AgentOrchestrates every channel
  • AI Voice AgentResolves calls on its own
  • Lyro for Zendesk
  • Lyro for Freshdesk
  • Lyro for Salesforce
  • Lyro for HubSpot
Browse all integrationsarrow_forward
  • Borrowell83% resolved
  • GameBoost86% automated
  • Cove Smart70% self-service
  • Secureframe59% automated
See all customer storiesarrow_forward
  • AI in E-Commerce in 2026Free report on the new shopping funnel
  • Shadow AIFree report on the hidden AI habit
  • AI in Insurance in 2026Free report on AI in insurance
See all reportsarrow_forward
  • Features
  • Pricing
Talk to salesGet started
Lyro wordmark

Product

  • Features
  • Master Agent
  • AI Voice Agent
  • Integrations
  • Pricing
  • Copilot

Resources

  • Blog
  • Customer Stories
  • Reports
  • AI in Ecommerce Report
  • Docs

Company

  • Contact
  • Book a Demo

Legal

  • Privacy Policy
  • Terms of Service
  • Data Processing Agreement

4.7/5on G2G2 logo

SOC 2 Type II · GDPR · CCPA

© 2026 Lyro by Tidio. All rights reserved.

ClickHouse

ClickHouse MCP integration

Lists databases and tables, reads column definitions and keys, runs the SQL, and hands over the Play editor for follow-up digging.

Connect ClickHouseSee all integrations

6actions available

  1. Home/
  2. Integrations/
  3. ClickHouse

Three actions you can hand over today

Every action runs live through MCP. Nothing to build, nothing to maintain.

  • Execute clickhouse query

    Lyro runs a SQL query against ClickHouse and returns results. Your team pulls analytics, event logs, or metrics without external tools.

  • List clickhouse databases

    Lyro lists all available databases in the ClickHouse instance. Your team discovers what data is available for queries and troubleshooting.

  • List clickhouse tables

    Lyro enumerates tables within ClickHouse databases. Your team explores schema structure to build queries or verify data freshness.

See all 6 actions

How businesses use ClickHouse + Lyro

Each card is one request a support team gets, and the ClickHouse actions Lyro runs to close it.

  • database

    See what the instance holds before writing any SQL

    Lyro lists the databases on the instance and the tables inside one, with each table's engine, size, and row count, so the right table is identified without someone opening a client to look.

    List ClickHouse DatabasesList ClickHouse Tables
  • storage

    Read the structure of the table being queried

    Lyro pulls a whole database's schema in one call, or a single table's column definitions, types, keys, and sample rows, so the query it composes matches the columns that actually exist.

    Get Database SchemaGet Table Schema
  • insights

    Answer the question, then hand over the editor

    Lyro runs the SQL and returns the result set, and when someone wants to keep exploring it returns the ClickHouse Play interface with its Monaco editor so they continue from the same query.

    Execute ClickHouse QueryGet ClickHouse Play Interface

How it works

Get started in 3 steps

Connect once, then just ask. There is no workflow builder to learn and nothing to maintain — Lyro reads the ClickHouse actions it has and picks the ones a request needs.

  1. 01

    Connect ClickHouse

    Authorize the ClickHouse account your team already uses — one consent screen, no API keys, no mapping tables. Lyro can only do what you granted that account, and you can disconnect it at any time.

  2. 02

    Tell your agent what you need

    Describe the job the way you would hand it to a teammate. Lyro maps it to the ClickHouse actions that close it and chains as many as the request needs.

  3. 03

    Watch it work

    The agent runs the actions inside the conversation the customer is already in, so nobody copies data between tabs and your team can take over at any point.

    Get started free

ClickHouse · Lyro

What can you do in ClickHouse without me setting anything up?

These, right away:

  • Get database schema
  • Execute clickhouse query
  • Get clickhouse play interface

Great, let's start with the first one.

Ask Lyro anything...

FAQ

Everything else about ClickHouse

Setup, permissions, and the limits of what Lyro can do inside ClickHouse.

  • There is no dedicated insert, update, or DDL action in the toolkit - anything that writes would have to go through Execute ClickHouse Query. That means the privileges on the ClickHouse user you connect decide the answer: connect a read-only user and the integration is read-only.

  • It inspects the schema first. Get Table Schema returns column definitions, types, keys, and optionally sample data for one table, and Get Database Schema returns the whole database's structure in a single call, so the query is built from the real shape of the data.

  • Get ClickHouse Play Interface returns ClickHouse's own web UI, an HTML page with a Monaco editor for writing and running queries. It is the handoff step: Lyro answers the immediate question, then gives an analyst the interactive surface instead of a screenshot of results.

  • Two things worth setting up: List ClickHouse Tables reports each table's size and row count, so scope can be judged before a scan is run, and every query executes as the connected ClickHouse user, subject to whatever quotas and row limits are configured for that user in ClickHouse itself.

Every action available in ClickHouse

All 6 actions your agent can call on ClickHouse, straight from the live MCP connection.

  • Execute clickhouse query

    Execute a SQL query in ClickHouse and return the results.

  • Get database schema

    Get comprehensive schema overview of an entire database including all tables and optionally their column definitions.

  • Get clickhouse play interface

    Get the ClickHouse Play web user interface for interactive query execution.

  • Get table schema

    Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data.

  • List clickhouse databases

    List all databases in the ClickHouse instance.

  • List clickhouse tables

    List tables in ClickHouse databases.

The tools ClickHouse sits next to

Same connection, same setup. Pick the next one your team already uses.

  • Ambient weatherarrow_outward

    Ambient weather

    Pulls the latest reading from every registered Ambient Weather station into the conversation.

  • Databoxarrow_outward

    Databox

    Creates Databox data sources and datasets, pushes records into them, verifies each ingestion landed, and removes what is no longer feeding a dashboard.

  • Google search consolearrow_outward

    Google search console

    Pulls clicks, impressions, and position data from a live property, inspects URLs that will not index, and submits or audits sitemaps.

  • Mopinionarrow_outward

    Mopinion

    Pulls survey responses for a form or report, resolves the fields behind them, and reports where and when a feedback form is shown.

  • Radararrow_outward

    Radar

    Reads and updates trip status, starts and completes trips, maintains geofences and beacons, and turns partial addresses into verified coordinates.

  • Taggunarrow_outward

    Taggun

    Reads a receipt the moment it arrives, extracts merchant, totals, tax, and line items, and keeps the registries it matches against current.

Browse every integration
Support agent working at a laptop next to the Lyro mascot

Ready to connect ClickHouse?

Authorize the account and your agent has all 6 actions from the first conversation.

Connect ClickHouseTalk to sales
Connect ClickHouseTalk to sales
Support agent working at a laptop next to the Lyro mascot