Execute ClickHouse Query
Execute a SQL query in ClickHouse and return the results. This is the primary action for querying data from ClickHouse databases.
ActionTry it
Integrate ClickHouse
with your AI CRM
ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support
Explore Triggers and Actions
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
List ClickHouse Databases
List all databases in the ClickHouse instance. Useful for discovering available databases before querying tables.
ActionTry it
List ClickHouse Tables
List tables in ClickHouse databases. Returns information about tables including their engine, size, and row count.
ActionTry it
How the ClickHouse integration works
The ClickHouse integration connects your Dench AI CRM directly to ClickHouse, so agents can read and act on your ClickHouse data as part of everyday work — answering questions in chat, keeping your CRM in sync, and running automations without anyone copying data between tools.
6 actions are available for agents to invoke on your behalf. Every call runs through ClickHouse's own authorization, scoped to the account you connect.
Set up ClickHouse in Dench
- 1
Sign in to your Dench workspace and open Integrations.
- 2
Find ClickHouse and click Connect — you'll authorize access through ClickHouse's own sign-in flow. No API keys or code required.
- 3
Ask an agent to use ClickHouse in chat, or call it from an automation.
- 4
Manage or disconnect the connection any time from workspace settings.
Frequently asked questions
How does the ClickHouse integration work with Dench?
The Dench ClickHouse integration connects your AI CRM to ClickHouse, so AI agents can work with your ClickHouse data as part of chats, automations, and CRM workflows. You connect your account once, and every agent in your workspace can use it — governed by your workspace permissions.
What actions can AI agents perform with ClickHouse via Dench?
The ClickHouse integration currently exposes 6 actions, including Execute ClickHouse Query, Get ClickHouse Play Interface, Get Database Schema, Get Table Schema, List ClickHouse Databases, and List ClickHouse Tables. Agents invoke them on your behalf from chat or from automations.
Do I need to write code to connect ClickHouse to Dench?
No. You connect ClickHouse from your Dench workspace using ClickHouse's own sign-in and authorization flow — no API keys to copy, no glue code to maintain.
Is the ClickHouse integration secure?
Connections are authorized through ClickHouse's own authentication flow, and Dench stores only the authorization needed to act on your behalf. You can review and disconnect the ClickHouse connection from your workspace settings at any time.