# Supported MongoDB® Commands, Data Types, and Operators

The following tables reflect which MongoDB® commands, data types, and operators are supported by SingleStore Kai.

## Query and Projection Operators

## Array Operators

| Operator   | Supported |
| ---------- | --------- |
| $all       | ✔         |
| $elemMatch | ✔         |
| $size      | ✔         |

## Bitwise Operators

| Operator      | Supported |
| ------------- | --------- |
| $bitsAllSet   | ✔         |
| $bitsAnySet   | ✔         |
| $bitsAllClear | ✔         |
| $bitsAnyClear | ✔         |

## Comment Operator

| Operator | Supported |
| -------- | --------- |
| $comment | ✔         |

## Comparison Operators

| Operator | Supported |
| -------- | --------- |
| $eq      | ✔         |
| $gt      | ✔         |
| $gte     | ✔         |
| $lt      | ✔         |
| $lte     | ✔         |
| $ne      | ✔         |
| $in      | ✔         |
| $nin     | ✔         |

## Element Operators

| Operator | Supported |
| -------- | --------- |
| $exists  | ✔         |
| $type    | ✔         |

## Evaluation Query Operators

| Operator    | Supported |
| ----------- | --------- |
| $expr       | ✔         |
| $jsonSchema | \[empty]  |
| $mod        | ✔         |
| $regex      | ✔         |
| $text       | ✔         |
| $where      | \[empty]  |

## Logical Operators

| Operator | Supported |
| -------- | --------- |
| $or      | ✔         |
| $and     | ✔         |
| $not     | ✔         |
| $nor     | ✔         |

## Projection Operators

| Operator   | Supported |
| ---------- | --------- |
| $          | ✔         |
| $elemMatch | ✔         |
| $meta      | \[empty]  |
| $slice     | ✔         |

## Update Operators

## Update Array Operators

| Operator          | Supported |
| ----------------- | --------- |
| $                 | ✔         |
| $\[]              | ✔         |
| $\[\<identifier>] | ✔         |
| $addToSet         | ✔         |
| $pop              | ✔         |
| $pullAll          | ✔         |
| $pull             | ✔         |
| $push             | ✔         |
| $pushAll          | \[empty]  |

## Update Bitwise Operators

| Operator | Supported |
| -------- | --------- |
| $bit     | ✔         |

## Update Field Operators

| Operator     | Supported |
| ------------ | --------- |
| $inc         | ✔         |
| $mul         | ✔         |
| $rename      | ✔         |
| $setOnInsert | ✔         |
| $set         | ✔         |
| $unset       | ✔         |
| $min         | ✔         |
| $max         | ✔         |
| $currentDate | ✔         |

## Update Modifiers

| Operator  | Supported |
| --------- | --------- |
| $each     | ✔         |
| $slice    | ✔         |
| $sort     | ✔         |
| $position | ✔         |

## Aggregation Pipeline Operators

## Aggregation Accumulator Expressions

| Operator      | Supported |
| ------------- | --------- |
| $sum          | ✔         |
| $integral     | ✔         |
| $shift        | ✔         |
| $avg          | ✔         |
| $first        | ✔         |
| $last         | ✔         |
| $max          | ✔         |
| $min          | ✔         |
| $push         | ✔         |
| $addToSet     | ✔         |
| $stdDevPop    | ✔         |
| $stdDevSamp   | ✔         |
| $accumulator  | \[empty]  |
| $firstN       | ✔         |
| $bottom       | ✔         |
| $bottomN      | ✔         |
| $lastN        | ✔         |
| $maxN         | \[empty]  |
| $mergeObjects | ✔         |
| $top          | ✔         |
| $topN         | ✔         |

## Arithmetic Operators

| Operator  | Supported |
| --------- | --------- |
| $abs      | ✔         |
| $add      | ✔         |
| $ceil     | ✔         |
| $divide   | ✔         |
| $exp      | ✔         |
| $floor    | ✔         |
| $ln       | ✔         |
| $log      | ✔         |
| $log10    | ✔         |
| $mod      | ✔         |
| $multiply | ✔         |
| $pow      | ✔         |
| $sqrt     | ✔         |
| $subtract | ✔         |
| $rand     | ✔         |
| $trunc    | ✔         |
| $round    | ✔         |

## Array Operators

