Serverless ClickHouse
Columnar analytics at production scale, on a connection string. Web SQL console, native and HTTP endpoints, the same tools you already use.
Tables
- users
- events
- orders
- sessions
| id | name | created_at |
|---|---|---|
| 1247 | signup | 2026-03-12 14:21 |
| 1246 | purchase | 2026-03-12 14:08 |
| 1245 | login | 2026-03-12 13:55 |
| 1244 | signup | 2026-03-12 13:44 |
| 1243 | purchase | 2026-03-12 13:30 |
Where to run it
Cloud, desktop, or self-host
One database, three places it can live. Pick the speed you want and move between them when you outgrow it.
Branching, on request
Database branching is live on 9 engines today, and the same copy-on-write mechanism spans the whole fleet. Want it on ClickHouse? Reach out and we will look at switching it on for your account.
Request branchingTry ClickHouse free for 7 days
ClickHouse runs always-on from your Pro pool, so it lives on the Pro plan. Start a 7-day Pro trial to spin one up: a card is required, you are charged $0, and you can cancel before it converts to $15/mo. One trial per account.
Start the Pro trialWhat you get
Production features, free tier included
Every ClickHouse database ships with the same primitives: TLS, web console, hibernation, and a real dashboard. No tiered features hidden behind a sales call.
Web IDE
Query console in the dashboard, no extra client to install.
TLS by default
All connections encrypted. No setup required.
Always-on connections
Pin a database to your always-on pool to prevent hibernation.
Scale to zero
Hibernates when idle. Wakes on the next connection.
Connection pooling
Pooled endpoint for serverless and edge workloads.
Direct connections
Bypass the pooler for migrations and replication.
Native HTTPS endpoint
Engines whose own wire protocol speaks HTTPS. Every database, including this one, is also queryable over the platform's HTTPS query API and web console.
Serverless driver
Drop-in HTTP driver for edge runtimes (Upstash REST, PlanetScale, or the engine-native client).
IP whitelisting
Restrict access to specific IPs or CIDR ranges.
Automatic backups
Scheduled dumps and volume snapshots with one-click restore on paid plans. Free tier includes a manual backup slot.
Quick start
Connect with any ClickHouse client
Real-time analytics, time-series, observability backends, ad-hoc OLAP queries over large datasets, and apps that outgrew Postgres for reporting.
- Stand up a ClickHouse for a single project without provisioning a cluster
- Replicate slow Postgres reporting queries to a columnar engine
- Build an observability backend (logs, metrics) on the same platform as your operational databases
- Prototype real-time analytics dashboards
- Self-host on your own hardware with SpinDB for tighter compliance control
curl -u layerbase:password "https://your-host.cloud.layerbase.dev/?query=SELECT%201"
More on ClickHouse
All articles- June 14, 2026
Branching with any database
Neon branches Postgres. PlanetScale branches MySQL. Layerbase branches all of them, because branching happens at the filesystem, not inside the engine. Here is how it works.
Read - March 11, 2026
ClickHouse vs DuckDB
A practical ClickHouse vs DuckDB comparison with side-by-side code, covering when to pick a production analytics server versus an embedded engine.
Read - March 4, 2026
Getting Started with ClickHouse
Build a real-time web analytics pipeline with ClickHouse and TypeScript, from raw page view events to funnel analysis, all in one runnable script.
Read
Questions
Common ClickHouse questions
Native TCP or HTTP endpoint?+
Both. The dashboard exposes the native protocol for the official clients (clickhouse-client, JDBC) and the HTTP endpoint for tools and runtimes that prefer it.
Will my existing ClickHouse driver work?+
Yes. Standard drivers (clickhouse-driver, ch-go, JDBC, Python clickhouse-client) connect over the published endpoint without changes.
Provisioning time?+
ClickHouse takes about 1 to 2 minutes to provision on the first create because of its larger binary. After that it runs always-on from your Pro pool, so there is no idle sleep or wake to wait on.
Can I run ClickHouse locally?+
Yes. SpinDB manages local ClickHouse versions with the same one-command install; Layerbase Desktop adds the dashboard on top.
How does pricing work?+
ClickHouse is a paid-tier engine on Cloud. The cost preview in the create flow shows the monthly cost before you provision; the Free plan covers other engines for prototyping.