delete multiple documents at once mongodb atlas

Question

I am only to delete one record at a time in Mongodb cloud db (Atlas). I have 60 records to delete and it is painful. I do not see an obvious way to delete multiple records at once. Is there a simple way to do this?

Solution

You actually can't bulk delete in MongoDB Atlas. See MongoDB Atlas info on the filter section AKA Data Explorer. However you can run standard queries, like find, remove once you connect to the database using your Atlas credentials.

At the clusters view, click connect on the cluster with the collection you would like to query/modify. Then follow the UI to get your connection string using Mongo Shell. If you need a GUI way to delete, you may consider Mongo Compass. Atlas also provides instructions how to connect via Compass on the same page.

Comments

[user8463989]

@where do I find that in Atlas? The only thing I see is a search type field that says FILTER with a FIND button next to it

[user8463989]

I have Compass but there isn't a way to delete multiple items at once. I was hoping it would be as easy as phpMyAdmin where you can check the records you want to remove and just click "delete"

[Sam Ulloa]

I think you are right that Compass doesn't allow for deleting multiple items at once. It seems you will have to use Mongo Shell to delete via query.

[Isaac Pak]

Why is this not a feature in atlas? I can't think of any database platforms I know of that do not have a multiple delete option.

[dang]

the question is about Atlas not mongo shell

[derekbaker783]

This answer isn't relevant anymore, as mLab is shutting down (and the question is tagged 'atlas' also).