THE MANGO FIELD GUIDE

Your workspace.
Explained.

From your first connection to your next aggregation.
Practical guides for working confidently with your data.

01 / GETTING STARTED

Your first few minutes.

Mango is a desktop workspace for MongoDB. Your connections live in the sidebar; collections, queries, and other tools open in tabs.

  1. Install and open Mango. Choose the installer for Windows, Mac, or Linux from the download page. Read the startup disclaimer and keep a current backup before changing important data.
  2. Add a connection. Click + beside Connections. Give it a recognizable name, such as Local development, and enter your MongoDB connection string.
  3. Explore a collection. Click your saved connection, expand a database and its Collections folder, then double-click a collection to open it.
  4. Make your first query. Enter a filter, click Apply, and switch between Grid, Tree, and JSON to inspect the result.
A comfortable place to start

Use a development database while you get familiar with the tools. Mango respects your MongoDB account’s permissions. A restricted database account is a useful extra safeguard when exploring production data.

02 / CONNECTIONS

Keep your databases close.

Save a name and connection string for each environment. Both mongodb:// and mongodb+srv:// connection strings are supported. Include the authentication and connection options your server requires.

Example · local development
mongodb://localhost:27017

Click a saved connection or its caret to connect. Double-click the connection to connect and expand it, or to fold and unfold an already connected entry. The status dot shows whether it is connected, connecting, or disconnected.

Arrange your workspace

Drag connections to change their order. Drag the divider beside the sidebar to adjust its width; double-click the divider to reset it. Both choices are saved automatically. Keep several collections open in tabs to move between tasks without rebuilding your query.

Connection actions

Right-click a connection for its available actions, including editing, refreshing, disconnecting, and removing the saved entry. Removing a saved connection removes its local configuration; it does not delete the server’s databases.

Live statistics charts connection counts, operation rates, network traffic, and memory. Samples are taken every five seconds while the tab is open, for up to 15 minutes. Server metrics lets you inspect the server response in Tree or JSON and refresh it when needed.

03 / EXPLORING

Find your way through the tree.

Expand a connection to see its databases, then expand a database to browse Collections and Views. Large lists have a filter so you can narrow the names without opening each item. Hover over a collection to inspect its statistics.

Create and organize

Right-click a connection to create a database. Right-click a Collections folder to add a collection. Collection context menus include Query, Aggregate, schema analysis, rename, and document operations.

Copy between collections

Select one or more collections, choose Copy collection, then right-click the destination Collections folder and choose Paste collection(s). Review the target and resolve any name conflicts before proceeding.

Use Ctrl/Cmd-click to select several collections, or Shift-click for a range. Refresh the relevant tree item after changes made outside Mango.

System databases are protected

admin, config, and local appear muted and are protected from data changes in Mango. You can hide them altogether in Settings → General.

Dropping a database removes its collections and data. Dropping a collection removes that collection and its documents. Destructive actions require confirmation; check the selected connection and database before confirming.

04 / QUERIES

Ask a more precise question.

Use the Query editor to filter a collection. JSON and object syntax are supported. Click Apply to execute the current draft. Editing a draft does not change the applied result until you run it.

Query · available products under $200
{ inStock: true, price: { $lt: 200 } }

Projection, sort, and limit

Expand More options to choose returned fields, order the results, and cap their total number. Collapsing these options keeps their values.

OptionExampleWhat it does
Projection{ name: 1, price: 1 }Includes these fields. MongoDB also returns _id unless you explicitly exclude it.
Sort{ price: 1, _id: -1 }Sorts by ascending price, then descending ID. Key order defines priority.
Limit100Caps the total result across all pages. 0 means no limit.

A little help while you type

Query, Projection, Sort, and aggregation editors suggest field names, including nested paths. Autocomplete samples the latest ten documents by descending _id and shares a one-minute cache. Use the arrow keys to select a suggestion, Enter or Tab to insert it, and Esc to dismiss it. A sample is a hint, not a complete schema: you can always type a field that is not suggested.

Build query offers operators and value skeletons; unused conditions are excluded and active conditions are combined with AND. Choose fields builds a projection, and Build sort lets you select and reorder sort priorities. These visual helpers sample up to twenty documents.

Regex · timestamps beginning with 2026
{ ts: /^2026/ }

// Case-insensitive text matching
{ name: /^studio/i }

The Query result view shows the full Node.js query, including the database, collection, filter, and sort. Use its copy icon to take the query into your own code. Explain helps you inspect how MongoDB plans the operation.

