Features
Everything you need to work with MongoDB
One desktop app from first connection to production migration. Here is all of it.
Connections and authentication
- Connection Manager with folders, tags, colors and dev / staging / prod environments, with a production warning banner
- Standalone, seed lists, mongodb+srv, replica sets with read preference and tags, sharded clusters, direct and load-balanced connections, Unix sockets
- TLS with CA and client certificates; SSH tunnels with password or key, host-key pinning and up to four jump hosts; SOCKS5 and HTTP proxies
- SCRAM-SHA-256/1, X.509, LDAP, Kerberos, AWS IAM and OIDC (browser sign-in, plus workload identity for Azure, GCP and Kubernetes)
- Quick connect with Cmd/Ctrl+1–9, health indicator, and export/import with secrets stripped or password-encrypted
Collection tab and query builder
- Filter, projection, sort, skip and limit in shell syntax, or build them visually
- Tree, table and JSON views with a column picker and in-place editing
- Collation, read and write concern, read preference, maxTimeMS and hint; cancel any query
- Explain tab, plus a COLLSCAN warning badge on slow filters, without running the query
- Document version history with one-click revert; copy as Extended JSON or shell
IntelliShell
- mongosh-style commands with autocomplete, history, snippets, Query Assist and explain
- Commands are parsed as literals, never eval'd, so nothing you paste can execute
- Optional Script mode runs real JavaScript (variables, loops, functions) in a local QuickJS sandbox
- Common helpers including rs.*, sh.*, db.aggregate and exact NumberLong math
Aggregation editor
- Stage-by-stage preview of the documents after every stage
- Full operator library, options and templates
- Convert any find into a pipeline in one click
- AI pipeline debugging when you want it
SQL Query and Query Code
- Read-only SELECT with joins, grouping and ordering, translated to MongoDB find or aggregate
- Open and save .sql files
- Generate code for mongo shell, Node.js, Python, Java, C#, PHP, Ruby, Go and Rust from deterministic templates
Import, export, compare and sync
- JSON, JSON Lines, CSV, BSON, Excel and SQL INSERT, with column mapping and typing
- Insert, upsert, replace and merge modes; streamed jobs with progress and cancel
- Copy collections; dump and restore in mongodump layout or a single archive file
- Data Compare & Sync with field-level diffs, dry-run preview, selective sync and conflict policies
SQL Migration and Data Masking
Pro- Migrate from PostgreSQL, MySQL, MariaDB, SQL Server and Oracle
- Choose reference or embed for each relationship, with preview and progress
- Data Masking with eleven methods and a preview before anything is written
- Reschema operations to restructure documents safely
Schema and Data Model
- Schema analysis with CSV, Markdown and HTML reports
- Schema Compare & History: snapshots, drift, and validator, index and option diffs
- ER diagrams inferred from field names, DBRefs, views and matching values; export to PNG, SVG, Mermaid and JSON
- Value Search across databases and collections
Administration and monitoring
- Index management with hidden indexes, $indexStats usage, live build progress and Index Review
- Server monitoring, running operations with kill, query profiler and topology view
- Users and custom roles with a privilege inspector
- GridFS browser, views, transactions with dry-run, change stream viewer, oplog history
- In-use encryption: CSFLE and Queryable Encryption
MongoDB Atlas
Pro- Organizations, projects, clusters, database users and IP access lists
- Pause and resume clusters
- Create a connection from any cluster
- Atlas Search and Vector Search index management
Tasks and dashboards
Pro- Schedule exports, imports, copies, compares, masking, migrations, dumps, scripts and index reviews
- Once, interval, daily, weekly and cron schedules with a run log
- A background runner keeps tasks going while the app is closed; run them from scripts with --cli
- Dashboards with ten chart types on live aggregations, shared filters, present mode and PDF export
AI assistant
- Gemini, Anthropic Claude, or any OpenAI-compatible endpoint including local models, with your own key
- Natural language to find, aggregation and SQL; explain plans; fix errors; index advice
- Ask Your Database for natural-language lookups
- Off for every connection until you allow it. Sends schema, never document values or credentials
Security and governance
- Read-only, AI and server-side JavaScript policies enforced in the app's main process
- Secrets encrypted with your OS keychain and never shown in the UI
- Local audit log with credential redaction; app lock with idle timeout
- Machine-wide policy.json for MDM and GPO, validated fail-closed
Team Server
Enterprise- Self-hosted, with OpenID Connect SSO (Okta, Entra ID, Google Workspace) and SCIM 2.0
- Shared connections (never with secrets), queries, scripts, snippets and tasks with version history
- Signed policies applied by every desktop as a floor, even offline
- Hash-chained central audit log you can forward to your SIEM
Platforms
- macOS (Apple Silicon and Intel), Windows and Linux (AppImage, deb, rpm)
- MongoDB 4.4 and later: Community, Enterprise and Atlas
- Amazon DocumentDB, Azure Cosmos DB for MongoDB and FerretDB
- Signed installers and automatic updates you can turn off by policy
Your next query deserves a better IDE.
Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.