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.
Why Layerbase
Predictable pricing, no cloud setup
ClickHouse on Layerbase Cloud is priced the same way as every other engine: a flat monthly plan with nothing metered behind it.
A fixed monthly price
Plans are flat: Free at $0, then $5/mo Solo and $15/mo Pro. No per-hour compute meter, no per-database line items, and no bill that changes shape when your traffic does.
No bandwidth charges
Reads and writes are not metered. There are no ingress or egress fees, so moving data in and out of your database never adds to the bill.
No cloud account to wire up
You do not need an AWS, GCP, or Azure account. Sign up, create a database, and connect. Layerbase runs the infrastructure, so there is no cloud provider to configure or pay separately.
Side by side
Hosted ClickHouse, compared
| Provider | Free tier | Billing |
|---|---|---|
| ClickHouse Cloud | None; 30-day trial | From roughly $66/mo with per-minute compute metering |
| Layerbase | ClickHouse is a Performance engine on Pro | $15/mo flat as 1 of 10 databases, always-on from your pool. No compute meters. |
ClickHouse Cloud
- Free tier
- None; 30-day trial
- Billing
- From roughly $66/mo with per-minute compute metering
Layerbase
- Free tier
- ClickHouse is a Performance engine on Pro
- Billing
- $15/mo flat as 1 of 10 databases, always-on from your pool. No compute meters.
Competitor facts as of July 2026, from public pricing pages.
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- July 20, 2026
Layerbase vs Tinybird: real-time analytics without the usage meter
Tinybird turns ClickHouse into a managed real-time analytics API with usage-based billing. Layerbase gives you the same ClickHouse engine on a flat monthly price and leaves the API layer to you. Here is the tradeoff, and when each one wins.
Read - 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
FAQ
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.