MySQL query that returns tables, row counts, and size in megabytes.

table_sizes.sql

select
	`table_schema` as `database`,
	`table_name` as `table`,
	format(`table_rows`, 0) as `rows`,
	format(round(((`data_length` + `index_length`) / 1024 / 1024), 2), 2) as `megabytes`
from `information_schema`.`TABLES`
where `table_schema` != 'information_schema'
order by `database`, `data_length` + `index_length` desc;