ClickHouse Integration

ClickHouse is a column-oriented database for high-performance analytics on large volumes of data. Connect ClickHouse to Basedash to ask questions, build dashboards, and automate reporting with AI.

Start free View docs

14-day trial. No credit card required.

Chat/ClickHouse growth

Connected

Show ClickHouse weekly trend over the last 12 weeks, with the prior period as a comparison.

Pulled the last 12 weeks from clickhouse. Up +38% vs. the prior period — growth accelerating in the last four weeks.

ClickHouse weekly

94+38%(42)

ClickHouse

68+13%(38)

Prior period

12 weeks

Save it to the Acme Corp dashboard.

Ask a follow-up about ClickHouse…↵

Basedash connects to ClickHouse over its HTTP interface and queries your analytics tables in place, on ClickHouse Cloud or your own servers.

Read the ClickHouse setup guide

Create a dedicated user
Give a ClickHouse user read and SHOW privileges on the databases Basedash should see.
Enter the HTTP endpoint
Add the database, user, password, and host, and use the HTTP interface port: 8443 with SSL (ClickHouse Cloud) or 8123 without.
Connect and sync the schema
Basedash checks the connection, then syncs the schema.

ClickHouse privileges

SELECT on the databases or tables you need
SHOW on databases
SHOW TABLES
SHOW COLUMNS

Imagine ChatGPT or Claude, but with full context of your ClickHouse schema and how your team uses it. Basedash answers in plain language, backed by real queries.

Try asking

Revenue by region from ClickHouse for the last four quarters.
Which ClickHouse tables power our core KPIs, and how fresh are they?
Compare weekly active accounts in ClickHouse against last year.
Break down ClickHouse orders by product line and channel.

Plain-language queries

Ask follow-ups in natural language. Basedash translates them into SQL against your ClickHouse data.

Knows your business

Basedash learns your KPIs, schemas, and the way your team talks about ClickHouse.

Agentic by default

Runs multiple queries, resolves errors, and keeps iterating until the answer is right.

Keep querying ClickHouse directly, and sync your SaaS tools into a managed warehouse to see how sales, finance, product, and operations actually connect.

Queries run in placeBasedash connects to ClickHouse directly and queries your data where it lives. No copies to keep in sync.
Scoped credentialsConnect with a dedicated ClickHouse user or key so Basedash only sees the data you grant.
SaaS data alongsideSync CRM, billing, and support tools into Basedash Warehouse and analyze them in the same workspace.

Explore the warehouse

Common questions about ClickHouse and Basedash

Which port does Basedash use for ClickHouse?

Basedash connects over ClickHouse's HTTP interface, not the native TCP protocol. Use port 8443 with SSL, which is the default and what ClickHouse Cloud uses, or 8123 without SSL. Turn on the SSL toggle when you connect over HTTPS.

What privileges does the Basedash ClickHouse user need?

SELECT on the databases or tables you want to analyze, plus SHOW on databases, SHOW TABLES, and SHOW COLUMNS so Basedash can read the schema. Create a dedicated user with only those grants, set query limits that fit your cluster, and rotate its credentials regularly.

Does Basedash work with ClickHouse Cloud?

Yes. Basedash connects to ClickHouse Cloud and to self-managed ClickHouse servers. For ClickHouse Cloud, use port 8443 with SSL on. If the connection fails, check the SSL setting, the user's privileges, and that the server accepts connections from Basedash.