How to iterate over all MongoDB databases?

To iterate over all MongoDB databases, you need to switch your database to admin. Following is the query to switch to admin and get information about all the databases

> switchDatabaseAdmin = db.getSiblingDB("admin");
admin
> allDatabaseName = switchDatabaseAdmin.runCommand({ "listDatabases": 1 }).databases;

This will produce the following output

[
   {
      "name" : "admin",
      "sizeOnDisk" : 495616,
      "empty" : false
   },
   {
      "name" : "config",
      "sizeOnDisk" : 98304,
      "empty" : false
   },
   {
      "name" : "local",
      "sizeOnDisk" : 73728,
      "empty" : false
   },
   {
      "name" : "sample",
      "sizeOnDisk" : 1335296,
      "empty" : false
   },
   {
      "name" : "sampleDemo",
      "sizeOnDisk" : 278528,
      "empty" : false
   },
   {
      "name" : "studentSearch",
      "sizeOnDisk" : 262144,
      "empty" : false
   },
   {
      "name" : "test",
      "sizeOnDisk" : 8724480,
      "empty" : false
   }
]

Arjun Thakur

Updated on: 30-Jul-2019

287 Views

Kickstart Your Career

Get certified by completing the course

Get Started