Studio 3T Features

Import / Export Wizard

How to Export MongoDB to SQL, CSV, JSON, and another collection using Studio 3T

Run, automate, and schedule your import/export tasks with Studio 3T's convenient wizard. SQL, JSON, CSV and BSON/mongodump formats are supported, and you can always export entire collection(s) or view(s), current queries, current query results, and specific documents

Read More

Visual Query Builder

The Visual Query Builder for MongoDB | MongoDB Tutorial for Beginners

MongoDB query building doesn’t get any simpler than this. Our clever drag-and-drop builder makes it easy to construct and run MongoDB queries. Just click on the Query Builder button on the right of the window to enable, drag a document into the field, and change the operators for the perfect result. Experience the simplest way of building a MongoDB query - only on our MongoDB client.

Read More

In-Place Data Editing

Need to make a quick change to a document? Double-click on the value and overwrite it. It’s as simple as this, taking only a few seconds.

Read More

Table, Tree & JSON View

#4 Three Ways to View MongoDB Data - Studio 3T Tips & Tricks | MongoDB Tutorial

You get three ways to view your MongoDB data in Studio 3T. If you're into visualizing hierarchies, there's Tree View. If you prefer to view documents the old school way, there's JSON View with a built-in editor for real-time, lossless editing. Then there's Table View - the most powerful of all - which can handle any document size and lets you hide columns and step into cells and columns, even array-valued ones.

Read More

IntelliShell

IntelliShell - The mongo Shell with Autocompletion | The GUI for MongoDB

Forget the MongoDB shell as you know it - Studio 3T has IntelliShell, the richest editing experience of any MongoDB GUI. Save time and let it autocomplete JavaScript standard library functions, shell-specific types and methods, operators, collection names, field names, shell helper commands, further completions on return values, and more. It’s an essential part of using MongoDB.

Read More

Aggregation Editor

Write complex aggregate queries with greater confidence and accuracy: With Studio 3T’s Aggregation Editor, you can break down your queries into stages, allowing you to apply various pipeline operators and check your results at every step.

Read More

Query CodePRO

Generate driver code from your MongoDB and SQL queries with Query Code, Studio 3T’s code generation feature. Convert your queries to one of five target languages - JavaScript (Node.js), Java, Python, C#, PHP, Ruby, and the mongo shell language - for an easy copy + paste job from Studio 3T and into your application.

Read More

Visual Explain

Visual Explain - Studio 3T MongoDB GUI

View query plans and execution statistics stage by stage, and gather helpful information like execution times, stage outputs, and amount of data processed at a glance.

Read More

Tasks

Tasks - Studio 3T MongoDB GUI

Configure and save frequently-run jobs like imports, exports, migrations, and data comparisons, so you can later execute them on demand.

Read More

Task SchedulerENT

Task Scheduler - Studio 3T MongoDB GUI

Take Tasks up a notch with Task Scheduler, which adds a scheduling functionality to fully automate repetitive MongoDB jobs.

Read More

SQL to MongoDB MigrationENT

How Migrate SQL Tables into MongoDB Using Studio 3T | The GUI for MongoDB

Import entire SQL databases or multiple SQL tables to a single MongoDB collection, and map table relationships (one-to-one, one-to-many) to JSON exactly as you need. Supports Oracle, MS SQL Server, MySQL, PostgreSQL, Sybase, and IBM DB2.

Read More

MongoDB to SQL MigrationENT

How to Migrate MongoDB to a SQL Database Using Studio 3T | The GUI for MongoDB

Export single or multiple MongoDB collections to a SQL file or database, and map MongoDB fields to SQL tables and columns before the export is run.

Read More

SQL QueryPRO

SQL Querying in MongoDB | Studio 3T - The GUI for MongoDB

Know SQL but new to NoSQL? Be productive from day one with SQL Query. Write SQL expressions and joins to query MongoDB and view your SQL query's equivalent code in the mongo shell language, Java, JavaScript (Node.js), Python, C#, and PHP.

Read More

SQL Import/ExportPRO

SQL Import / Export - Studio 3T MongoDB GUI

Let our Import/Export Wizard do the hard work. We of course support all the major SQL databases for your convenience: Oracle, MS SQL Server, MySQL, and PostgreSQL. Available in Pro and Enterprise versions of our software.

Read More

LDAP & Kerberos AuthenticationENT

LDAP & Kerberos - Studio 3T MongoDB GUI

If you have a MongoDB Enterprise license, our Enterprise edition is the perfect complement. Easily deploy LDAP and Kerberos, its two supported authentication methods, while enjoying the full range of Studio 3T's advanced features.

Read More

Import from OracleENT

Studio 3T Enterprise users can now import Oracle to MongoDB with our Import Wizard. Simply download the Oracle JDBC driver, update the settings under the JDBC Drivers tab in Preferences, and let Studio 3T load the rest dynamically.

Studio 3T supports SQL import to MongoDB for all the major SQL databases: Oracle (Enterprise version only), Microsoft SQL Server, MySQL, and PostgreSQL.

Read More

Enterprise InstallerENT

