Delete everything in a MongoDB database

Question

I'm doing development on MongoDB. For totally non-evil purposes, I sometimes want to blow away everything in a database—that is, to delete every single collection, and whatever else might be lying around, and start from scratch. Is there a single line of code that will let me do this? Bonus points for giving both a MongoDB console method and a MongoDB Ruby driver method.

Answer 1

In the mongo shell:

use [database];
db.dropDatabase();

And to remove the users:

db.dropAllUsers();

Answer 2

Also, from the command line:

mongo DATABASE_NAME --eval "db.dropDatabase();"

Answer 3

I had the same problem, when I needed to reset all the collections but didn't want to loose any database users. Use the following line of code, if you would like to save the user configuration for the database:

use <whichever database>
db.getCollectionNames().forEach(function(c) { if (c.indexOf("system.") == -1) db[c].drop(); })

This code will go through all collection names from one database and drop those which do not start with "system.".

Answer 4

I followed the db.dropDatabase() route for a long time, however if you're trying to use this for wiping the database in between test cases you may eventually find problems with index constraints not being honored after the database drop. As a result, you'll either need to mess about with ensureIndexes, or a simpler route would be avoiding the dropDatabase alltogether and just removing from each collection in a loop such as:

db.getCollectionNames().forEach(
  function(collection_name) {
    db[collection_name].remove()
  }
);

In my case I was running this from the command-line using:

mongo [database] --eval "db.getCollectionNames().forEach(function(n){db[n].remove()});"

Answer 5

db.getCollectionNames().forEach(c=>db[c].drop())

Answer 6

By compiling answers from @Robse and @DanH (kudos!), I've got the following solution which completely satisfies me:

db.getCollectionNames().forEach( function(collection_name) { 
  if (collection_name.indexOf("system.") == -1) 
       db[collection_name].drop();
  else  
       db[collection_name].remove({});
});

It cleans the database by dropping the user collections and emptying the system collections.

Answer 7

Here are some useful delete operations for mongodb using mongo shell

To delete particular document in collections: db.mycollection.remove( {name:"stack"} )

To delete all documents in collections: db.mycollection.remove()

To delete any particular collection : db.mycollection.drop()

to delete database : first go to that database by use mydb command and then

db.dropDatabase()

Answer 8

in case you'd need to drop everything at once: (drop all databases at once)

mongo --quiet --eval 'db.getMongo().getDBNames().forEach(function(i){db.getSiblingDB(i).dropDatabase()})'

Answer 9

Use

[databaseName]
db.Drop+databaseName();

drop collection 

use databaseName 
db.collectionName.drop();

Answer 10

I prefer

db.your_collection.remove({})

over

db.your_collection.drop()

If your collection was a special collection i.e a capped collection or a collection with one field marked as unique, dropping will clear the collection itself and when collection is again created it will be an ordinary collection. You will have to define the properties again. So use remove() to clear the documents without removing the collection and affecting the behavior of the collection.

Answer 11

if you want to delete only a database and its sub-collections use this :

• use <database name>;
• db.dropDatabase();

if you want to delete all the databases in mongo then use this :

db.adminCommand("listDatabases").databases.forEach(function(d)
             {
              if(d.name!="admin" && d.name!="local" && d.name!="config")
                {
                 db.getSiblingDB(d.name).dropDatabase();
                }
             }
          );

Answer 12

Simplest way to delete a database say blog:

> use blog
switched to db blog
> db.dropDatabase();
{ "dropped" : "blog", "ok" : 1 }

Answer 13

For Meteor developers.

1. Open a second terminal window while running your app in localhost:3000.

2. In your project's folder run, meteor mongo.

   coolName = new Mongo.Collection('yourCollectionName');

3. Then simply enter db.yourCollectionName.drop();

4. You'll automatically see the changes in your local server.

For everybody else.

db.yourCollectionName.drop();

Answer 14

To delete all DBs use:

for i in $(mongo --quiet --host $HOSTNAME --eval "db.getMongo().getDBNames()" | tr "," " ");

do mongo $i --host $HOSTNAME --eval "db.dropDatabase()";

done 

Answer 15

1. List out all available dbs show dbs
2. Choose the necessary db use
3. Drop the database db.dropDatabase() //Few additional commands
4. List all collections available in a db show collections
5. Remove a specification collection db.collection.drop()

Hope that helps

Answer 16

use <dbname>
db.dropAllUsers()
db.dropAllRoles()
db.dropDatabase()

MongoDB db.dropDatabase() documentation explaining the modification introduced in 2.6:

Changed in version 2.6: This command does not delete the users associated with the current database.

Answer 17

In MongoDB 3.2 and newer, Mongo().getDBNames() in the mongo shell will output a list of database names in the server:

> Mongo().getDBNames()
[ "local", "test", "test2", "test3" ]

> show dbs
local  0.000GB
test   0.000GB
test2  0.000GB
test3  0.000GB

A forEach() loop over the array could then call dropDatabase() to drop all the listed databases. Optionally you can opt to skip some important databases that you don't want to drop. For example:

Mongo().getDBNames().forEach(function(x) {
  // Loop through all database names
  if (['admin', 'config', 'local'].indexOf(x) < 0) {
    // Drop if database is not admin, config, or local
    Mongo().getDB(x).dropDatabase();
  }
})

Example run:

> show dbs
admin   0.000GB
config  0.000GB
local   0.000GB
test    0.000GB
test2   0.000GB
test3   0.000GB

> Mongo().getDBNames().forEach(function(x) {
...   if (['admin', 'config', 'local'].indexOf(x) < 0) {
...     Mongo().getDB(x).dropDatabase();
...   }
... })

> show dbs
admin   0.000GB
config  0.000GB
local   0.000GB

Answer 18

If you're using node js, you can drop all collections in every database like so:

//! USE WITH CAUTION: This code will drop all collections in every database
const mongo = new MongoClient(MONGO_URL)
const dbs = await mongo.db().admin().listDatabases()
for (const { name: dbName } of dbs.databases) {
    const db = mongo.db(dbName)
    const collections = await db.collections()

    for (const collection of collections) {
        try {
            await collection.drop() // Mongo won't let us drop the system collections so we catch and ignore those
        } catch (e) {}
    }
}