# ClickHouse

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

- **Category:** databases
- **Auth:** BASIC
- **Composio Managed App Available?** N/A
- **Tools:** 6
- **Triggers:** 0
- **Slug:** `CLICKHOUSE`
- **Version:** 20260407_00

## Tools

### Execute ClickHouse Query

**Slug:** `CLICKHOUSE_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 Schema

**Slug:** `CLICKHOUSE_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 Interface

**Slug:** `CLICKHOUSE_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 Schema

**Slug:** `CLICKHOUSE_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 Databases

**Slug:** `CLICKHOUSE_LIST_DATABASES`

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

### List ClickHouse Tables

**Slug:** `CLICKHOUSE_LIST_TABLES`

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