05 / DOCUMENTS

See the detail. Make the change.

Use Grid for rows and columns, Tree for nested objects and arrays, and JSON for the raw document structure. Change Rows per page or use the pager to explore more results.

Inspect a document

Right-click a document and choose View document for a dedicated viewer. Its search input is focused when it opens. Type to jump to matching text, then use Ctrl + ↑ or Ctrl + ↓ to move between hits. View document is unavailable when a grid selection spans several documents.

Edit values or whole documents

Double-click an editable string, number, or boolean in Grid or Tree, or use its context menu. Booleans use a true/false choice. Tree editing also supports nested fields and array items. Expand an object branch and use its Expand all or Collapse all controls when exploring deeper structures.

For a full document edit, use the document editing action. For insert, update, and delete operations, right-click the collection and choose Add/Update/Delete. Enter JSON or object syntax and review the result shown by the dialog.

Keep document identity intact

_id is read-only when editing. Keep it in the projection if you want to edit returned documents. When you insert a new document without an ID, MongoDB generates one.

06 / AGGREGATION

One stage at a time.

Right-click a collection and choose Aggregate to open a pipeline builder. Add stages, choose their operators, and enter values as JSON or object syntax. Enabled stages run from top to bottom; you can reorder, disable, or remove them.

Example pipeline · number of available products per category
[
  { $match: { inStock: true } },
  { $group: { _id: "$category", products: { $sum: 1 } } },
  { $sort: { products: -1 } }
]

Use "$fieldName" to refer to a document field in an expression. Stage editors support field suggestions and regex literals, just like the query editors.

Build up the result

Click Run aggregate to execute the enabled pipeline. With multiple stages, Run at stage 1, Run at stage 2, and the other intermediate controls let you inspect the pipeline up to that point. This is useful for finding the stage where a result changes unexpectedly.

Keep the pipeline or create a view

Use Save aggregate to keep a reusable pipeline draft. Choose Save as view, beside Run aggregate, to store the enabled pipeline as a named, read-only MongoDB view. Views appear in the tree alongside Collections and support queries, paging, and licensed exports.

Aggregation results are read-only in the result editor. Paging applies to the result of the full executed pipeline. The Query result view also shows Node.js code for aggregations.

07 / INDEXES

Give your queries a helping hand.

Expand a database’s Indexes folder, then a collection beneath it, to browse individual indexes. Right-click the folder or collection and choose Add index to set ordered keys, an optional name, and options.

Compound index keys
{ category: 1, createdAt: -1 }

1 means ascending and -1 means descending. Mango also supports specialized index types such as text, hashed, and 2dsphere. Choose keys and options that fit the queries you run.

Edit index supports visibility and TTL changes. Changing index keys, name, or other options requires recreating the index. Dropping an index keeps the documents but can change query performance, so it requires confirmation. The built-in _id_ index is protected from editing and dropping.

08 / EXPORT & CLIPBOARD

Take the right data with you.

With an active license, the Export menu downloads JSON or CSV, or copies JSON, CSV, or Excel-compatible tab-separated values to the clipboard. Export uses the full applied query or aggregation result, including its filter, projection, sort, and limit—not just the page currently on screen.

DestinationMaximum rowsMaximum size
Download100,00050 MiB
Clipboard export10,0005 MiB

If an export exceeds a limit, narrow the query or set a smaller Limit and run it again. Text values that could be interpreted as spreadsheet formulas are escaped in spreadsheet exports.

Copy and paste documents

Select grid rows by their row numbers, right-click, and choose Copy selected documents. In an editable collection, use Paste documents from the grid or collection context menu. Pasting removes top-level _id values so the inserted documents receive new IDs; embedded IDs are kept.

For a single value, use its copy action. Strings copy as plain text; objects and arrays copy as JSON. Review the target collection before pasting documents.

09 / SAVED WORK

Pick up where you left off.

Use Save query above the query editor or Save aggregate above the pipeline builder. Give the definition a name you will recognize later.

A saved query includes its filter, projection, sort, and limit. A saved aggregation includes the pipeline’s stage order and disabled stages. Definitions also retain their connection name and identifier, database, and collection as context.

Open Load query or Load aggregate to choose the matching definition type. Definitions for the current collection are ranked first, followed by the same database, the same connection, and other saved entries.

Loading gives you a draft

Loading replaces the current draft without running it or changing its target. Review the collection and values, then click Apply or Run aggregate. Saved definitions stay on this device; query text may contain sensitive data.

