Show composite databases
Enterprise EditionNot available on Aura

The SHOW DATABASES command lists all databases in the DBMS, including composite databases. Composite databases are listed with the type composite in the type column of the result set.

For general information about the SHOW command, see the Cypher Manual → SHOW.
Query
SHOW DATABASES;
Result
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| name      | type        | aliases            | access       | address          | role      | writer | requestedStatus | currentStatus | statusMessage | default | home  | constituents       |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| "library" | "composite" | []                 | "read-only"  | "localhost:7687" | NULL      | FALSE  | "online"        | "online"      | ""            | FALSE   | FALSE | ["library.sci-fi"] |
| "neo4j"   | "standard"  | []                 | "read-write" | "localhost:7687" | "primary" | TRUE   | "online"        | "online"      | ""            | TRUE    | TRUE  | []                 |
| "sci-fi"  | "standard"  | ["library.sci-fi"] | "read-write" | "localhost:7687" | "primary" | TRUE   | "online"        | "online"      | ""            | FALSE   | FALSE | []                 |
| "system"  | "system"    | []                 | "read-write" | "localhost:7687" | "primary" | TRUE   | "online"        | "online"      | ""            | FALSE   | FALSE | []                 |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

For a description of all the returned columns of this command, ways in which the SHOW DATABASE command can be filtered, and details about the privileges required for the command, see List standard databases.

For composite databases, the constituents column is particularly interesting as it lists the aliases that make up the composite database.

Query
SHOW DATABASE library YIELD name, constituents;
Result
+--------------------------------+
| name      | constituents       |
+--------------------------------+
| "library" | ["library.sci-fi"] |
+--------------------------------+