Cacher is the code snippet organizer for pro developers

SELECT table_schema "DB",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "SizeMB" 
FROM information_schema.tables 
GROUP BY table_schema
order by "SizeMB" desc;