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

score 8 · Accepted Answer · answered Oct 28 '21 at 15:54

8

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:

answered Oct 28 '21 at 15:54

Jordan Lewis

The cluster name, including the tenant id, is available from the "connect" modal in the options text box (it is the --cluster value). – Ron Mar 29 '22 at 18:28

score 1 · Answer 2 · answered Mar 29 '22 at 18:32

1

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

answered Mar 29 '22 at 18:32

Ron

score 1 · Answer 3 · answered Jul 18 '22 at 17:03

1

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.

answered Jul 18 '22 at 17:03

martenc

3 Answers3