CockroachDB · supported engine

Distributed SQL, one workbench.

Native SQL, schema, explain, and index tooling on the PostgreSQL driver surface - with archive backup/restore, versioned migrations, and SSH tunneling for dedicated and self-hosted clusters.

Included with Mongrel Try free for 7 days

PostgreSQL wire protocol · CockroachDB dedicated & self-hosted

Advice that survives failover

The distributed plan Mongrel would build for your query.

Click any node below to see spans, ranges, and what Mongrel would suggest. The same plan data you get in the workbench's explain view.

// Distributed Hash Join · customers

Streams order rows to the 5 nodes holding customers ranges, hash joins locally, then returns. Distribution: full, vectorized.

-- analytics · prod-us-east · 5 nodes
SELECT
  o.id, o.total, o.status,
  c.email AS customer_email
FROM orders o
JOIN customers c ON c.id = o.customer_id
WHERE o.created_at > '2026-06-01'
  AND o.status = 'paid'
ORDER BY o.created_at DESC
LIMIT 20;

-- 258ms · 96,300 rows across 12 ranges · full distribution
-- ✓ Proposal: index on (customer_id, created_at)

CREATE INDEX idx_orders_customer_created
  ON orders (customer_id, created_at DESC);

CockroachDB surface

What Mongrel ships for CockroachDB.

SQL editor & builder

Native SQL on the PostgreSQL wire protocol - full autocomplete, visual builder, and both sides stay editable.

EXPLAIN & DistSQL plans

Run EXPLAIN or EXPLAIN ANALYZE. Inspect distribution, span counts, vectorized stages, and row estimates per node.

Index tools & advisor

List, create, and drop indexes - or let the index advisor read your EXPLAIN and suggest an index with ready-to-run DDL.

Migrations & schema drift

Apply versioned migrations with up/down rollback, and snapshot schemas to catch drift before it spreads.

Copy & remote import

Copy a database between connected clusters, or import tables and data from another saved profile - same driver, no dump files.

Backup & restore

Back up selected tables into portable Mongrel archives, and restore table data from the UI - verified against CockroachDB.

AI explain & rewrite

Paste a query and its EXPLAIN. The assistant rewrites it, proposes indexes and locality fixes, and talks through the expected plan.

Users, roles & certs

Browse users, roles, and grants. Connect with password or client-certificate auth; cluster status and statement stats built in.

SSH tunneling

Reach dedicated and self-hosted clusters behind a bastion. Key or agent auth, per-connection tunnel profiles.

Connect CockroachDB in 30 seconds.

7-day trial. macOS, Windows, Linux. No credit card.

Download Mongrel