| Operator       | Supported |
| -------------- | --------- |
| $arrayElemAt   | ✔         |
| $arrayToObject | ✔         |
| $concatArrays  | ✔         |
| $filter        | ✔         |
| $indexOfArray  | ✔         |
| $isArray       | ✔         |
| $objectToArray | ✔         |
| $range         | ✔         |
| $reverseArray  | ✔         |
| $reduce        | ✔         |
| $size          | ✔         |
| $slice         | ✔         |
| $zip           | ✔         |
| $in            | ✔         |
| $count         | ✔         |
| $first         | ✔         |
| $firstN        | ✔         |
| $sortArray     | \[empty]  |
| $last          | ✔         |
| $lastN         | ✔         |
| $map           | ✔         |
| $maxN          | \[empty]  |
| $minN          | \[empty]  |

## Boolean Operators

| Operator | Supported |
| -------- | --------- |
| $and     | ✔         |
| $or      | ✔         |
| $not     | ✔         |

## Comparison Operators

| Operator   | Supported |
| ---------- | --------- |
| $cmp       | ✔         |
| $eq        | ✔         |
| $gt        | ✔         |
| $gte       | ✔         |
| $lt        | ✔         |
| $lte       | ✔         |
| $ne        | ✔         |
| $in        | ✔         |
| $nin       | ✔         |
| $sortArray | \[empty]  |

## Conditional Expression Operators

| Operator | Supported |
| -------- | --------- |
| $cond    | ✔         |
| $ifNull  | ✔         |
| $switch  | ✔         |

## Custom Aggregation Expression Operators

| Operator     | Supported |
| ------------ | --------- |
| $accumulator | \[empty]  |
| $function    | \[empty]  |

## Data Size Operators

| Operator    | Supported |
| ----------- | --------- |
| $binarySize | ✔         |
| $bsonSize   | ✔         |

## Data Type Operators

| Operator  | Supported |
| --------- | --------- |
| $type     | ✔         |
| $isNumber | ✔         |

## Date Operators

| Operator        | Supported |
| --------------- | --------- |
| $dayOfWeek      | ✔         |
| $dayOfMonth     | ✔         |
| $dayOfYear      | ✔         |
| $year           | ✔         |
| $month          | ✔         |
| $week           | ✔         |
| $hour           | ✔         |
| $minute         | ✔         |
| $second         | ✔         |
| $millisecond    | ✔         |
| $dateToString   | ✔         |
| $isoDayOfWeek   | ✔         |
| $isoWeek        | ✔         |
| $dateFromParts  | ✔         |
| $dateToParts    | ✔         |
| $dateFromString | ✔         |
| $isoWeekYear    | ✔         |
| $dateAdd        | ✔         |
| $dateDiff       | ✔         |
| $dateSubtract   | ✔         |
| $dateTrunc      | ✔         |

## Literal Operator

| Operator | Supported |
| -------- | --------- |
| $literal | ✔         |

## Object Expression Operators

| Operator       | Supported |
| -------------- | --------- |
| $mergeObjects  | ✔         |
| $objectToArray | ✔         |
| $setField      | ✔         |
| $unsetField    | ✔         |

## Natural Operator

| Operator | Supported |
| -------- | --------- |
| $natural | \[empty]  |

## Set Operators

| Operator         | Supported |
| ---------------- | --------- |
| $setEquals       | ✔         |
| $setIntersection | ✔         |
| $setUnion        | ✔         |
| $setDifference   | ✔         |
| $setIsSubset     | ✔         |
| $anyElementTrue  | ✔         |
| $allElementsTrue | ✔         |

## Stage Operators

| Operator           | Supported |
| ------------------ | --------- |
| $collStats         | ✔         |
| $project           | ✔         |
| $match             | ✔         |
| $redact            | \[empty]  |
| $limit             | ✔         |
| $skip              | ✔         |
| $unwind            | ✔         |
| $group             | ✔         |
| $sample            | ✔         |
| $sort              | ✔         |
| $geoNear           | \[empty]  |
| $lookup            | ✔         |
| $merge             | ✔         |
| $out               | ✔         |
| $indexStats        | ✔         |
| $setWindowFields   | ✔         |
| $facet             | ✔         |
| $bucket            | \[empty]  |
| $bucketAuto        | \[empty]  |
| $sortByCount       | ✔         |
| $addFields         | ✔         |
| $replaceRoot       | ✔         |
| $count             | ✔         |
| $currentOp         | \[empty]  |
| $listLocalSessions | \[empty]  |
| $listSessions      | \[empty]  |
| $graphLookup       | ✔         |
| $changeStream      | ✔         |
| $densify           | \[empty]  |
| $documents         | ✔         |
| $fill              | \[empty]  |
| $unionWith         | ✔         |
| $planCacheStats    | \[empty]  |
| $unset             | ✔         |
| $replaceWith       | ✔         |
| $search            | \[empty]  |
| $searchMeta        | \[empty]  |
| $vectorSearch      | ✔         |

