CockroachDB on Desktop and SpinDB

Distributed SQL with strong consistency, Postgres wire-protocol compatible. Available on Layerbase Desktop and self-hosted with SpinDB.

Layerbase Desktop / CockroachDB / app_prod

Database

app_prod

Schema

  • users
  • sessions
  • orders
  • audit_log
CockroachDB SQLCmd+Enter to run
SELECT region, COUNT(*) AS users
FROM users
WHERE created_at > now() - INTERVAL '7 days'
GROUP BY region
ORDER BY users DESC;
regionusers
us-east112,847
us-west29,231
europe-west46,402
asia-northeast13,118
4 rows - 18ms

The Business Source License wording makes us uncomfortable to host CockroachDB as a serverless platform. We didn't want to ship something where the licensing story was murky for our paying customers.

If you're with Cockroach Labs and would like to work with us on a clean managed offering, we would love to hear from you.

Contact us

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.

Desktop app or self-host with SpinDB

CockroachDB runs on your laptop with the Layerbase Desktop app, or anywhere else with SpinDB, our open-source CLI for managing local and self-hosted databases.

Native dashboard

Same dashboard chrome, query console, and connection manager as the Layerbase Cloud experience, running on your own machine.

Runs the upstream binary

No license substitution. You are running the engine maintainers ship, with the configuration knobs they document.

Your machine, your data

Data stays on disk. No managed-host TLS to terminate, no IP allowlist to maintain, no third party to trust.

Free for personal use

Layerbase Desktop is free for personal projects. Team and commercial use is covered under the standard license.

Common CockroachDB questions

Why is CockroachDB not on Layerbase Cloud?+

CockroachDB has a Business Source License that restricts hosted commercial offerings. We do not run it as a managed service for that reason. On the desktop or via SpinDB you run the upstream binary directly under its standard license.

Can my Postgres app connect to CockroachDB?+

Yes. CockroachDB speaks the PostgreSQL wire protocol, so psql, libpq-based drivers, ORMs (Prisma, Drizzle, etc.) all work. There are some SQL dialect differences, primarily around schema and transactions.

How is the desktop experience different from cloud Postgres?+

Desktop CockroachDB still runs the full distributed SQL engine, just with a single in-process node. The dashboard surfaces the same connection panel, query console, and management UI as the rest of Layerbase.

When would Layerbase Cloud add CockroachDB?+

If the licensing landscape changes or we partner with Cockroach Labs directly. For now, desktop and self-host are the supported paths.

Can I move a schema from Postgres to CockroachDB?+

For most apps, yes. Identify Postgres-specific features your schema uses (custom types, certain extension features) and confirm they map to CockroachDB before migrating.