Connecting to a Local CockroachDB from DataGrip or DBeaver

This is a very short post, but it will likely save some people a little time.

If you have been using CockroachDB locally, it is very easy to connect to via the command line -

cockroach sql --insecure

No username, no password, no certs.

When I went into DataGrip, I added a CockroachDB connection and tried with no username, no password, and got an error.

The very simple fix is to use the username root or admin with no password.

Use the same connection properties in DBeaver.