cockroach

Start single-node cluster

$ cockroach start-single-node --insecure

$ cockroach sql --insecure --host=[localhost]

$ cockroach sql --insecure -e "[SELECT * FROM users]"

$ cockroach init --insecure --host=[localhost]

$ cockroach node status --insecure

$ cockroach sql --insecure -e "CREATE DATABASE [mydb]"

$ cockroach import into [table] CSV DATA ('[file.csv]')

$ cockroach sql --insecure -e "SHOW CLUSTER SETTINGS"

cockroach command [options]

cockroach is the command-line interface for CockroachDB, a distributed SQL database designed for cloud-native applications. It provides comprehensive tools for managing multi-node clusters, executing SQL queries, performing backups and restores, and monitoring cluster health and performance.
CockroachDB combines the scalability of NoSQL systems with the consistency guarantees and SQL interface of traditional relational databases. The CLI handles cluster initialization, node management, certificate generation for secure deployments, and direct SQL execution either interactively or programmatically.
The tool supports both secure production deployments with TLS certificates and insecure development environments. It includes a demo mode for experimentation and testing without requiring persistent storage or cluster setup.

--insecure

Disable TLS (development only)

Server address

Server port (default: 26257)

Certificate directory

Data storage location

Execute SQL statement

Connection URL

start

Start a CockroachDB node

Start single-node cluster

Initialize multi-node cluster

Open SQL shell or execute statements

Manage cluster nodes

Drain and shut down node

Export table data (deprecated, use EXPORT)

Create CA, node, and client certificates

Show version

Start temporary demo cluster

Flags can be set via environment variables: COCKROACHHOST, COCKROACHPORT, COCKROACHUSER, COCKROACHINSECURE

Use --insecure only for development. Production requires TLS certificates. Compatible with PostgreSQL wire protocol.

psql(1), mysql(1)