Skip to content
Studio 3T - The professional GUI, IDE and client for MongoDB
  • Tools
    • Aggregation Editor
    • IntelliShell
    • Visual Query Builder
    • Export Wizard
    • Import Wizard
    • Query Code
    • SQL Query
    • Connect
    • Schema Explorer
    • Compare
    • SQL ⇔ MongoDB Migration
    • Data Masking
    • Task Scheduler
    • Reschema
    • More Tools and Features
  • Solutions
  • Resources
    • Knowledge Base
    • MongoDB Tutorials & Courses
    • Tool/Feature Documentation
    • Blog
    • Community
    • Testimonials
    • Whitepapers
    • Reports
  • Contact us
    • Contact
    • Sales Support
    • Feedback and Support
    • Careers
    • About Us
  • Store
    • Buy Now
    • Preferred Resellers
    • Team Pricing
  • Download
  • My 3T
search

Studio 3T Tools & Features

Import Wizard

Import JSON, CSV, BSON/mongodump, SQL, or another collection to MongoDB, with the option of automating and scheduling frequently-run imports as tasks.

Read more Try for free

Export Wizard

Export entire collections, views, current queries, current query results, or specific documents to CSV, JSON, SQL, BSON/mongodump, or another collection. Save exports as tasks that you can run on-demand or schedule for later, whether on your local machine or a remote server.

Read more Try for free

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.

Read more Try for free

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 Try for free

Table, Tree, and JSON View

Get three ways to view your MongoDB data. If you’re into visualizing hierarchies, there’s Tree View. 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 Try for free

Data Masking

Enable compliance and bolster security with powerful field-level data obfuscation. Apply the right data masking technique depending on the field type and choose whether to overwrite the source collection or export the masked documents to a new target collection.

Read more Try for free

Reschema

Move an existing collection or view to a new schema in just a few clicks. Whether it’s to clean up, improve performance, or test incremental changes, Reschema provides an easy way to merge data from multiple sources and transform a collection’s schema, field by field.

Read more Try for free

IntelliShell

Forget the mongo shell as you know it. Save time with IntelliShell’s live error highlighting and smart auto-completion of 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 Try for free

Aggregation Editor

Write complex aggregate queries with greater confidence and accuracy. Break down queries into stages with Aggregation Editor, allowing you to apply various pipeline operators, debug, and check your results at every step.

Read more Try for free

Query Code

Generate driver code from your MongoDB and SQL queries with Query Code. Convert your queries to one of seven 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 Try for free

Tasks

Take Tasks up a notch with Task Scheduler, which adds a scheduling functionality to fully automate repetitive imports, exports, SQL migrations, data comparisons, data masking, and Reschema tasks.

Read more Try for free

SQL to MongoDB Migration

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 Try for free

MongoDB to SQL Migration

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 Try for free

SQL Query

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 Try for free

SQL Import/Export Wizard

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 Ultimate versions of our software.

Read more Try for free

LDAP & Kerberos Authentication

If you have a MongoDB Enterprise license, our Ultimate 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 Try for free

Import from Oracle

Studio 3T Ultimate 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 (Ultimate version only), Microsoft SQL Server, MySQL, and PostgreSQL.

Read more Try for free

Enterprise Installer

For the Ultimate 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 Ultimate version the auto-update feature is removed.

Read more Try for free

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 more Try for free

Read-Only Lock

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.

Read more Try for free

Data Compare and Sync

With 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.

Read more Try for free

Schema Explorer

MongoDB schema discovery and exploration has never been easier. Schema Explorer 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 Try for free

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.

Read more Try for free

Map-Reduce

Use our superb Map-Reduce 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 Try for free

GridFS Support

Storing files larger than 16MB? That’s simple with Studio 3T, which offers GridFS support.

Read more Try for free

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.

Read more Try for free

Import from IBM DB2

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

Read more Try for free

MongoDB 5.0 Compatibility

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

Try for free

Dark Theme

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

Read more Try for free

Index Manager

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

Read more Try for free

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 Try for free

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 Try for free

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.

Read more Try for free

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 Try for free

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.

Read more Try for free

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 Try for free

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 Try for free

Import from Sybase

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 Try for free

Studio 3T

MongoDB Enterprise Certified Technology PartnerSince 2014, 3T has been helping thousands of MongoDB developers and administrators with their everyday jobs by providing the finest MongoDB tools on the market. We guarantee the best compatibility with current and legacy releases of MongoDB, continue to deliver new features with every new software release, and provide high quality support.

Find us on FacebookFind us on TwitterFind us on YouTubeFind us on LinkedIn

Education

  • Free MongoDB Tutorials
  • Connect to MongoDB
  • Connect to MongoDB Atlas
  • Import Data to MongoDB
  • Export MongoDB Data
  • Build Aggregation Queries
  • Query MongoDB with SQL
  • Migrate from SQL to MongoDB

Resources

  • Feedback and Support
  • Sales Support
  • Knowledge Base
  • FAQ
  • Reports
  • White Papers
  • Testimonials
  • Discounts

Company

  • About Us
  • Blog
  • Careers
  • Legal
  • Press
  • Privacy Policy
  • EULA

© 2023 3T Software Labs Ltd. All rights reserved.

  • Privacy Policy
  • Cookie settings
  • Impressum

We value your privacy

With your consent, we and third-party providers use cookies and similar technologies on our website to analyse your use of our site for market research or advertising purposes ("analytics and marketing") and to provide you with additional functions (“functional”). This may result in the creation of pseudonymous usage profiles and the transfer of personal data to third countries, including the USA, which may have no adequate level of protection for the processing of personal data.

By clicking “Accept all”, you consent to the storage of cookies and the processing of personal data for these purposes, including any transfers to third countries. By clicking on “Decline all”, you do not give your consent and we will only store cookies that are necessary for our website. You can customize the cookies we store on your device or change your selection at any time - thus also revoking your consent with effect for the future - under “Manage Cookies”, or “Cookie Settings” at the bottom of the page. You can find further information in our Privacy Policy.
Accept all
Decline all
Manage cookies
✕

Privacy Preference Center

With your consent, we and third-party providers use cookies and similar technologies on our website to analyse your use of our site for market research or advertising purposes ("analytics and marketing") and to provide you with additional functions (“functional”). This may result in the creation of pseudonymous usage profiles and the transfer of personal data to third countries, including the USA, which may have no adequate level of protection for the processing of personal data. Please choose for which purposes you wish to give us your consent and store your preferences by clicking on “Accept selected”. You can find further information in our Privacy Policy.

Accept all cookies

Manage consent preferences

Essential cookies are strictly necessary to provide an online service such as our website or a service on our website which you have requested. The website or service will not work without them.

Performance cookies allow us to collect information such as number of visits and sources of traffic. This information is used in aggregate form to help us understand how our websites are being used, allowing us to improve both our website’s performance and your experience.

Google Analytics

Google Ads

Bing Ads

Facebook

LinkedIn

Quora

Hotjar

Reddit

Functional cookies collect information about your preferences and choices and make using the website a lot easier and more relevant. Without these cookies, some of the site functionality may not work as intended.

HubSpot

Social media cookies are cookies used to share user behaviour information with a third-party social media platform. They may consequently effect how social media sites present you with information in the future.

Accept selected