CockroachDB Connection String Builder
Generate and parse CockroachDB connection strings. CockroachDB uses the PostgreSQL wire protocol, so connection strings are PostgreSQL-compatible.
CockroachDB Connection String Format
postgresql://user:password@host:26257/dbname?sslmode=require
psql CLI
psql "postgresql://user:password@host:26257/dbname?sslmode=require"JDBC
jdbc:postgresql://host:26257/dbname?user=user&password=password&sslmode=require
Prisma
DATABASE_URL="postgresql://user:password@host:26257/dbname?sslmode=require"Docker Compose
services:
cockroachdb:
image: cockroachdb/cockroach:latest
command: start-single-node --insecure
ports:
- "26257:26257"
- "8080:8080"SSL Modes
CockroachDB supports the same 6 SSL modes as PostgreSQL. For production CockroachDB deployments, use at minimum sslmode=require.
How to Use
- Select CockroachDB as your provider
- Enter host, port, database, and credentials
- Configure SSL mode
- Choose your output format
- Copy the generated connection string