MongoDB Show all contents from all collections

Question

Is it possible to show all collections and its contents in MongoDB   Is the only way to show one by one

User · Answer

step 1  Enter into the MongoDB shell      mongo   step 2  for the display all the databases      show dbs    step 3  for a select database       use  databases name    step 4  for statistics of your database      db stats     step 5  listing out all the collections tables       show collections   step 6 print the data from a particular collection      db  collection name  find   pretty

User · Answer

This will do   db getCollectionNames   forEach c   gt        db c  find   forEach d   gt            print c            printjson d

User · Answer

Before writing below queries first get into your cmd or PowerShell  TYPE  mongo               To get into MongoDB shell use  lt Your dbName gt         For Creating or making use of existing db   To List All Collection Names use any one from below options  -  show collections    output every collection   OR show tables   OR db getCollectionNames     shows all collections as a list   To show all collections content or data use below listed code which had been posted by Bruno Ferreira   var collections   db getCollectionNames    for var i   0  i lt  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

User · Answer

var collections   db getCollectionNames    for var i   0  i lt  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 might get what you want  It prints the name of each collection and then prints its elements in json

User · Answer

This way   db collection name find   toArray   then    function

User · Answer

I prefer another approach if you are using mongo shell  First as the another answers  use my database name then  db getCollectionNames   map   name    gt     name   db name  find   toArray   length      This query will show you something like this                               quot agreements quot    60                                       quot libraries quot    45                                       quot templates quot    9                                       quot users quot    19               You can use similar approach with db getCollectionInfos   it is pretty useful if you have so much data  amp  helpful as well

User · Answer

Once you are in terminal command line  access the database collection you want to use as follows   show dbs use  lt db name gt  show collections   choose your collection and type the following to see all contents of that collection   db collectionName find     More info here on the MongoDB Quick Reference Guide

User · Answer

Step 1  See all your databases   show dbs   Step 2  Select the database  use your database name   Step 3  Show the collections  show collections   This will list all the collections in your selected database   Step 4  See all the data  db collection name find      or  db collection name find   pretty

[mongodb] MongoDB Show all contents from all collections

Examples related to mongodb

Examples related to collections

Examples related to find