# ClickHouse AI integration on Definable

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

## What this connects

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

Vendor: https://clickhouse.com

## Tools available

**6** tools available. First 6:

- `CLICKHOUSE_EXECUTE_QUERY` — Execute ClickHouse Query — Execute a SQL query in ClickHouse and return the results. This is the primary action for querying data from ClickHouse databases.
- `CLICKHOUSE_GET_DATABASE_SCHEMA` — 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.
- `CLICKHOUSE_GET_PLAY_INTERFACE` — Get ClickHouse 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.
- `CLICKHOUSE_GET_TABLE_SCHEMA` — 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.
- `CLICKHOUSE_LIST_DATABASES` — List ClickHouse Databases — List all databases in the ClickHouse instance. Useful for discovering available databases before querying tables.
- `CLICKHOUSE_LIST_TABLES` — List ClickHouse Tables — List tables in ClickHouse databases. Returns information about tables including their engine, size, and row count.

## Auth

Auth schemes: `BASIC`.

## How agents use ClickHouse

Inside a Definable workflow, ClickHouse is one of the tools the **Distributor specialist** can call. Example coordination patterns:

- **Researcher → ClickHouse** — the Researcher (GPT-5.5) pulls context from ClickHouse (records, threads, documents), synthesises findings, and briefs the rest of the team.
- **Writer → Distributor → ClickHouse** — the Writer (Claude Opus 4.7) drafts copy in brand voice, the Verifier passes it, then the Distributor writes the result into ClickHouse (create record, post message, draft email).
- **Designer / Engineer → Distributor → ClickHouse** — the Designer ships an asset or the Engineer ships a code change, the Distributor delivers it via ClickHouse (attach file, open PR comment, post status).

The Verifier checks every ClickHouse call. On rate limit, schema drift, or auth refresh it self-heals and retries — the workflow completes without manual intervention.

## Categories

- databases — https://definable.ai/apps/category/databases/
- analytics — https://definable.ai/apps/category/analytics/

## Related

- HTML page: https://definable.ai/apps/clickhouse/
- Same category (databases): https://definable.ai/apps/category/databases/
- All integrations: https://definable.ai/apps/
- Workflow (multi-agent loop): https://definable.ai/workflow/
- Apps llms.txt index: https://definable.ai/llms-apps.txt