If you like you can review the "data_sources" subroutine defined here:
https://metacpan.org/pod/DBI If you find the completely Generic way to list databases Lacking - here are few particular solutions: In Particular for PostgreSQL: This lists databases: SELECT datname as database FROM pg_database WHERE datistemplate = false; This lists tables in the current database SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name; https://dba.stackexchange.com/questions/1285/how-do-i-list-all-databases-and-tables-using-psql https://dba.stackexchange.com/a/1304 In Particular for Mysql: show databases OR SELECT SCHEMA_NAME AS Database FROM INFORMATION_SCHEMA.SCHEMATA https://stackoverflow.com/questions/4366905/perl-dbi-dbdmysql-get-the-databases-name-from-mysql-server In Particular for Oracle (what mysql and postgress call "Database" Oracle calls "Schema"): https://stackoverflow.com/a/298771 SELECT USERNAME as SCHEMA FROM ALL_USERS ORDER BY USERNAME; Or SELECT USERNAME as SCHEMA FROM DBA_USERS ORDER BY USERNAME; Or SELECT DISTINCT OWNER as SCHEMA from ALL_OBJECTS order by OWNER; Or SELECT DISTINCT OWNER as SCHEMA from DBA_OBJECTS order by OWNER; https://dba.stackexchange.com/questions/27725/how-to-see-list-of-databases-in-oracle https://stackoverflow.com/questions/8739203/oracle-query-to-fetch-column-names https://stackoverflow.com/questions/4833459/oracle-sql-query-for-listing-all-schemas-in-a-db https://ss64.com/orad/ALL_OBJECTS.html https://ss64.com/orad/DBA_OBJECTS.html In particular for SQLServer (SQLServer has both databases and schemas - schemas are like Oracle schemas, databases are groups of schemas). SELECT name FROM master.sys.databases SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA SELECT CATALOG_NAME AS DataBaseName FROM INFORMATION_SCHEMA.SCHEMATA https://stackoverflow.com/questions/147659/get-list-of-databases-from-sql-server https://stackoverflow.com/questions/3719623/how-do-i-obtain-a-list-of-all-schemas-in-a-sql-server-database https://stackoverflow.com/questions/873393/sql-server-query-to-find-all-current-database-names https://stackoverflow.com/questions/5323740/difference-between-database-and-schema The information contained in this electronic mail transmission is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibited and that you should delete the contents of this transmission from your system immediately. Any comments or statements contained in this transmission do not necessarily reflect the views or position of Radial or its subsidiaries and/or affiliates.
