How to connect to CockroachDB using DBeaver

3 min readDec 3, 2021

CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.

And to enjoy all the features the best way is to use the cloud version.

1. Assumptions

You’re using the Cockroach in the cloud

2. Why?

This tutorial came to explain how to connect using DBeaver.

3. Benefits

The client is more interesting than creating a program for DML/DDL operations.

4. Connections

4.1. Get the database info

In the configuration phase, we’ll need the following fields: username, host, port, database and the certificate.

4.2. DBeaver

Download the DBevaer Community, since this software is universal to any database will be a great tool for us.

The default values, we need to change

4.3 Using certificate

If you’re using certificate, pay attention for two those values into the Driver properties, the options and the sslrootcert keys AND into the SSL, the CA Certificate value.