SHOW DATABASES

NOTE! For improved performance, execute this command in the mz_introspection cluster. To switch clusters, use SET CLUSTER = mz_introspection;.

SHOW DATABASES returns a list of all databases available to your Materialize instances.

Syntax

SHOW DATABASES LIKE pattern WHERE expr

Details

Output format

SHOW DATABASES’s output is a table with one column, name.

Examples

CREATE DATABASE my_db;
SHOW DATABASES;
materialize
my_db
Back to top ↑