Provide a summary of information about MySQL Schemas for a given instance.

mysql_schemas.sql

SELECT   table_schema,
         SUM(data_length+index_length)/1024/1024 AS total_mb,
         SUM(data_length)/1024/1024 AS data_mb,
         SUM(index_length)/1024/1024 AS index_mb,
         COUNT(*) AS tables,
         CURDATE() AS today
FROM     information_schema.tables
WHERE    table_schema NOT IN ('mysql','information_schema','performance_schema','sys','_doit_statpack_mysql')
GROUP BY table_schema
ORDER BY 2 DESC;

SELECT   table_schema,engine,table_type, table_collation,
         COUNT(*) AS tables
FROM     information_schema.tables
WHERE    table_schema NOT IN ('mysql','information_schema','performance_schema','sys','_doit_statpack_mysql')
GROUP BY table_schema,engine,table_type,table_collation;