Visual Query Builder

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.

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.

Table, Tree & JSON View

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.

IntelliShell

Forget the MongoDB shell as you know it - Studio 3T has IntelliShell, the richest editing experience of any MongoDB client. There is auto-completion of collection names, shell methods, and also of document key names, operators, and further completions on return values. It’s an essential part of using MongoDB.

Query CodePRO

Generate driver code from your MongoDB query. Studio 3T’s Query Code automatically converts your MongoDB queries to one of five target languages - JavaScript (node.JS), Java, Python, C#, and the mongo shell language - for an easy copy + paste job from Studio 3T and into your application.

SQL QueryPRO

NoSQL meets SQL on Studio 3T. With SQL Query, you can use SQL to query MongoDB and view your SQL query's equivalent code in the mongo shell language, Java, JavaScript, Python, and C#.

SQL Import/ExportPRO

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.

LDAP & Kerberos AuthenticationENT

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.

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.

Enterprise InstallerENT

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.

Other Import / Export Features

Studio 3T supports JSON, CSV and BSON/mongodump formats for seamless data import and export to and from MongoDB.

Color-Coded Connections

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-Only Lock

Worried that your MongoDB query results will get overwritten? Studio 3T has added a read-only button to the Query Result tab to put your mind at ease. Now you can browse all your data with confidence without accidentally overwriting it - just click on the Lock symbol as needed.

DATA COMPARE & SYNCPRO

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!

Schema ExplorerPRO

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.

Server Status Charts

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.

Map-Reduce

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.

GridFS Support

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

HotKeys

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.

MongoDB 4.0 Compatibility

Here at Studio 3T, we’re always on top of MongoDB updates. With the release of MongoDB 4.0 comes a larger feature set and more flexibility. And now you can experience the benefits, as Studio 3T is fully compatible with MongoDB versions 2.6 to 4.0.