ClickHouse

ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support

6 actions Integration catalog

Request access

Connect ClickHouse once you're in Boring.

01 · WHAT THE AGENT CAN DO

Actions

Every capability is a discrete, logged action the agent calls by name — scoped to what you authorize and recorded in the run trace.

Execute ClickHouse QueryCLICKHOUSE_EXECUTE_QUERY

Execute a SQL query in ClickHouse and return the results. This is the primary action for querying data from ClickHouse databases.

Get Database SchemaCLICKHOUSE_GET_DATABASE_SCHEMA

Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. Essential for AI agents to understand the complete database structure in a single call.

Get ClickHouse Play InterfaceCLICKHOUSE_GET_PLAY_INTERFACE

Get the ClickHouse Play web user interface for interactive query execution. Returns HTML page with Monaco Editor for writing queries and visualizing results.

Get Table SchemaCLICKHOUSE_GET_TABLE_SCHEMA

Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. This is essential for AI agents to understand table structure before constructing queries.

List ClickHouse DatabasesCLICKHOUSE_LIST_DATABASES

List all databases in the ClickHouse instance. Useful for discovering available databases before querying tables.

List ClickHouse TablesCLICKHOUSE_LIST_TABLES

List tables in ClickHouse databases. Returns information about tables including their engine, size, and row count.