A Gleap custom agent can list ClickHouse databases and tables, read schemas and run SQL through Composio. It suits engineering teams that store product events, logs or usage in ClickHouse and want those facts in support tickets.
What a Gleap agent can do in ClickHouse
- Check events behind a report: Execute ClickHouse Query runs SQL, such as the failed requests for one account in the last hour.
- Understand the data first: Get Database Schema and Get Table Schema return columns and types, so the agent writes correct queries.
- Find the right table: List ClickHouse Databases and List ClickHouse Tables show what exists, with engines, sizes and row counts.
Example: Is it one customer or everyone?
A customer reports in Gleap that file uploads fail since this morning. The engineer on support duty asks the agent to check. The agent reads the schema of the events table, queries upload errors per account for the last six hours and sees that errors come from one region. The engineer takes the finding to the incident channel and decides the fix.
How to connect ClickHouse
- In Gleap, open AI & Automation > Agents and select a custom agent, or create one.
- In its Tools section, click Add tool and search for “ClickHouse”.
- Pick ClickHouse under More integrations and click Connect ClickHouse.
- Enter the ClickHouse connection details Gleap asks for, such as host, username and password, and connect.
- Open the new ClickHouse tool and switch off every action the agent does not need, such as Get ClickHouse Play Interface.
- Tell the agent in its instructions when to use ClickHouse, then test it in chat.
Custom agents are included in the Team, Pro and Enterprise plans. Kai Support can use connected apps as tools on Team, Pro and Enterprise. Kai Code, also on those plans, can use ClickHouse in coding sessions once you add it under Settings > MCP in Kai Code.
FAQ
Does Gleap integrate with ClickHouse?
Yes, through Composio. The ClickHouse toolkit lets a Gleap custom agent list databases and tables, read schemas and run queries. Queries run only when the agent runs.
What can a Gleap AI agent do in ClickHouse?
It answers “how many” and “since when” questions behind a customer report with data from your ClickHouse tables. Kai Code can also connect ClickHouse to check data while it works on a change.
Which Gleap plan includes the ClickHouse integration?
Kai Support and Kai Code can use the ClickHouse toolkit on Team, Pro and Enterprise; custom agents that use it are on Team, Pro and Enterprise. Kai Support answers customers, so switch on only actions that are safe in a customer conversation. Create a dedicated ClickHouse user for the agent. AI usage is billed separately; see pricing.
Can the agent change data in ClickHouse?
Execute ClickHouse Query runs whatever SQL the connected user may run. Give that user read-only access to the databases the agent needs.
