Mingo's documents browser is the most convenient way to browse, view and work with MongoDB documents.
To find and view documents, Mingo let's you define a query and a sorting object. Skip and limit are replaced with pagination. Projection is also omited to prevent confusion by showing the documents as they are. Also, Mingo handles huge documents easily.
The query editor has many hidden features you should know about.
⌘Enter
or just Enter
, depending on your settings. To refresh the documents' list, just press ⌘R
Mingo supports human-readable shorthands for dates in queries. Compare the following two queries:
{
"createAt": {
"$gte": ISODate("2020-02-21T00:00:00Z"), // or new Date(…)
"$lt": ISODate("2020-02-28T00:00:00Z") // or new Date(…)
}
}
{
"createdAt": #lastWeek
}
There are two main types of date shorthands available:
{"createdAt": #lastWeek}
will search for documents where createdAt is between the beginning and end of last week.{"createdAt": @2021-11-22}
will search for documents where createdAt is EXACTLY the moment of the start of that day.#today | since the start of the today |
#yesterday | during yesterday |
#tomorrow | during tomorrow |
#thisWeek | during the current week |
#thisMonth | during the current month |
#thisYear | during the current year |
#lastWeek | during the previous week |
#lastMonth | during the previous month |
#lastYear | during the previous year |
#lastYear | during the previous year |
#last{number}{period} #last2days, #last14weeks, #last3years | During the last {number} {period}. Use any number and one of the following periods: minutes, hours, days, weeks, months, years. This is case insesitive, so you may use #last4Years. |
#next{number}{period} #next2days, #next14weeks, #next3years | During the next {number} {period}. Use any number and one of the following periods: minutes, hours, days, weeks, months, years. This is case insesitive, so you may use #next4Years. |
#2021-11-22 | during any specific date |
#2021-11 | during any specific month |
#2021 | during any specific year |
#2021-11-22:2021-11-25 | between two dates, inclusive |
#2021-11:2021-12 | between two months, inclusive |
#2021-2022 | between two years, inclusive |
#since2017-10-03 | since any specific date |
#before2017-10-03 | before any specific date |
@2020-01-29T17:29:50+00:00ISO 8601 format, or any part of it, such as @2020-01-29, @2020-01-29T17:29, etc. These represent a specific moment, so the documents have to match exact moment.
Indexed fields can be searched swiftly by using the value as query.
So instead of providing an object as a query, such as {city: 'Amsterdam'}
, you can simply use Amsterdam
as the query. Mingo will try to find the phrase "Amsterdam" in ALL the indexed fields.
You can even use regular expressions as quick queries, such as /amsterdam/i
.
Mingo supports querying by regular expressions. For example: {firstName: /david/i}
.
You can even use regular expressions as quick queries, such as /david/i
.
This is a great feature, especially combined with Quick Search. Pressing ⌘G will paste the current clipboard value into the query field and submit it. The pasted value could be a regular query or just a phrase or _id copied from your admin or other app.
Mingo shows 50 documents per page. Click a document to view its content. Click on any field to expand its subdocuments. ⌘+click will expand the document (or field) recursively.
When a collection is opened for the first time, Mingo will try to pick a few fields to show as columns by default. Any changes you make to them will be saved as defaults for the collection.
Right-click any document to get a list of options and actions for that document.
Mingo supports actions upon multiple selected documents.
Right-click any field to get a list of options and actions for that field.
UNDO is available to reverse changes done by insert, update or remove operations. Press ⌘Z to open the list of recent changes to documents. You may then select the action to UNDO.