Database Commands

On this page

All command documentation outlined below describes a command and its available parameters and provides a document template or prototype for each command. Some command documentation also includes the relevantmongoshell helpers.

To run a command against the current database, usedb.runCommand():

  1. db
  2. .
  3. runCommand
  4. (
  5. {
  6. <
  7. command
  8. >
  9. }
  10. )

To run an administrative command against theadmindatabase, usedb.adminCommand():

  1. db
  2. .
  3. adminCommand
  4. (
  5. {
  6. <
  7. command
  8. >
  9. }
  10. )

NOTE

For details on specific commands, including syntax and examples, click on the specific command to go to its reference page.

User Commands

Aggregation Commands

Name Description
aggregate Performsaggregation taskssuch as group using the aggregation framework.
count Counts the number of documents in a collection or a view.
distinct Displays the distinct values found for a specified key in a collection or a view.
group Deprecated. Groups documents in a collection by the specified key and performs simple aggregation.
mapReduce Performsmap-reduceaggregation for large data sets.

Geospatial Commands

Name Description
geoNear Performs a geospatial query that returns the documents closest to a given point.
geoSearch Performs a geospatial query that uses MongoDB’shaystack indexfunctionality.

Query and Write Operation Commands

Name Description
delete Deletes one or more documents.
eval Deprecated. Runs a JavaScript function on the database server.
find Selects documents in a collection or a view.
findAndModify Returns and modifies a single document.
getLastError Returns the success status of the last operation.
getMore Returns batches of documents currently pointed to by the cursor.
getPrevError Returns status document containing all errors since the lastresetErrorcommand.
insert Inserts one or more documents.
parallelCollectionScan Lets applications use multiple parallel cursors when reading documents from a collection.
resetError Resets the last error status.
update Updates one or more documents.

Query Plan Cache Commands

Name Description
planCacheClear Removes cached query plan(s) for a collection.
planCacheClearFilters Clears index filter(s) for a collection.
planCacheListFilters Lists the index filters for a collection.
planCacheListPlans Displays the cached query plans for the specified query shape.
planCacheListQueryShapes Displays the query shapes for which cached query plans exist.
planCacheSetFilter Sets an index filter for a collection.

Database Operations

Authentication Commands

Name Description
authenticate Starts an authenticated session using a username and password.
authSchemaUpgrade Supports the upgrade process for user data between version 2.4 and 2.6.
copydbgetnonce This is an internal command to generate a one-time password for use with thecopydbcommand.
getnonce This is an internal command to generate a one-time password for authentication.
logout Terminates the current authenticated session.

User Management Commands

Name Description
createUser Creates a new user.
dropAllUsersFromDatabase Deletes all users associated with a database.
dropUser Removes a single user.
grantRolesToUser Grants a role and its privileges to a user.
revokeRolesFromUser Removes a role from a user.
updateUser Updates a user’s data.
usersInfo Returns information about the specified users.

Role Management Commands

Name Description
createRole Creates a role and specifies its privileges.
dropRole Deletes the user-defined role.
dropAllRolesFromDatabase Deletes all user-defined roles from a database.
grantPrivilegesToRole Assigns privileges to a user-defined role.
grantRolesToRole Specifies roles from which a user-defined role inherits privileges.
invalidateUserCache Flushes the in-memory cache of user information, including credentials and roles.
revokePrivilegesFromRole Removes the specified privileges from a user-defined role.
revokeRolesFromRole Removes specified inherited roles from a user-defined role.
rolesInfo Returns information for the specified role or roles.
updateRole Updates a user-defined role.

Replication Commands

Name Description
applyOps Internal command that appliesoplogentries to the current data set.
isMaster Displays information about this member’s role in the replica set, including whether it is the master.
replSetFreeze Prevents the current member from seeking election asprimaryfor a period of time.
replSetGetConfig Returns the replica set’s configuration object.
replSetGetStatus Returns a document that reports on the status of the replica set.
replSetInitiate Initializes a new replica set.
replSetMaintenance Enables or disables a maintenance mode, which puts asecondarynode in aRECOVERINGstate.
replSetReconfig Applies a new configuration to an existing replica set.
replSetStepDown Forces the currentprimaryto_step down_and become asecondary, forcing an election.
replSetSyncFrom Explicitly override the default logic for selecting a member to replicate from.
resync Forces amongodto re-synchronize from themaster. For master-slave replication only.

SEE ALSO

Replicationfor more information regarding replication.

Sharding Commands

