Databases

ClickHouse
integration

Query ClickHouse and build dashboards around its analytical data.

Start building Read the setup guide

Configure your connection, create queries, and build the interface your team needs. Try a sample prompt

Connector capabilities

What can ToolJet do with ClickHouse?

Create queries for the operations your app needs, then connect their inputs and results to the interface.

Run SQL queries
Insert arrays of objects

Operations and configuration can vary by connector version. Check the full ClickHouse guide.

An app you could build

Product usage dashboard

Run queries for a selected period and present usage aggregates in charts, with a detail table for investigation.

Try this prompt

I have a product_events table in ClickHouse with event name, user ID, and timestamp columns. Build a product usage dashboard with date and event filters. Show daily event counts and a paginated table for investigating individual events.

Start with this prompt in ToolJet. Sign in or create an account, then connect your data source and replace the example names and fields with yours.

Review the generated app, configure permissions, and test its queries before sharing it with your team.

Explore app templates

Connect ClickHouse

Start with the connection.

Before you begin

Access to the ClickHouse account or endpoint you intend to connect, with the credentials and permissions specified in its setup guide.

Add the data source
Open Data Sources in your ToolJet workspace. Select ClickHouse and enter the required connection details.
Configure and test a query
Choose an operation and supply its inputs. Start with a read operation where available; test writes with non-production data.
Build the interface
Bind query results to components and connect actions to app events. Verify permissions and error handling before rollout.

ClickHouse setup guide

Before production

Use credentials with only the permissions your app needs. Filter and paginate query results, and enforce access restrictions in the database or server-side queries.

Review plans and deployment options

Questions, answered

ClickHouse and ToolJet FAQ

What can I do with the ClickHouse integration?

Query ClickHouse and build dashboards around its analytical data. Supported capabilities: Run SQL queries; Insert arrays of objects.

What do I need to connect ClickHouse to ToolJet?

Access to the ClickHouse account or endpoint you intend to connect, with the credentials and permissions specified in its setup guide.

What should I check before using ClickHouse in production?

Use credentials with only the permissions your app needs. Filter and paginate query results, and enforce access restrictions in the database or server-side queries.

Can I automate tasks with ClickHouse?

Connect ClickHouse queries to app events such as button clicks and form submissions. ToolJet Workflows and Agent Builder can orchestrate supported connectors on Self-hosted deployments; those products are not available on ToolJet Cloud. Check the connector and deployment requirements for your use case.

Keep exploring

Related integrations

Browse all integrations

Amazon Athena

Amazon Redshift

Appwrite

Azure Cosmos DB BigQuery

Couchbase

Put ClickHouse to work
in your next internal app.

Connect your data, build an interface, and give your team a focused workspace.

Start building Book a demo

Connector information reviewed 2026-09-25. Source: ToolJet documentation.