On this page 
The SHOW DATABASES statement lists all database in the CockroachDB cluster.
Synopsis
Required Privileges
No privileges are required to list the databases in the CockroachDB cluster.
Example
> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| bank |
| crdb_internal |
| information_schema |
| pg_catalog |
| system |
+--------------------+
(5 rows)