10 / AI & MCP

Bring your assistant into the workflow.

Mango’s built-in Model Context Protocol server lets a compatible AI assistant discover saved connections, explore databases and collections, and run read-only queries.

  1. Save a connection in Mango. The assistant selects a configured connection by its name or identifier; it does not need your connection string.
  2. Enable the server. Check that MCP shows Online in the bottom status bar. Click the MCP control to toggle it, or manage its port and enabled state in Settings → MCP.
  3. Add the endpoint to your assistant. Choose Streamable HTTP in a client that supports a server running on your computer.
  4. Ask a specific question. Name the connection, database, and collection you want to explore.
Default local endpoint
http://127.0.0.1:27000/mcp
Connect to Local, list its databases, and show five documents from app.users.

Replace the names in that example with your own. The read-only query tools return up to 200 documents. Mango’s licensing and database account permissions still apply.

Local means on this computer

127.0.0.1 refers to the machine making the request. A remotely hosted assistant cannot reach your computer using that address. Use a client that supports local MCP servers, or an appropriate connection method supported by that client. Returned database content is shared with the assistant, so choose an assistant you trust.

If you change the port, update the assistant’s endpoint too. Keep Mango open while the assistant is using its MCP server.

11 / PREFERENCES

Make it work your way.

Open File → Settings to change preferences. The General, Query, and MCP tabs keep related choices together; use Save changes to keep your edits.

General
Activate or check your license and choose whether to hide the protected admin, config, and local databases.
Query
Set the default sort for newly opened collections, show expanded query options by default, and choose equality shorthand in the visual query builder.
MCP
Enable or disable the local server and choose its port. The dialog shows the endpoint to use in your assistant.
Appearance
Switch between Dark theme and Light theme directly in the bottom status bar. Your preference is saved.

The default sort is { _id: -1 }. Set each sort direction to 1 or -1. Changed query defaults apply when you open new collection tabs.

12 / LICENSING

Know where you stand.

The bottom bar shows Licensed, Trial, or Expired. Open Settings → General to enter your license key and activate it, or check the current key again. An empty key is checked for trial access.

ModeAvailable features
LicensedMultiple saved connections and document exports.
TrialThe first saved connection is available. Export is disabled; additional saved connections are retained.
ExpiredDatabase operations are blocked until a valid license or trial grant is verified. Settings and disconnect remain available.

Working offline

Mango checks licensing on startup and every twelve hours. After a successful online verification, a valid license or trial grant can be used offline for up to three days from the verified response’s issue time, or until its earlier expiry. First use requires an online check.

If offline access ends, reconnect to the internet and check the license from Settings. An explicitly invalid or expired license cannot use the offline allowance. For purchase information, see Pricing.

13 / QUICK REFERENCE

A few useful shortcuts.

ActionControl
Select multiple collectionsCtrl/Cmd + click
Select a range of collectionsShift + click
Navigate field suggestions↑ / ↓
Insert a field suggestionEnter or Tab
Dismiss field suggestionsEsc
Previous / next document search hitCtrl + ↑ / Ctrl + ↓
Reset sidebar widthDouble-click its divider
14 / TROUBLESHOOTING

Get back into your flow.

My connection will not open.

Check the hostname, port, credentials, and authentication options in your connection string. Confirm that the MongoDB server is reachable from your computer and that its network rules allow access. Inspect the error beside the connection, correct the settings, and try again.

A field is missing from autocomplete.

Suggestions come from a small sample of recent documents, not every document in the collection. Type the field manually if it is absent from that sample. Nested field paths use dot notation, such as address.city.

I cannot edit a result.

Keep _id in the projection, check your database account’s write permissions, and make sure you are browsing an editable collection. Aggregation results, views, and protected system databases are read-only in Mango.

My export is disabled or too large.

Export requires an active license. If you are licensed and exceed the size or row limit, narrow the query or reduce Limit, click Apply, then export the new applied result.

My assistant cannot connect to MCP.

Keep Mango open, make sure MCP is Online, and compare the configured port with the assistant’s URL. Use Streamable HTTP. A remote service cannot reach your computer through 127.0.0.1; your assistant needs a supported way to access a local server.

My license shows Expired.

Open Settings → General and check your key with an internet connection. Check your computer’s date and time too. A new installation cannot verify offline, and previously verified offline access ends after at most three days.

Still need a hand?

Email info@mangodbtool.com with your app version and a description of the problem. Leave out passwords, license keys, and private database content.

Back to the guide ↑