Show Menu

MongoDB Cheat Sheet by

MongoDB
development     database     mongodb     nosql

Basic commands

mongo
Start Mongo
show dbs
Show databases
use mydb
User database named "­myd­b"
db
Show selected database
help
Get help
show collec­tions
Show collec­tions from a database

Finds - db.col­lection

.find()
Displays documents from "­col­lec­tio­n" (first 10)
it
Type "­it" to see more documents after the prev command
.find(query[,fields])
Find all documents by condit­ions, with optional fields selection
.findO­ne(­query)
Find one document by conditions
.find(query).limit(n:number)
Find n document by conditions
.find(­).p­retty()
Format results in Mongo Shell
.find().sort(key:1|-1)
Sort by key in ascending (1) or descending (-1) order
.find(­).s­kip(5)
Skip 5 documents (similar to offset)

Modify - db.col­lection

.insert(document(s) [,options])
Insert a new document or multiple docume­nts(if provided an array of documents) in the collec­tion. Options: writeC­oncern, ordered
.inser­tOn­e(d­ocu­ment, [,opti­ons])
Same as insert from 3.2
.inser­tMa­ny(­array of documents, [,opti­ons])
Same as in sert from 3.2
.updat­e(q­uery, update [,opti­ons])
Update the documents matched by the query. See update operators. Options: upsert­(insert if no match), multi(aply to multiple elements), writeC­oncern
.remov­e(query [,opti­ons])
Remote some documents from a collec­tion. {} for all. options: {justOne, writeC­oncern}
.delet­eOn­e(q­uery), delete­Man­y(q­uery)
Similar to remove
 

Queries

_id
Search by ID
key: value
Search through key-value combin­ation
{ subkey: value }
Search with subdoc­ument
$in : [ e1, e2, .. ]
Search IN Array
queries are repres­ented through JSON objects

Query Selectors : Element

$exist­s:B­oolean
Check if property exists or not
$mod:[D,R]
Checks if a property divided by D has the specified R
$type:Int
Checks if property is the specified type

Query Selectors : Comparison

$gt­:Val
Greater then Val
$gte­:Val
Greater then equals Val
$lt­:Val
Lower then Val
$lte­:Val
Lower then equals Val
$all­:­Array
All Array elements are included in field array value
$in­:Array
Elements with values contained in Array
$nin­:­Array
Elements with values Not contained in Array
$ne­:Val
Not equal
Val can be any Scalar Integer, String, Date, etc

Query Selectors : Logical

$and:AOE
AND operation between all AOE expres­sions
$nor:AOE
all AOE expres­sions must fail
$not:Expr
Negate a SubDoc­ument (doesn't work with $regex)
$or:AOE
OR operation between all AOE expres­sions
Expr = Expression
AOE = Array Of Expres­sions
( eg: Expression = price : 20 )

Download the MongoDB Cheat Sheet

1 Page
//media.cheatography.com/storage/thumb/ovi-mihai_mongodb.750.jpg

PDF (recommended)

Alternative Downloads

Share This Cheat Sheet!

Like this cheat sheet? Check out our sponsors!

Readability-Score.com is a collection of tools to make your writing better. More readabile content means higher conversion rates and better reader engagement. Measure website and document readability, measure keyword density and more!

Click Here To Get Started!

 

Comments

Alexander Alexander, 10:13 11 Jun 15

Hello, could you update this cheatsheet with insert, update and remove operations?

ovi_mihai ovi_mihai, 18:57 23 Jan 16

I'm on it, but I have so little time this days :(

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          MySQL Cheat Sheet
          SQL Server Cheat Sheet

          More Cheat Sheets by ovi_mihai

          JIRA Cheat Sheet