How to execute update ($set) queries in MongoDB Compass tool?

Question

I'm new to MongoDB Compass tool and am trying to update a field in my collection. Please can someone suggest where the update query must be written. Could find no options or panes in the tool to write custom queries be it selection / updation for that matter.

In the Default Window only the selection/projection/restriction options are found. Any help is much appreciated.

Almost 5 years later and this is still not possible unless using the shell — Adam Reis, Aug 18 '22 at 02:16

score 64 · Accepted Answer · edited Jun 10 '22 at 08:56

64

In the latest version, there is a "_MongoSH" in the bottom left corner of the window. Thx to @Boštjan Pišler for the hint about a new feature.

Old answer: I had the same issue, it looks like a simple feature to implement (since document updates are possible) but... AFAIK there is no such option in compass, you can do it through mongodb shell (CLI client).

edited Jun 10 '22 at 08:56

Didier L

18,905
10
61
103

answered Jul 26 '18 at 13:09

Ivan Marjanovic

979
1
9
15

1

Please refer comment from @Bostjan below, looks like there is a way now, although in beta. – Devarshi Nov 01 '20 at 16:38
Unfortunately, as of now the option for mongoshell is removed from compass. – Mohamed abdelmagid Aug 20 '23 at 12:07
@Mohamedabdelmagid i still see it in latest compass for Linux 1.39.2. – Ivan Marjanovic Aug 23 '23 at 08:53
Oh, thanks, for pointing that out, it seems it was removed for version 1.39.1 on Mac, now that I upgraded it's there again. – Mohamed abdelmagid Aug 23 '23 at 09:49

Boštjan Pišler · Answer 2 · 2021-06-09T09:06:23.857

46

The tool was recently updated with a shell (currently in beta) which is accessible by clicking the dark bar on the bottom of the window "_MongoSH"

edited Jun 09 '21 at 09:06

answered Sep 23 '20 at 15:51

Boštjan Pišler

842
11
18

I'm using compass for months and I realised it now, thanks. – yalcinozer Oct 04 '21 at 17:59

fabriciorissetto · Answer 3 · 2023-04-27T13:04:40.473

22

At the bottom left, _MONGOSH:

There you can call updateMany and any other methods available in the MongoSH syntax

Worth to mention that before running your commands you may want to change the default DB by using use my-db-name:

use book-store-db
# now the variable `db` points to the book-store-db

db.getCollection("books").updateMany({"year":"2022"}, [{ $set: { "price":"0"} }])

edited Apr 27 '23 at 13:04

answered Sep 01 '22 at 21:34

fabriciorissetto

9,475
5
65
73

3

worth to add that you need to write `use my-db-name` if the shell is not pointing to your desired db – AnnetteC Apr 11 '23 at 07:33
Thanks @AnnetteC. I updated the answer to mention it. – fabriciorissetto Apr 27 '23 at 13:05

score 4 · Answer 4 · answered Apr 01 '21 at 08:56

4

You can use mongo MongoSH. Currently its in Beta.

answered Apr 01 '21 at 08:56

Mahesh Gareja

1,652
2
12
23

score -33 · Answer 5 · answered Apr 19 '18 at 18:11

-33

Just move your mouse over a document and find a little pencil. You will enter in update mode. You can change fields, values, arrays, etc.

answered Apr 19 '18 at 18:11

Arturo

27

27

@Pat is obviously asking about a way to execute an update statement, e.g. `db.collection.updateMany()` – kpentchev Jun 13 '18 at 11:48

How to execute update ($set) queries in MongoDB Compass tool?

5 Answers5