​
Description

The SHOW DATABASES command lists all available data sources and projects. The WHERE clause filters all projects.

​
Syntax

Here is the syntax: 
SHOW DATABASES
WHERE type = 'project';
Alternatively, you can use the FULL keyword to get more information: 
SHOW FULL DATABASES
WHERE type = 'project';