Clickhouse
Overview
SLUG: CLICKHOUSE
Description
ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support
Authentication Details
Basic Auth
Connecting to Clickhouse
Create an auth config
Use the dashboard to create an auth config for the Clickhouse toolkit. This allows you to connect multiple Clickhouse accounts to Composio for agents to use.
Create and Get auth config ID
Click “Create Clickhouse Auth Config”. After creation, copy the displayed ID starting with ac_
. This is your auth config ID. This is not a sensitive ID — you can save it in environment variables or a database.
This ID will be used to create connections to the toolkit for a given user.
Connect Your Account
Using Basic Auth
Tools
Executing tools
To prototype you can execute some tools to see the responses and working on the Clickhouse toolkit’s playground
OpenAI (Python)
Anthropic (TypeScript)
Google (Python)
Vercel (TypeScript)
Tool List
CLICKHOUSE_EXECUTE_QUERY
Tool Name: Execute ClickHouse Query
Description
Action Parameters
Action Response
CLICKHOUSE_GET_DATABASE_SCHEMA
Tool Name: Get Database Schema
Description
Action Parameters
Action Response
CLICKHOUSE_GET_TABLE_SCHEMA
Tool Name: Get Table Schema
Description
Action Parameters
Action Response
CLICKHOUSE_LIST_DATABASES
Tool Name: List ClickHouse Databases
Description
Action Parameters
Action Response
CLICKHOUSE_LIST_TABLES
Tool Name: List ClickHouse Tables
Description
Action Parameters
Action Response