Question CLI - Get list of databases by domain

[E42]

Server operating system version

Debian 11

Plesk version and microupdate number

Obsidian

Hello,
Do you know if there's a way to get the list of databases associated with a domain from the CLI (Bash script)?

 

[Kaspar]

There doesn't seem to be an CLI command that lists databases unfortunately. Your best bed would be to fetch the data directly from the PSA database.

 

[IgorG]

You can use the following CLI command, for example:

# plesk db "SELECT db.id AS DB_ID,db.name,dbu.id AS DB_USR_ID,dbu.login,d.name AS Domain FROM data_bases db JOIN db_users dbu ON db.id = dbu.db_id LEFT JOIN domains d ON db.dom_id = d.id"
+-------+-------------+-----------+-------------+--------------------+
| DB_ID | name        | DB_USR_ID | login       | Domain             |
+-------+-------------+-----------+-------------+--------------------+
|     1 | wordpress_c |         1 | wordpress_2 | domain.com         |
|     2 | wordpress_6 |         2 | wordpress_q | example.net        |
|   109 | xf2         |       109 | xf2         | domain.com         |
+-------+-------------+-----------+-------------+--------------------+