MongoDB Show all products from all collections.

Question

Is it possible to show all collections and their contents in MongoDB?

Is this the only way to show one by one?

Answer 1

Once you are in the terminal / command line, access the database / collection that you want to use as follows:

show dbs use <db name> show collections 

select your collection and enter the following to view all the contents of this collection:

 db.collectionName.find() 

Read more here in the MongoDB Quick Reference Guide .

Answer 2

Step 1: Browse all your databases:

 show dbs 

Step 2: Select a Database

 use your_database_name 

Step 3: Show Collections

 show collections 

This will list all the collections in the database of your choice.

Step 4: View All Data

 db.collection_name.find() 

or

 db.collection_name.find().pretty() 

Answer 3

 var collections = db.getCollectionNames(); for(var i = 0; i< collections.length; i++){ print('Collection: ' + collections[i]); // print the name of each collection db.getCollection(collections[i]).find().forEach(printjson); //and then print the json of each of its elements } 

I think this script can get what you want. It prints the name of each collection, and then prints its elements in json.

Answer 4

Before writing below, first log into your cmd or PowerShell

 TYPE: mongo //To get into MongoDB shell use <Your_dbName> //For Creating or making use of existing db 

To list all collection names, use any of the following options: -

 show collections //output every collection OR show tables OR db.getCollectionNames() //shows all collections as a list 

To display the entire contents of the collections or data, use the code below that was sent by Bruno_Ferreira.

 var collections = db.getCollectionNames(); for(var i = 0; i< collections.length; i++) { print('Collection: ' + collections[i]); // print the name of each collection db.getCollection(collections[i]).find().forEach(printjson); //and then print the json of each of its elements } 

Answer 5

Here:

 db.collection_name.find().toArray().then(...function...) 

Answer 6

This will do:

 db.getCollectionNames().forEach(c => { db[c].find().forEach(d => { print(c); printjson(d) }) }) 

Answer 7

I prefer a different approach if you use the mongo shell:

Others will answer first: use my_database_name then:

 db.getCollectionNames().map( (name) => ({[name]: db[name].find().toArray().length}) ) 

This query will show you something like this:

 [ { "agreements" : 60 }, { "libraries" : 45 }, { "templates" : 9 }, { "users" : 18 } ] 

You can use a similar approach with db.getCollectionInfos() this is very useful if you have so much data.