← All docs

CockroachDB

CockroachDB is a distributed SQL database with PostgreSQL wire compatibility.

Connection

CockroachDB supports the PostgreSQL wire protocol. Some DDL behavior differs from PostgreSQL.

Setup

# CockroachDB Serverless
migrationpilot analyze migration.sql \
  --database-url "postgresql://user:pass@free-tier.gcp-us-central1.cockroachlabs.cloud:26257/mydb"

# Consider excluding lock-related rules
migrationpilot analyze migration.sql \
  --database-url "$COCKROACH_URL" \
  --exclude MP001,MP004,MP006

Tips

  • •CockroachDB handles schema changes differently — online schema changes are the default
  • •Lock-related rules (MP001, MP004) may not apply since CockroachDB uses a different locking model
  • •Set pgVersion to match your CockroachDB PostgreSQL compatibility level
  • •Some PostgreSQL-specific features (e.g., CONCURRENTLY) may not be available
← All docsConfiguration guide