How do I connect DBeaver to CockroachDB Serverless?

Question

How do I connect DBeaver with my CockroachDB Serverless database? I get errors that look like this:

FATAL: codeParamsRoutingFailed: missing cluster name in connection string

Answer 1

Make sure to include the cluster name in the database field.

The database should be something like: cluster-name-1234.databasename.

Here is a screenshot of a working configuration:

Answer 2

To find the cluster name, including the tenant id use the Connect modal from the CockroachCloud Database Page:

Answer 3

Most importantly, include .defaultdb to the end of the name of your database in the "Database" field. For example, databasename-dev-369.defaultdb

This was the least intuitive config detail, easily killed an hour of my time :/ Hope this helps.