## String Operators

| Operator      | Supported |
| ------------- | --------- |
| $concat       | ✔         |
| $indexOfBytes | ✔         |
| $indexOfCP    | ✔         |
| $trim         | ✔         |
| $ltrim        | ✔         |
| $rtrim        | ✔         |
| $regexFind    | \[empty]  |
| $regexFindAll | \[empty]  |
| $regexMatch   | ✔         |
| $replaceOne   | ✔         |
| $replaceAll   | ✔         |
| $split        | ✔         |
| $strcasecmp   | ✔         |
| $strLenBytes  | ✔         |
| $strLenCP     | ✔         |
| $substr       | ✔         |
| $substrBytes  | ✔         |
| $substrCP     | ✔         |
| $toString     | ✔         |
| $toLower      | ✔         |
| $toUpper      | ✔         |
| $trim         | ✔         |

## System Variables

| Variable       | Supported |
| -------------- | --------- |
| $$CURRENT      | ✔         |
| $$CLUSTERTIME  | \[empty]  |
| $$DESCEND      | \[empty]  |
| $$KEEP         | \[empty]  |
| $$NOW          | \[empty]  |
| $$PRUNE        | \[empty]  |
| $$REMOVE       | ✔         |
| $$ROOT         | ✔         |
| $$SEARCH\_META | \[empty]  |

## Text Search Operator

| Operator | Supported |
| -------- | --------- |
| $meta    | \[empty]  |

## Timestamp Expression Operators

| Operator     | Supported |
| ------------ | --------- |
| $tsIncrement | ✔         |
| $tsSecond    | ✔         |

## Trigonometry Expression Operators

| Operator          | Supported |
| ----------------- | --------- |
| $sin              | ✔         |
| $cos              | ✔         |
| $tan              | ✔         |
| $asin             | ✔         |
| $acos             | ✔         |
| $atan             | ✔         |
| $atan2            | \[empty]  |
| $asinh            | \[empty]  |
| $acosh            | \[empty]  |
| $atanh            | \[empty]  |
| $sinh             | \[empty]  |
| $cosh             | \[empty]  |
| $tanh             | \[empty]  |
| $degreesToRadians | ✔         |
| $radiansToDegrees | ✔         |

## Type Conversion Operators

| Operator    | Supported |
| ----------- | --------- |
| $convert    | ✔         |
| $toBool     | ✔         |
| $toDate     | ✔         |
| $toDecimal  | ✔         |
| $toDouble   | ✔         |
| $toInt      | ✔         |
| $toLong     | ✔         |
| $toObjectId | ✔         |
| $toString   | ✔         |

## Variable Operators

| Operator | Supported |
| -------- | --------- |
| $map     | ✔         |
| $let     | ✔         |

## Miscellaneous Operators

| Operator        | Supported |
| --------------- | --------- |
| $denseRank      | ✔         |
| $documentNumber | ✔         |
| $getField       | ✔         |
| $rand           | ✔         |
| $rank           | ✔         |
| $sampleRate     | ✔         |

## Data Types

| Data Type               | Supported |
| ----------------------- | --------- |
| Double                  | ✔         |
| String                  | ✔         |
| Object                  | ✔         |
| Array                   | ✔         |
| Binary Data             | ✔         |
| ObjectId                | ✔         |
| Boolean                 | ✔         |
| Date                    | ✔         |
| Null                    | ✔         |
| 32-bit Integer (int)    | ✔         |
| Timestamp               | ✔         |
| 64-bit Integer (long)   | ✔         |
| MinKey                  | ✔         |
| MaxKey                  | ✔         |
| Decimal128              | ✔         |
| Regular Expression      | ✔         |
| JavaScript              | ✔         |
| JavaScript (with scope) | ✔         |
| Undefined               | ✔         |
| Symbol                  | ✔         |
| DBPointer               | ✔         |

## Indexes and Index Properties

## Indexes

| Property           | Supported |
| ------------------ | --------- |
| Single Field Index | ✔         |
| Compound Index     | ✔         |
| Multikey Index     | ✔         |
| Text Index         | \[empty]  |
| Wildcard Indexes   | \[empty]  |
| 2dsphere           | \[empty]  |
| 2d Index           | \[empty]  |
| GeoHaystackIndexes | \[empty]  |
| Hashed Index       | \[empty]  |

## Index Properties

