Studio 3T Features
Professional
Ultimate
+
SQL Integrations
Connect to popular SQL databases Postgres, Oracle, Sybase, DB2, MySQL, SQLServer
+
Bi-Directional Data Migration (SQL ⇔ Mongo)
Migrate data from Mongo to any SQL database
Transform MongoDB data before migrating it to SQL
Automate data migration workflows
+
Advanced Authentication & Security
Kerberos
OIDC
LDAP
AWS IAM
+
Authentication & Security
SSH tunnel
SSL support (TLS included)
SCRAM_SHA-1
SCRAM_SHA-256
X.509
+
MongoDB Connections
Replica set, sharded clusters
Copy/paste URLs
Import/export connections
Keystore to easily manage SSH credentials
+
Data Visualization
Explore document schema
Filter and deep dive into nested data
Navigate complex nested data with Table, Tree and JSON views
Filter and sort query results
Search across servers, databases and collections
View documents in read-only mode
+
Database Development
Drag and drop fields to build, find, and aggregate queries
Code editor to build and execute complex MongoDB scripts
Context aware auto completion assists with correct syntax and MongoDB functions
Understand and debug complex aggregation pipelines by breaking them down into individual stages
Build aggregation pipelines using natural language
Convert, find and aggregate queries to any programming language
Save and reuse queries
Maintain history of queries and scripts
Convert SQL queries into aggregation pipelines
+
Data Management
Make changes to individual or multiple documents directly from table data
Maintain a history of changes to collections
Manage schema of collections, add/modify/delete fields without having to write a single line of query
View data relations directly in a document
Import and export data of different formats to and from databases and files
Directly copy selected documents from query results
+
Database Management
Analyze schemas
Understand structure and distribution of documents
Compare documents and schema objects across environments and deploy changes
Define set of rules to validate an incoming document
View and manage GridFS buckets
View and manage indexes
Move individual or multiple collections and databases between environments
Transform data across environments
+
Performance and Optimization
Monitor database health in real-time
Filter and view all current operations executing on a MongoDB server
View the explain plan to understand query performance
Find and monitor slow running queries
+
Workflow Automation
Automate repetitive tasks such as data exports, backups and scripts to optimize workflows
+
Workspace
Create multiple workspaces with dedicated sets of connections and queries
Invite team members to collaborate within a workspace
Quickly share connections and queries with the team
Onboard new team members by inviting them to a workspace, with configured connections and saved queries
+
Personalize
Dark theme
Customize keyboard shortcuts
Restore last session
Color-code connections to safely know the environment while working with critical data