The Ultimate MongoDB Cheat Sheet for Developers

Connect MongoDB Shell

The MongoDB Shell connects to mongodb://127.0.0.1:27017 by default.

mongo

Connect to Local Network

mongo "mongodb://127.0.0.1:27017"

Connect to MongoDB Atlas

To connect to MongoDB Atlas, use the following command:

mongo "mongodbURI" --username <user>

Database Operation

Show All Databases

To show all databases in MongoDB, use the following command:

show databases

Show Current Database

To display the current database, use this command:

db

Create / Switch to New Database

To create or switch to a new database, simply use:

use <database_name> 

Delete Database

To delete a database in MongoDB, use the following command:

db.dropDatabase()

Collections

Show all collections of current DB

show collections

Create new Collection

 db.createCollection("newCollection") 

Create Documents

Insert one document

db.collection.insertOne({ name: "John Doe", age: 30 })

Insert multiple documents

db.collection.insertMany([
  { name: "Alice", age: 25 },
  { name: "Bob", age: 28 }
])

Read Documents

Find one document

db.collection.findOne({ name: "John Doe" })

Find multiple documents

db.collection.find({ age: { $gte: 25 } })

Find multiple documents with JSON

db.collection.find({ name: "Alice" })

Find documents by field value

db.collection.find({ age: 30 })

Find by element in array

db.collection.find({ hobbies: "reading" })

Update Documents

Update One

db.collection.updateOne(
  { name: "John" },
  { $set: { age: 30 } }
)

Update Multiple

db.collection.updateMany(
  { isActive: true },
  { $set: { status: "active" } }
)

Increment Field Value

db.collection.updateOne(
  { name: "Jane" },
  { $inc: { score: 5 } }
)

Rename Field

db.collection.updateMany(
  {},
  { $rename: { oldFieldName: "newFieldName" } }
)

Update Sub-Documents

db.collection.updateOne(
  { "profile.username": "john_doe" },
  { $set: { "profile.age": 25 } }
)

Delete Documents

Delete a Document

db.collection.deleteOne(
  { name: "John" }
)

Count

Returns the count of documents

db.collection.countDocuments()

Returns the count of documents that would match a find() query

db.collection.countDocuments({ status: "active" })

Sorting

Ascending Order

db.collection.find().sort({ age: 1 })

Descending Order

db.collection.find().sort({ age: -1 })

Results by Pagination

Skip 7 Results

db.collection.find().skip(7)

Fetch Only 4 Results

db.collection.find().limit(4)

Sort by Name, Skip First 7 Results, Fetch Only Next 4 Documents

db.collection.find().sort({ name: 1 }).skip(7).limit(4)

Add Index

Create Index on Single Field

db.collection.createIndex({ name: 1 })

Create Compound Index

db.collection.createIndex({ age: 1, status: -1 })

Drop Index

Drop Index

db.collection.dropIndex({ name: 1 })

Text Search

Create Text Index on Field

db.collection.createIndex({ description: "text" })

Search by Text

db.collection.find({ $text: { $search: "mongodb" } })

Find by Range Query

Find Courses Where Views Are Greater Than 70

db.collection.find({ views: { $gt: 70 } })

Find Courses Where Views Are Greater Than or Equal to 70

db.collection.find({ views: { $gte: 70 } })

Find Courses Where Views Are Less Than 70

db.collection.find({ views: { $lt: 70 } })

Find Courses Where Views Are Less Than or Equal to 70

db.collection.find({ views: { $lte: 70 } })

Conclusion

Congratulations! You’ve reached the end of . With these commands and techniques at your fingertips, you’re well-equipped to work efficiently with MongoDB in your projects.

Keep this cheat sheet handy as you build, query, and optimize your . And remember, is a powerful tool, so continue exploring its advanced features to learn its full potential.

Happy coding, and may your queries always be efficient! 🚀