| Property         | Supported |
| ---------------- | --------- |
| TTL              | \[empty]  |
| Unique           | ✔         |
| Partial          | \[empty]  |
| Case Insensitive | \[empty]  |
| Hidden           | \[empty]  |
| Sparse           | \[empty]  |
| Background       | \[empty]  |

## Cursor Methods

| Method                       | Supported |
| ---------------------------- | --------- |
| cursor.batchSize()           | ✔         |
| cursor.close()               | ✔         |
| cursor.isClosed()            | ✔         |
| cursor.collation()           | \[empty]  |
| cursor.comment()             | ✔         |
| cursor.count()               | ✔         |
| cursor.explain()             | ✔         |
| cursor.forEach()             | ✔         |
| cursor.hasNext()             | ✔         |
| cursor.hint()                | \[empty]  |
| cursor.isExhausted()         | ✔         |
| cursor.itcount()             | ✔         |
| cursor.limit()               | ✔         |
| cursor.map()                 | ✔         |
| cursor.maxScan()             | \[empty]  |
| cursor.maxTimeMS()           | \[empty]  |
| cursor.max()                 | \[empty]  |
| cursor.min()                 | \[empty]  |
| cursor.next()                | ✔         |
| cursor.noCursorTimeout()     | \[empty]  |
| cursor.objsLeftInBatch()     | ✔         |
| cursor.pretty()              | ✔         |
| cursor.readConcern()         | ✔         |
| cursor.readPref()            | ✔         |
| cursor.returnKey()           | \[empty]  |
| cursor.showRecordId()        | \[empty]  |
| cursor.size()                | ✔         |
| cursor.skip()                | ✔         |
| cursor.sort()                | ✔         |
| cursor.tailable()            | \[empty]  |
| cursor.toArray()             | ✔         |
| cursor.addOption()           | \[empty]  |
| cursor.allowDiskUse()        | \[empty]  |
| cursor.allowPartialResults() | \[empty]  |
| cursor.maxAwaitTimeMS()      | \[empty]  |
| cursor.tryNext()             | \[empty]  |

## Database Commands

## Administrative Commands

| Command                        | Supported |
| ------------------------------ | --------- |
| 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                       |           |

## Aggregation Commands

| Command   | Supported |
| --------- | --------- |
| aggregate | ✔         |
| count     | ✔         |
| distinct  | ✔         |
| mapReduce |           |

## Authentication Commands

| Command      | Supported |
| ------------ | --------- |
| authenticate | ✔         |
| getnonce     |           |
| logout       |           |

## Diagnostic Commands

| Command                 | Supported |
| ----------------------- | --------- |
| 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                 |           |

## Query and Write Operations

| Operation              | Supported |
| ---------------------- | --------- |
| delete                 | ✔         |
| find                   | ✔         |
| findAndModify          | ✔         |
| getLastError           |           |
| getMore                | ✔         |
| getPrevError           |           |
| insert                 | ✔         |
| parallelCollectionScan |           |
| resetError             |           |
| update                 | ✔         |
| Change streams         |           |
| GridFS                 | ✔         |

## Role Management Commands

| Command                  | Supported |
| ------------------------ | --------- |
| createRole               |           |
| dropRole                 |           |
| dropAllRolesFromDatabase |           |
| grantPrivilegesToRole    |           |
| grantRolesToRole         |           |
| invalidateUserCache      |           |
| revokePrivilegesFromRole |           |
| revokeRolesFromRole      |           |
| updateRole               |           |
| rolesInfo                |           |

## Sharding Commands

| Command                      | Supported |
| ---------------------------- | --------- |
| 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           |           |

## Session Commands

| Command                  | Supported |
| ------------------------ | --------- |
| abortTransaction         | ✔         |
| commitTransaction        | ✔         |
| endSessions              | ✔         |
| killAllSessions          | \[empty]  |
| killAllSessionsByPattern | \[empty]  |
| killSessions             | \[empty]  |
| refreshSessions          | \[empty]  |
| startSession             | \[empty]  |

## User Management Commands

| Command                  | Supported |
| ------------------------ | --------- |
| createUser               | \[empty]  |
| dropAllUsersFromDatabase | \[empty]  |
| dropUser                 | \[empty]  |
| grantRolesToUser         | \[empty]  |
| revokeRolesFromUser      | \[empty]  |
| updateUser               | \[empty]  |
| userInfo                 | \[empty]  |

***

Modified at: January 30, 2026

Source: [/cloud/reference/singlestore-kai/supported-mongodb-commands/](https://docs.singlestore.com/cloud/reference/singlestore-kai/supported-mongodb-commands/)

(An index of the documentation is available at /llms.txt)