Documentation
MotionQL docs
MotionQL is a desktop IDE for MongoDB, Atlas and MongoDB-compatible databases. Start with installing the app and activating your free Pro key, then pick a topic below. Press / to search.
Getting started
Connecting
- ConnectionsConnection strings, SRV, replica sets, sharded clusters, organizing and sharing connections.
- Authentication methodsSCRAM, X.509, LDAP, Kerberos, AWS IAM and OIDC.
- TLS, SSH and proxiesCertificates, SSH tunnels with jump hosts, and SOCKS5 or HTTP proxies.
- In-use encryption (CSFLE)Client-Side Field Level Encryption and Queryable Encryption with local or cloud KMS keys.
- Read-only and safety settingsPer-connection read-only mode, AI and server-side JavaScript switches.
Querying and editing
- Browsing and editing documentsThe explorer, tree, table and JSON views, in-place editing and document history.
- Query barFilter, projection, sort, skip, limit and query options in shell syntax.
- Visual query builderBuild filters with drag-and-drop conditions and AND/OR groups.
- Aggregation editorStage-by-stage pipelines with preview, templates and code generation.
- IntelliShellmongosh-style commands, autocomplete, history and the optional Script mode.
- SQL QueryRun SELECT statements against MongoDB collections.
- GridFS, views and transactionsFile buckets, views, multi-operation transactions and change streams.
Schema and performance
Moving data
- Import and exportJSON, JSON Lines, CSV, BSON, Excel and SQL INSERT files.
- Copy, dump and restoreCopy collections and use mongodump-compatible folders and archives.
- Compare and SyncDiff two collections field by field and sync the differences.
- SQL MigrationMove tables from PostgreSQL, MySQL, SQL Server and Oracle into MongoDB.
Automation and AI
Reference
Can't find an answer? Read the FAQ or contact support at support@motionql.com.