Enterprise Installer - Studio 3T MongoDB GUI

For the Enterprise Edition of Studio 3T a special Enterprise installer for Microsoft Windows is available. This features an MSI installer to ease deploying Studio 3T at scale within the Enterprise. Also, in this Enterprise version the auto-update feature is removed.

Read More

Enterprise License ManagementENT

Do you have a large team of Studio 3T users? Our Enterprise edition lets you manage license key installations through Windows Group Policies / Administrative Templates files, which are included in the Enterprise .MSI download bundle, so you don't have to bother with the hassle of tracking them manually.

Read More

Color-Coded Connections

Color Coded Connections - Studio 3T MongoDB GUI

Studio 3T makes your life easier. With just one right-click of your mouse, you can assign, for example, a red color to your live MongoDB database to ensure that you can easily differentiate between live and test databases.

Read More

Read-Only Lock

Read Only Lock - Studio 3T MongoDB GUI

Worried that your MongoDB query results will get overwritten? Just click on the lock symbol as needed in the Result Tab toolbar or set your entire MongoDB connection to read-only by default, and explore query results with confidence and at ease.

Compare Editions

DATA COMPARE & SYNCPRO

Data Compare & Sync - Studio 3T MongoDB GUI

With Studio 3T Data Compare and Sync, you can select entire MongoDB databases, specific collections, or particular query results to compare. Run the comparison, and you’ll see the differences side-by-side, and all results can be edited and/or synchronized in place!

Discover What's New

Schema ExplorerPRO

Schema Explorer - Studio 3T MongoDB GUI

MongoDB schema discovery and exploration has never been easier! Studio 3T provides a very powerful Schema Explorer feature that lets you easily discover the schema that is present across the documents in your collection to help you find data outliers. Drilling down into individual fields, you can see, for each field, various visual statistics relevant to the data type of that field.

Read More

Server Status Charts

Server Status Charts - Studio 3T MongoDB GUI

The server status charts show real-time updates of what's happening on a MongoDB instance. Right-click on either a connection, database, or collection, and then easily customize which charts are shown. See charts such as Operation Counts, Current Connections, and Current Network Traffic, on one convenient screen.

Read More

Map-Reduce

MapReduce - Studio 3T MongoDB GUI

Use our superb new MapReduce screen to easily process each document and emit one or more objects for each input document. This is followed by a reduce stage that combines emitted objects from the output of the map operation.

Read More

GridFS Support

GridFS Support - Studio 3T MongoDB GUI

Storing files larger than 16MB? That’s simple with Studio 3T, as we offer GridFS support.

Read More

Hotkeys

Hot Keys - Studio 3T MongoDB GUI

Save even more time while switching views and tabs, editing documents, executing queries, and completing other common MongoDB tasks with Studio 3T's convenient hotkeys.

View the Full List

Import from IBM DB2ENT

Import from IBM DB2 - Studio 3T MongoDB GUI

Migrate IBM DB2 to MongoDB with SQL Migration, which also supports Oracle, MS SQL Server, MySQL, Sybase, and PostgreSQL.

Read More

MongoDB 4.2 Compatibility

MongoDB 4.2 compatibility

We’re always on top of MongoDB updates. With Studio 3T, experience the benefits of the latest MongoDB version, 4.2, and enjoy full compatibility with versions 3.0 and higher.

Dark Theme

Dark Theme

Studio 3T offers two, full color schemes to choose from: dark theme and the default light theme.

Read more

Index Manager

Index Manager

Add and modify indexes through a convenient UI that lets you define collation and customize text, geo, partial, index options.

Read more

Schema Validator

Schema Validator

Prevent unwanted data from appearing in your collections. Enforce JSON schema and configure validation options and levels in just a few clicks.

Read more

Connection Manager

Connection Manager

Connect to as many direct connections, replica sets, or sharded clusters as you want and save your MongoDB connections all in one place, with the option of color-coding and grouping them into relevant folders. Simply enter your connection details by pasting a connection string, importing a URI file, or typing details manually.

Read more

Auto Updater

Auto Updater

Studio 3T will automatically update to the latest version after each release. Enjoy all the newest features, improvements, and bug fixes— minus the manual install. You’ll simply be notified that an update is available and all you’ll need to do is to restart the app.

View our release notes

Session Restore

Session Restore

Pick up right where you left off with Session Restore. Studio 3T will now remember which tabs you last had open and will always restore them on start — a real time saver.

Read more

Query History

Query History

Let our GUI do the heavy lifting so you don't have to. Studio 3T remembers your query history across all query building features, which you can always access from the toolbar.

Find it in these features

User Manager

User Manager

Get an overview of who's who in your database through an intuitive UI that lets you add, create, and edit users.

Read more

Role Manager

Role Manager

Along with the User Manager, control access to your database. Add privileges, create and modify roles, and find users granted specific roles.

Read more

Import from SybaseENT

Role Manager

Import Sybase to MongoDB with SQL Migration, which also supports all the other major SQL databases: Oracle, MS SQL Server, MySQL, PostgreSQL, and IBM DB2.

Read more