How to display all databases along with their sizes in ASCENDING/DESCENDING order in MongoDB

Question

I have more than 600 databases in my MongoDB system. Whenever i run command show dbs it returns databases with their sizes in alphabetical order. I want to get databases in Ascending or Descending order.
Is that possible in MongoDB ?

Answer 1

You can write simple java scripts inside shell

db.adminCommand("listDatabases").databases
    .sort(function(l, r) {
         return r.sizeOnDisk - l.sizeOnDisk})
    .forEach(function(d) {
         print(d.name + " - " + d.sizeOnDisk)});

Or invoke shell with passing the script:

mongo --quiet  --eval 'db.adminCommand("listDatabases").databases.sort(function(l, r) {return r.sizeOnDisk - l.sizeOnDisk}).forEach(function(d) {print(d.name + " - " + d.sizeOnDisk)});'