Questions tagged [mongodb-compass]

MongoDB Compass is MongoDB’s own GUI tool for database management, visualization, and CRUD operations. It supports the latest MongoDB versions and is available on Linux, Mac, or Windows. mongodb-compass tag should be used when posting questions related to this tool.

The GUI for MongoDB. Visually explore your data. Run ad hoc queries in seconds. Interact with your data with full CRUD functionality. View and optimize your query performance. Available on Linux, Mac, or Windows. Compass empowers you to make smarter decisions about indexing, document validation, and more.


Development:

All versions of MongoDB Compass are source available and free to use. You can find the source repositories for MongoDB Compass at https://github.com/mongodb-js/compass/.

Running Compass locally requires Node.js and npm:

  • Node.js: ^12.4.0
  • npm: >=6.13.0
npm install
npm start [compass|compass-readonly|compass-isolated]

For issues, create a ticket in JIRA Project.

Is there anything else you’d like to see in Compass? Submit suggestions in our feedback forum.

478 questions
0
votes
1 answer

mongoDB Compass distinct query renders no results

I've been trying to write a distinct query against my mongoDB collection housed in Atlas. I wanted to get a list of all the distinct values captured within the "Section" attribute under its "MetaData" parent attribute. According to the mongoDB…
darthal
  • 543
  • 1
  • 3
  • 12
0
votes
1 answer

MongoDB aggregation: modify elements with a specific value in sub-sub-array

I have a MongoDB database having this kind of document structure: { "CustomerID": 2019, "Segment": "SME", "Currency": "EUR", "Transactions": [ { "Date": 201302, "Consumption": 26.34 }, { "Date": 201303, …
0
votes
1 answer

Getting the amount of days a person is employed - mongodb

I am new to mongodb and I have a task to calculate the amount of days a person is/was employed and get the 5 employees, who were employed for longest time. I have written some code, but the amount of days is always null. Here is my…
0
votes
0 answers

MongoDB Shell sum result is 0 but on Compass its not

I have a MongoDB collection that collects usage stats from the network in Octets. I have the following query that gives me at least a non 0 sum in MongoDB Compass but it give me 0 when I run it on MongoShell. db.audit_auth_2022_05.aggregate([ …
0
votes
1 answer

mongoDB compass database makes every letter a new element

So I try to import a json file in a database {"name":"Mark", "age":"25" } When I try to import the file I get it back like 0:"M" 1:"a" 2:"r" 3:"k" _id:objectId('etc') and then inside a whole other element _id:objectId('etc') value:25 The id is…
Sabin789
  • 15
  • 6
0
votes
0 answers

How to restore collection in mongodb compass?

I have changed the collection in MongoDB compass(values of some fields) and I need to restore it to how it was before changing. Unfortunately, I haven`t backup file.
0
votes
0 answers

How to restrict user from extracting data in mongodb with only read access

I have created role with read access and assign it to user. The user is able to extract data from MongoDB Compass who is having only read access. How I can stop extraction access of these role?
0
votes
1 answer

How to find value from nested object with key wildcard in Compass MongoDB?

I have one nested object in Compass MongoDB: { "data_rm": { "pembiayaan": { "name": "pembiayaan", "value": "asuransi", "type": "radio", "title": "" }, "asuransi": { "name": "asuransi", …
Bonifacius Sarumpaet
  • 1,263
  • 1
  • 8
  • 21
0
votes
1 answer

Having problem in connecting to remote MongoDB Server

I tried to connect a remote MongoDB Server running on Ubuntu using MongoDB Compass on Windows. But I have problems connecting always as the IP of the Windows machine changes every day. I did the following things to connect to the remote server- Got…
Shrey
  • 146
  • 10
0
votes
1 answer

Imporing data manually with GUI MongoDB causes ReferenceError: collection is not defined?

I'm getting this error on an existing collection when I tried to aggregate to join two collections show dbs Bankerise 172 kB admin 102 kB config 73.7 kB local 73.7 kB use Bankerise switched to db Bankerise show…
0
votes
0 answers

Mongo DB compass is installed but not able to launch or open app

Mongo DB community edition is installed successfully but MongoDBCompass is not auto launching..I could even see MongoDBCompass icon created in desktop and able to search in taskbar...but I am not able to launch or open app by clicking on it...it…
0
votes
1 answer

How to have an array of all ids as a result of a mongodb projection?

I have the following query: @Query(value = "{ '_id': { \$in : ?0 } }", fields = "{ 'ids': '\$_id', '_id': 0 }") fun findExistingIds(ids: Set): Mono The ExistingIds is a class that contains a List of Strings: data class…
Aris
  • 984
  • 8
  • 22
0
votes
0 answers

Exceeded memory limit for $group, but didn't allow external sort. Pass allowDiskUse:true to opt in

I am new to MongoDB. I have worked on Legacy Mainframe and DB2. I have created a Pipeline through Aggregation Builder in MongoDB Compass. I need to export the result set of my Aggregation Query in a 'json' file. The result should be download the…
0
votes
0 answers

Issue with connecting the mongo cluster

I have an error: querySrv ENOTFOUND _mongodb._tcp.12345 connecting to cluster in Mongo compass and my password contains '@'. Any suggestions to fix it??
0
votes
2 answers

mongo shell ReferenceError: database_name not found

Hello I've been using mongodb with mongo shell and I keep having the same problem. While the database called Videos exists in MongoDB Compass and I can use it and add data to it, when I try to access it from the mongosh with this…
whatevahhh
  • 47
  • 6