Name Description
addShard Adds ashardto asharded cluster.
addShardToZone Associates a shard with azone. Supports configuringzonesin sharded clusters.
balancerStart Starts a balancer thread.
balancerStatus Returns information on the balancer status.
balancerStop Stops the balancer thread.
checkShardingIndex Internal command that validates index on shard key.
cleanupOrphaned Removes orphaned data with shard key values outside of the ranges of the chunks owned by a shard.
enableSharding Enables sharding on a specific database.
flushRouterConfig Forces an update to the cluster metadata cached by amongos.
getShardMap Internal command that reports on the state of a sharded cluster.
getShardVersion Internal command that returns theconfig serverversion.
isdbgrid Verifies that a process is amongos.
listShards Returns a list of configured shards.
medianKey Deprecated internal command. SeesplitVector.
moveChunk Internal command that migrates chunks between shards.
movePrimary Reassigns theprimary shardwhen removing a shard from a sharded cluster.
mergeChunks Provides the ability to combine chunks on a single shard.
removeShard Starts the process of removing a shard from a sharded cluster.
removeShardFromZone Removes the association between a shard and azone. Supports configuringzonesin sharded clusters.
setShardVersion Internal command to sets theconfig serverversion.
shardCollection Enables the sharding functionality for a collection, allowing the collection to be sharded.
shardingState Reports whether themongodis a member of a sharded cluster.
split Creates a newchunk.
splitChunk Internal command to split chunk. Instead use the methodssh.splitFind()andsh.splitAt().
splitVector Internal command that determines split points.
unsetSharding Internal command that affects connections between instances in a MongoDB deployment.
updateZoneKeyRange Adds or removes the association between a range of sharded data and azone. Supports configuringzonesin sharded clusters.

SEE ALSO

Shardingfor more information about MongoDB’s sharding functionality.

Instance Administration Commands

Name Description
clean Internal namespace administration command.
clone Copies a database from a remote host to the current host.
cloneCollection Copies a collection from a remote host to the current host.
cloneCollectionAsCapped Copies a non-capped collection as a newcapped collection.
collMod Add options to a collection or modify a view definition.
compact Defragments a collection and rebuilds the indexes.
connPoolSync Internal command to flush connection pool.
connectionStatus Reports the authentication state for the current connection.
convertToCapped Converts a non-capped collection to a capped collection.
copydb Copies a database from a remote host to the current host.
create Creates a collection or a view.
createIndexes Builds one or more indexes for a collection.
currentOp Returns a document that contains information on in-progress operations for the database instance.
drop Removes the specified collection from the database.
dropDatabase Removes the current database.
dropIndexes Removes indexes from a collection.
filemd5 Returns themd5hash for files stored usingGridFS.
fsync Flushes pending writes to the storage layer and locks the database to allow backups.
getParameter Retrieves configuration options.
killCursors Kills the specified cursors for a collection.
killOp Terminates an operation as specified by the operation ID.
listCollections Returns a list of collections in the current database.
listIndexes Lists all indexes for a collection.
logRotate Rotates the MongoDB logs to prevent a single file from taking too much space.
reIndex Rebuilds all indexes on a collection.
renameCollection Changes the name of an existing collection.
repairCursor Returns a cursor that iterates over all valid documents in a collection.
repairDatabase Rebuilds the database and indexes by discarding invalid or corrupt data.
setFeatureCompatibilityVersion Enables or disables MongoDB 3.4 features that persist data that are backwards-incompatible with MongoDB 3.2.
setParameter Modifies configuration options.
shutdown Shuts down themongodormongosprocess.
touch Loads documents and indexes from data storage to memory.

Diagnostic Commands

Name Description
availableQueryOptions Internal command that reports on the capabilities of the current MongoDB instance.
buildInfo Displays statistics about the MongoDB build.
collStats Reports storage utilization statics for a specified collection.
connPoolStats Reports statistics on the outgoing connections from this MongoDB instance to other MongoDB instances in the deployment.
cursorInfo Removed in MongoDB 3.2. Replaced withmetrics.cursor.
dataSize Returns the data size for a range of data. For internal use.
dbHash Returns hash value a database and its collections.
dbStats Reports storage utilization statistics for the specified database.
diagLogging Provides a diagnostic logging. For internal use.
driverOIDTest Internal command that converts an ObjectId to a string to support tests.
explain Returns information on the execution of various operations.
features Reports on features available in the current MongoDB instance.
getCmdLineOpts Returns a document with the run-time arguments to the MongoDB instance and their parsed options.
getLog Returns recent log messages.
hostInfo Returns data that reflects the underlying host system.
isSelf Internal command to support testing.
listCommands Lists all database commands provided by the currentmongodinstance.
listDatabases Returns a document that lists all databases and returns basic database statistics.
netstat Internal command that reports on intra-deployment connectivity. Only available formongosinstances.
ping Internal command that tests intra-deployment connectivity.
profile Interface for thedatabase profiler.
serverStatus Returns a collection metrics on instance-wide resource utilization and status.
shardConnPoolStats Reports statistics on amongos’s connection pool for client operations against shards.
top Returns raw usage statistics for each database in themongodinstance.
validate Internal command that scans for a collection’s data and indexes for correctness.
whatsmyuri Internal command that returns information on the current client.

Auditing Commands

Name Description
logApplicationMessage Posts a custom message to the audit log.