This command, when run in a MySQL compatible database like MariaDB will return a list of all the tables, in descending order of tables size in megabyes.

sizes-of-mariadb-tables.sql

select table_schema as database_name,
    table_name,
    round(
        sum((data_length + index_length + data_free)) / power(1024, 2),
        2
    ) as table_size
from information_schema.tables
where table_schema = 'table_name' -- put your database name here
    and table_type = 'BASE TABLE'
group by table_schema,
    table_name
order by table_size desc;