MongoDB

Overview

MongoDB is a document-oriented NoSQL database that stores data as flexible, JSON-like BSON documents. It provides rich querying, indexing, aggregation pipelines, and horizontal scaling via sharding. MongoDB is available as a managed service on MongoDB Atlas, Amazon DocumentDB, and Azure Cosmos DB.

Driver

Crate: mongodb
Version: 3.6

Connection fields

Field	Description
Host	Hostname or IP address of the MongoDB server.
Port	TCP port the server listens on.
Database	Default database to connect to.
User	Authentication username.
Password	Authentication password. Stored in the macOS Keychain.
SSL Mode	One of `disable`, `prefer`, `require`, `verify-ca`, or `verify-full`.
SRV	Use `mongodb+srv://` DNS seed list connection format (required for Atlas).
Options	Additional connection parameters as `key1=val1&key2=val2`.

All connections also support an optional SSH tunnel. Configure the bastion host, port, user, and private key file under the SSH section of the connection form. SeeSSH tunnels for details.

URI format

Instead of filling in each field individually, you can paste a connection URI into thePaste URI field. Arris parses the URI and populates all fields automatically.

textConnection URI

mongodb://user:password@host:27017/dbname?tls=true

For MongoDB Atlas and other hosted services, use the mongodb+srv:// format with the SRV toggle enabled.

SSL & TLS

MongoDB supports five SSL modes. Arris defaults to prefer, which uses SSL if the server supports it but falls back to unencrypted if not.

SSL Mode	Behavior
`disable`	Never use SSL. Not recommended for production.
`prefer`	Use SSL if available, fall back to unencrypted.
`require`	Always use SSL. Fail if the server does not support it.
`verify-ca`	Require SSL and verify the server certificate against a CA.
`verify-full`	Require SSL, verify the CA, and verify the server hostname matches the certificate.

Schema browser

Once connected, Arris fetches the database and collection metadata. Databases act as top-level containers in the tree, each containing its own collections.

The schema tree displays the following object types, grouped by category:

Collections — collections and views

Double-click any collection or view to open it in a new tab with browse mode.

Query modes

Arris queries MongoDB in two modes, switched per editor tab.

SQL mode — SELECT, INSERT, UPDATE, and DELETE are translated to MongoDB find, aggregate, count, insertOne, update, and delete operations.
Native mode — write shell-style requests directly, such as db.orders.find({ status: "open" }) or an aggregation pipeline.

Supported SQL commands

Command	Notes
`SELECT`	Maps to `find` / `aggregate` over collections.
`INSERT`	Insert documents into a collection.
`UPDATE`	Update matching documents.
`DELETE`	Delete matching documents.

Unsupported SQL commands

Command	Notes
`CREATE` / `DROP`	Collections are created implicitly on first write.