Try Studio 3T for Free
  1. Knowledge Base
  2. MongoDB Tutorials
  3. 13 Most Common MongoDB Commands

13 Most Common MongoDB Commands

As you get started with MongoDB, it will take some time to learn how to query, so we’ve compiled a list of the most common MongoDB commands and how they’re written.

As an alternative, we also show you how to run them – without typing a single line of code – using Studio 3T as a GUI.

1. MongoDB create database

There’s actually no command to do so – MongoDB automatically creates a database when a collection is created in it.

In Studio 3T: 

In the Connection Tree, right-click on the target server. Choose Add Database.

Right-click on the target server and choose Add Database

Name your database – and note the info message.

Name your newly created MongoDB database

Click on OK.  Make sure to add a collection!

2. MongoDB drop database

Command: 

db.dropDatabase()

//drops the current database you're in

In Studio 3T: 

Let’s drop (or delete) the newly created database, manatee.

Right-click on the target database. Choose Drop Database.

Right click on the target database and choose Drop database

Click Drop Database.

3. MongoDB show databases

Command:

db.adminCommand( { listDatabases: 1, nameOnly: true} )

// lists database names only

In Studio 3T:

No clicks needed here. You can view this information directly from the Connection Tree.

View the full list of databases directly from the Connection Tree

Skip the MongoDB commands, download Studio 3T, and be productive from Day One.

4. MongoDB show collections

Command:

db.getCollectionNames()

In Studio 3T:

In the Connection Tree, click on your target database.

Click on the Collections folder. This opens up the list of collections within that database.

Click on the target database then the Collections folder to show all collections.

5. MongoDB create collection

Command: 

db.createCollection("collectionName");

In Studio 3T:

Right-click on your target database. Choose Add Collection.

Right click on a database and choose Add Collection

Enter a collection name and configure the settings as needed under the Options, Storage Engine, Validator, and Collation tabs.

Enter a collection name and configure the right settings

Click Create.

6. MongoDB clear collection

Command: 

db.users.deleteMany({})

In Studio 3T: 

Right-click on your target collection. Choose Clear Collection.

Choose your target collection and click on Clear Collection

Click on Clear Collection.

7. MongoDB drop collection

Command: 

db.collection_name.drop()

In Studio 3T: 

Right-click on a target collection. Choose Drop Collection.

Right click on a target collection and choose Drop collection
Click Drop Collection.

8. MongoDB insert document

Command:

db.collectionName.insert({ field1: “value1”, field2: “value2” })

In Studio 3T: 

While in Table View or Tree View, right-click on any cell.

Choose Insert Document. This opens the Insert Document > JSON window.

Enter the key value pairs. There’s no need to create the _id field – MongoDB does this automatically.

Insert JSON document to be added

Click on Validate JSON to make sure the syntax is correct.

Click on Add Document if adding one document, or Add & Continue if adding more documents.

9. MongoDB update document

Command:

db.collection.updateOne(<filter>, <update>, <options>)

In Studio 3T: 

Studio 3T supports in-place editing, so all you need to do double-click on a value to edit it.

Double click to edit date in place.

Here’s the complete post on how MongoDB() update works in Studio 3T.

10. MongoDB remove document

Command:

db.collection.deleteOne()

In Studio 3T:

Right-click on your target document. Choose Remove Document.

Choose your target document and click Remove document

Click on Remove Document again.

To delete all documents from a collection, follow the instructions on how to clear a collection.

11. MongoDB add field

Command: 

{ $set: { <field1>: <value1>, ... } }

In Studio 3T:

Right-click on any cell while in Table View or Tree View. Go to Field > Add Field/Value.

  • Enter a field name (e.g. favorite-color)
  • Choose the right field type (e.g. String).
  • Define the field value (e.g. green).
  • Choose where to add the field to (e.g. Current document only).

Configure the settings of your new field as needed

Click on Add Field/Value.

12. MongoDB rename field

Command: 

db.<collection-name>.update({query}, {\$rename: { <field1> : <newName1> , <field2> : <newName2>}})

In Studio 3T: 

Let’s rename the field from favorite-color to color.

  1. Right-click any cell that contains the field you want to rename.
  2. Go to Field > Rename Field.
  3. Update the field name.
  4. Choose where the field name should be updated (e.g. All documents in collection).
  5. Click Rename.
    Rename a MongoDB field in your current document, all documents, or documents matching your query criteria

13. MongoDB remove field

Command:

db.<collection-name>.update({}, {$unset: {<field1>:1}}, false, true);

In Studio 3T:

Let’s remove the color field entirely.

  1. Right-click a cell with the field you want to delete.
  2. Choose to remove the field from the current document, documents matching a query, or all documents.Choose to remove a field from the current document, documents matching a query, or all documents
  3. Click Remove.

Want more MongoDB hacks?

Updated on July 2, 2020

Was this article helpful?

Leave a Comment