ClickHouse
ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support
This is a first-class FlyMyAI MCP. Agents discover it automatically via tool search and call the actions below on demand - you never wire it up by hand. See the Composio catalog for how discovery works.
Connect
ClickHouse authenticates with basic authentication credentials. Generate the credential in your ClickHouse account, then paste it into FlyMyAI the first time an agent uses a ClickHouse action.
Get your ClickHouse credential →
Fields to fill in FlyMyAI
| Field | Details |
|---|---|
Base URL | The base URL of your ClickHouse instance (e.g., http://localhost:8123 or https://your-cluster.clickhouse.cloud:8443) (required) |
Username | ClickHouse username for authentication (default user is 'default') (required) |
Password | ClickHouse password for authentication (required) |
Default Database Name | Default database to use for queries. Actions will use this database when not explicitly specified in the request. Leave empty to use ClickHouse's default database. |
Actions
Every action this integration exposes. Agents pick the right one from the task; you do not call them by name.
| Action | What it does | Required inputs |
|---|---|---|
CLICKHOUSE_EXECUTE_QUERY | Execute a sql query in clickhouse and return the results. this is the primary action for querying data from clickhouse databases. | query |
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. | - |
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. | table_name |
CLICKHOUSE_LIST_DATABASES | List all databases in the clickhouse instance. useful for discovering available databases before querying tables. | - |
CLICKHOUSE_LIST_TABLES | List tables in clickhouse databases. returns information about tables including their engine, size, and row count. | - |
Links
We love our partners - FlyMy.AI builds with the best. Thanks, ClickHouse!