Serverless DuckDB
Cloud velocity for analytics, desktop ergonomics for developers, self-hosting with SpinDB for the ops enthusiast.
Tables
- sales
- customers
- products
- events
| region | total |
|---|---|
| us-east | 482,194.50 |
| us-west | 311,820.00 |
| eu-west | 208,944.75 |
| ap-south | 147,612.20 |
| sa-east | 92,408.40 |
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.
What you get
Production features, free tier included
Every DuckDB 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
Optional keep-alive add-on prevents 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.
HTTPS access
HTTP-native engines reachable over port 443.
Serverless driver
Upstash REST or PlanetScale serverless drivers supported.
IP whitelisting
Restrict access to specific IPs or CIDR ranges.
Automatic backups
Scheduled point-in-time backups with one-click restore.
Quick start
Connect with any DuckDB client
Ad-hoc analytics over CSVs and Parquet, columnar OLAP workloads, BI dashboards, and teams who want DuckDB without managing a server.
- Spin up a hosted warehouse for a side project without provisioning infra
- Query Parquet and CSV in the cloud, share a connection string with teammates
- Prototype an analytics layer that scales to zero between sessions
- Hand a connection string to a BI tool instead of running DuckDB locally
- Drop in as a read-replica analytics endpoint behind a Postgres-shaped client
psql "postgresql://layerbase:password@your-host.cloud.layerbase.dev:5432/duck1?sslmode=require&sslnegotiation=direct"Questions
Common DuckDB questions
Is DuckDB really free on Layerbase?+
Yes. Layerbase Free includes DuckDB with no credit card. Your database hibernates after an hour of inactivity and wakes on the next connection. Upgrade only if you need always-on, larger storage, or paid-tier engines.
How do I connect to hosted DuckDB?+
Layerbase Cloud exposes DuckDB through a PostgreSQL-compatible endpoint. Use psql, any PostgreSQL driver, Prisma, Drizzle, or a BI tool: the connection string in the dashboard works with all of them. SSL is required (?sslmode=require).
Can I use DuckDB locally instead?+
Yes. SpinDB is our open-source CLI for running any database engine locally, including DuckDB. Layerbase Desktop wraps SpinDB with a GUI. The same database files are portable across local, desktop, and cloud.
What happens to my database if I stop using it?+
Free databases hibernate after 1 hour of inactivity (paid: 6 hours) and wake automatically on connect, typically in 1 to 2 seconds for DuckDB. After 14 days idle on the Free tier, the database is archived (HAProxy listener and DNS removed); you can restore it from the dashboard. Paid plans never auto-archive.
Is DuckDB available on the desktop app?+
Yes. Layerbase Desktop runs DuckDB locally with the same dashboard, query console, and connection management as the cloud version. Free for personal use.