Supported MongoDB® Commands, Data Types, and Operators

$all

✔

$elemMatch

✔

$size

✔

$bitsAllSet

$bitsAnySet

$bitsAllClear

$bitsAnyClear

$comment

✔

$eq

✔

$gt

✔

$gte

✔

$lt

✔

$lte

✔

$ne

✔

$in

✔

$nin

✔

$exists

✔

$type

✔

$expr

✔

$jsonSchema

$mod

✔

$regex

✔

$text

$where

$or

✔

$and

✔

$not

✔

$nor

✔

$

$elemMatch

$meta

$slice

$

✔

$[]

✔

$[<identifier>]

✔

$addToSet

✔

$pop

✔

$pullAll

✔

$pull

✔

$push

✔

$pushAll

$bit

✔

$inc

✔

$mul

✔

$rename

✔

$setOnInsert

✔

$set

✔

$unset

✔

$min

✔

$max

✔

$currentDate

✔

$each

✔

$slice

✔

$sort

✔

$position

✔

$sum

✔

$integral

$shift

$avg

✔

$first

✔

$last

✔

$max

✔

$min

✔

$push

✔

$addToSet

✔

$stdDevPop

✔

$stdDevSamp

✔

$integral

$shift

$accumulator

$firstN

✔

$bottom

✔

$bottomN

✔

$lastN

✔

$maxN

$mergeObjects

✔

$top

✔

$topN

✔

$abs

✔

$add

✔

$ceil

✔

$divide

✔

$exp

✔

$floor

✔

$ln

✔

$log

✔

$log10

✔

$mod

✔

$multiply

✔

$pow

✔

$sqrt

✔

$subtract

✔

$rand

✔

$trunc

✔

$round

✔

$arrayElemAt

✔

$arrayToObject

✔

$concatArrays

✔

$filter

✔

$indexOfArray

✔

$isArray

✔

$objectToArray

✔

$range

✔

$reverseArray

✔

$reduce

✔

$size

✔

$slice

✔

$zip

✔

$in

✔

$count

✔

$first

✔

$firstN

✔

$sortArray

$last

$lastN

✔

$map

✔

$maxN

$minN

$and

✔

$or

✔

$not

✔

$cmp

✔

$eq

✔

$gt

✔

$gte

✔

$lt

✔

$lte

✔

$ne

✔

$in

✔

$nin

✔

$sortArray

$cond

✔

$ifNull

✔

$switch

✔

$accumulator

$function

$binarySize

✔

$bsonSize

✔

$type

✔

$isNumber

✔

$dayOfWeek

✔

$dayOfMonth

✔

$dayOfYear

✔

$year

✔

$month

✔

$week

✔

$hour

✔

$minute

✔

$second

✔

$millisecond

✔

$dateToString

✔

$isoDayOfWeek

✔

$isoWeek

✔

$dateFromParts

✔

$dateToParts

✔

$dateFromString

✔

$isoWeekYear

✔

$dateAdd

✔

$dateDiff

✔

$dateSubtract

✔

$dateTrunc

✔

$literal

✔

$mergeObjects

$objectToArray

✔

$setField

✔

$unsetField

✔

$natural

$setEquals

$setIntersection

$setUnion

✔

$setDifference

✔

$setIsSubset

✔

$anyElementTrue

✔

$allElementsTrue

✔

$collStats

✔

$project

✔

$match

✔

$redact

$limit

✔

$skip

✔

$unwind

✔

$group

✔

$sample

✔

$sort

✔

$geoNear

$lookup

✔

$merge

✔

$out

✔

$indexStats

$setWindowFields

✔

$facet

$bucket

$bucketAuto

$sortByCount

✔

$addFields

✔

$replaceRoot

✔

$count

✔

$currentOp

$listLocalSessions

$listSessions

$graphLookup

✔

$changeStream

$densify

$documents

✔

$fill

$unionWith

$planCacheStats

$unset

✔

$replaceWith

✔

$search

$searchMeta

$concat

✔

$indexOfBytes

✔

$indexOfCP

✔

$trim

✔

$ltrim

✔

