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
✓
✓
Filter and sort query results
✓
✓
Search across server, database and collection
✓
✓
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
✓
✓