ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support
Execute a SQL query in ClickHouse, including statements that can modify data or schema, and return its results. JSONEachRow results have synthesized statistics; other non-JSON formats are returned as text in a single result row.
Get the ClickHouse Play web user interface for interactive query execution. Returns HTML page with Monaco Editor for writing queries and visualizing results.
Get a schema overview of a ClickHouse database, including its tables and optionally their column definitions. Requested column definitions may be unavailable if the column lookup fails.
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 all databases in the ClickHouse instance. Useful for discovering available databases before querying tables.
List tables in ClickHouse databases. Returns information about tables including their engine, size, and row count.
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.
Sign in to your Dench workspace and open Integrations.
Find ClickHouse and click Connect — you'll authorize access through ClickHouse's own sign-in flow. No API keys or code required.
Ask an agent to use ClickHouse in chat, or call it from an automation.
Manage or disconnect the connection any time from workspace settings.
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.
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.
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.
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.