$rtrim

✔

$regexFind

$regexFindAll

$rgexMatch

$replaceOne

✔

$replaceAll

✔

$split

✔

$strcasecmp

✔

$strLenBytes

✔

$strLenCP

✔

$substr

✔

$substrBytes

✔

$substrCP

✔

$toString

✔

$toLower

✔

$toUpper

✔

$trim

✔

$$CURRENT

✔

$$CLUSTERTIME

$$DESCEND

$$KEEP

$$NOW

$$PRUNE

$$REMOVE

✔

$$ROOT

✔

$$SEARCH_META

$meta

$tsIncrement

✔

$tsSecond

✔

$sin

✔

$cos

✔

$tan

✔

$asin

✔

$acos

✔

$atan

✔

$atan2

$asinh

$acosh

$atanh

$sinh

$cosh

$tanh

$degreesToRadians

✔

$radiansToDegrees

✔

$convert

✔

$toBool

✔

$toDate

✔

$toDecimal

✔

$toDouble

✔

$toInt

✔

$toLong

✔

$toObjectId

✔

$toString

✔

$map

✔

$let

✔

$denseRank

✔

$documentNumber

✔

$getField

✔

$rand

✔

$rank

✔

$sampleRate

✔

Single Field Index

✔

Compound Index

✔

Multikey Index

✔

Text Index

Wildcard Indexes

2dsphere

2d Index

GeoHaystackIndexes

Hashed Index

TTL

Unique

✔

Partial

Case Insensitive

Hidden

Sparse

Background

Capped Collections

cloneCollectionAsCapped

collMod

collMod: expireAfterSeconds

convertToCapped

copydb

create

✔

createView

createIndexes

✔

currentOp

✔

drop

✔

dropDatabase

✔

dropIndexes

✔

filemd5

killCursors

✔

killOp

listCollections

✔

listDatabases

✔

listIndexes

✔

reIndex

renameCollection

fsync

fsyncUnlock

getDefaultRWConcern

getAudtifConfig

getClusterParameter

getParameter

logRotate

rotateCertificates

setFeatureCompatibilityVersion

setIndexCommitQuorum

setClusterParameter

setParameter

setDefaultRWConcern

shutdown

aggregate

✔

count

✔

distinct

✔

mapReduce

authenticate

✔

getnonce

logout

buildInfo

✔

collStats

✔

connPoolStats

connectionStatus

✔

dataSize

dbHash

dbStats

✔

explain

✔

explain: executionStats

✔

features

getCmdLineOpts

getLog

hostInfo

listCommands

ping

✔

profile

serverStatus

shardConnPoolStats

✔

top

validate

validateDBMetadata

whatsmyuri

driverOIDTest

_isSelf

lockinfo

netstat

delete

✔

find

✔

findAndModify

✔

getLastError

getMore

✔

getPrevError

insert

✔

parallelCollectionScan

resetError

update

✔

Change streams

GridFS

createRole

dropRole

dropAllRolesFromDatabase

grantPrivilegesToRole

grantRolesToRole

invalidateUserCache

revokePrivilegesFromRole

revokeRolesFromRole

updateRole

rolesInfo

abortReshardCollection

addShard

addShardToZone

balancerCollectionStatus

balancerStart

balancerStatus

balancerStop

checkShardingIndex

clearJumboFlag

cleanupOrphaned

cleanupReshardCollection

commitReshardCollection

configureCollectionBalancing

enableSharding

flushRouterConfig

getShardMap

getShardVersion

isdbgrid

listShards

medianKey

moveChunk

movePrimary

moveRange

mergeChunks

refineCollectionShardKey

removeShard

removeShardFromZone

reshardCollection

setAllowMigrations

setShardVersion

shardCollection

✔

shardingState

split

splitVector

unsetSharding

updateZoneKeyRange

abortTransaction

✔

commitTransaction

✔

endSessions

✔

killAllSessions

killAllSessionsByPattern

killSessions

refreshSessions

startSession

createUser

dropAllUsersFromDatabase

dropUser

grantRolesToUser

revokeRolesFromUser

updateUser

userInfo