MongoDB: Create, List, Switch and Delete Databases
Table of Contents
1. Create a Database
MongoDB does not have a create database command. Use the use command with the name you want. This only switches to that database. The database is actually created when you insert the first document into it.
[mongop@recovery ~]$ /app/mongodb/7.0.43/bin/mongosh -u admin -p --authenticationDatabase admin
Enter password: ******
Current Mongosh Log ID: 6ae9d0ff1a508192743c2563
Connecting to: mongodb://@127.0.0.1:27017/?directConnection=true&serverSelectionTimeoutMS=2000&authSource=admin&appName=mongosh+2.12.0
Using MongoDB: 7.0.43
Using Mongosh: 2.12.0
mongosh 2.14.1 is available for download: https://www.mongodb.com/try/download/shell
For mongosh info see: https://www.mongodb.com/docs/mongodb-shell/
Enterprise test> show dbs
admin 132.00 KiB
config 72.00 KiB
local 72.00 KiB
Enterprise test>
# Create database
Enterprise test> use myFirstDB
switched to db myFirstDB
Enterprise myFirstDB>
Enterprise myFirstDB> show dbs
admin 132.00 KiB
config 72.00 KiB
local 72.00 KiB
Enterprise myFirstDB> db.students.insertOne({ name: "Ravi" })
{
acknowledged: true,
insertedId: ObjectId('6ae9d1641a508192743c2564')
}
Enterprise myFirstDB>
Enterprise myFirstDB> show dbs
admin 132.00 KiB
config 72.00 KiB
local 72.00 KiB
myFirstDB 8.00 KiB
Enterprise myFirstDB>
2. List All Databases
Only databases that contain data are listed. An empty database created with use alone will not appear.
Enterprise myFirstDB> show dbs
admin 132.00 KiB
config 72.00 KiB
local 72.00 KiB
myFirstDB 8.00 KiB
Enterprise myFirstDB>
// or
Enterprise myFirstDB> show databases
admin 132.00 KiB
config 72.00 KiB
local 72.00 KiB
myFirstDB 40.00 KiB
Enterprise myFirstDB>
3. Switch Between Databases
Use the same use command with the name of any database. To check which database you are currently in, run db.
Enterprise myFirstDB> use admin
switched to db admin
Enterprise admin>
// Check the current database
Enterprise admin> db
admin
Enterprise admin>
4. Delete a Database
First switch to the database you want to delete, then drop it. This deletes the current database and all its data, so confirm with db before running it.
Enterprise admin> use myFirstDB
switched to db myFirstDB
Enterprise myFirstDB>
// Confirm the current database
Enterprise myFirstDB> db
myFirstDB
Enterprise myFirstDB>
Enterprise myFirstDB> db.dropDatabase()
{ ok: 1, dropped: 'myFirstDB' }
Enterprise myFirstDB>
Enterprise myFirstDB> show dbs
admin 132.00 KiB
config 96.00 KiB
local 72.00 KiB
Enterprise myFirstDB>
Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.
Thank you
Rajasekhar Amudala