MongoDB client for Mac

List one host, or several host:port pairs for a replica set, and the primary is found for you. You can also paste a mongodb:// or mongodb+srv:// URL. Sign in with SCRAM-SHA-1, SCRAM-SHA-256, X.509 or AWS IAM, and set Auth Database when your user is defined in admin but you browse another database.

A host ending in .mongodb.net turns on SRV and TLS for you, which MongoDB Atlas requires. Add your IP address to the cluster’s access list first: traffic from an address that is not on it times out rather than failing.

New connections start with TLS off, and the driver has no fallback, so Preferred behaves as Required. Read Preference and Write Concern are set per connection, and the write concern goes out with every insert, update and delete, from the shell or from a grid save.

Through an SSH tunnel, only the first host in the list is used, so replica set discovery and failover are off for that session.

The query tab is a JavaScript shell that accepts mongosh syntax: unquoted keys, regex literals, ISODate(), variables, loops and forEach. It runs inside TablePro, so nothing else needs installing, and a variable you define stays available in every tab on the connection until you disconnect. Autocomplete offers collections, methods, nested field paths and the $ operators valid at the cursor.

A collection opens as a grid, with top-level fields as columns and nested objects as Extended JSON. An edited cell keeps its field’s type, so a date stays a date and an ObjectId stays an ObjectId, and an edit inside a nested object writes only the path that changed, such as address.city.

Insert Document and Edit Document take a whole document as Extended JSON. Edit Document reads it from the server again, and if someone changed or deleted it after the sheet opened, nothing is saved and the sheet says so. Remove Field on a cell sends $unset.

The filter bar reaches into nested objects and arrays of objects, so customer.country and items.sku filter directly. A field holding GeoJSON opens on the Map view.

Safe Mode treats every statement on a MongoDB connection as a write, because the driver cannot open a read-only session. The Alert and Safe Mode levels confirm each one, and Read-Only blocks them all.

The Structure tab lists each index with its fields in key order and its kind, such as hashed, text, 2dsphere or wildcard. Show DDL writes the createIndex calls that rebuild them, with every option the server reports.

Rename or remove a field across a whole collection from the same tab. Each change is one updateMany, shown in Preview SQL, and a field the $jsonSchema validator declares changes there too. The save is refused before anything is written when an index, a search index or a view still uses the name.

New Table creates a collection whose fields become a $jsonSchema validator, then builds the indexes you list. Views and time-series collections appear in the sidebar, and views open read-only.

Backup Dump writes each database you tick to a gzipped archive with mongodump, using the connection’s hosts, Auth Database, SRV and TLS settings, and a dump can be narrowed to single collections. Restore Dump runs mongorestore into the database you pick and keeps what is already there. Install the MongoDB Database Tools on your Mac first.

Import CSV, TSV, JSON, JSONL and XLSX files into a collection. Export collections or results as CSV, JSON, XLSX, Markdown, HTML, XML and MQL.

An MQL export is a .js file of insertMany calls that runs in mongosh, with each collection’s indexes and validator if you tick them. Top-level values keep their type, but a typed value nested in a subdocument or array, such as an ObjectId inside an array, is written as a string: export those collections as JSON or back them up with mongodump instead.

The iPhone and iPad app has no MongoDB driver. MongoDB connections synced from a Mac appear in its list but do not open.