Studio 3T

Studio 3T is the professional IDE, client, and GUI for MongoDB. Build queries fast, generate instant code. Available for your Windows PC! From startups to Fortune 500 companies, teams have chosen Studio 3T for MongoDB as their must-have client to help build great products. Enjoy!

Better work starts with the right tool

• Import and export in CSV, JSON, SQL and BSON/mongodump
• Generate driver code in seven languages
• Break down aggregation queries into stages
• Auto-complete queries in the mongo shell
• Build queries via drag-and-drop
• Use data masking to protect sensitive data
• Transform a collection’s schema in a few clicks
• Explore data schema and find outliers
• Migrate between SQL and MongoDB
• Write SQL to query MongoDB
• Schedule MongoDB tasks

Features and Highlights

IntelliShell
Auto-complete queries in a built-in mongo shell that highlights syntax errors as you type and saves your query history.

Visual Query Builder
Perfect for MongoDB beginners, a time-saver for pros. Use a drag-and-drop UI to build complex find() queries and filter array elements.

Aggregation Editor
Break down aggregation queries into manageable steps and build them stage by stage, for easier debugging and querying.

SQL Query
Put your SQL skills to good use. Query MongoDB with SQL using SELECT, DISTINCT, GROUP BY, INNER JOIN, LEFT JOIN, and more.

Query Code
Generate instant code in JavaScript (Node.js), Java (2.x and 3.x driver API), Python, C#, PHP, and Ruby from MongoDB and SQL queries that you can copy and paste into your application.

Tasks & Tasks Scheduler
Save MongoDB imports, exports, data comparisons, and migrations as tasks that you can run on demand. Or even better, skip the reminders and schedule them to run exactly when you need.

Reschema
Make changes to your collection’s schema in just a few clicks, perfect for schema performance tuning, restructuring, or cleaning up after a data migration.

Schema Explorer
Find mistakes fast. Run schema analyses on your MongoDB collections to reveal data outliers, misspellings, duplicates, and other anomalies that you can fix on the spot.

SQL ↔ MongoDB Migration
The easiest way to migrate between SQL and MongoDB. Import Oracle, PostgreSQL, MySQL, SQL Server, Sybase, and IBM DB2 to MongoDB, or export MongoDB collections to a SQL file or database.

Import & Export Wizard
Import to MongoDB from JSON, CSV, BSON/mongodump, and SQL, and get a preview of your output documents as you make changes. Export entire MongoDB collections, views, queries, query results, or specific documents to the same formats.

Connection Manager
Connect to as many MongoDB connections as you want, with the option to enable proxy support, activate read-only lock mode, and use SCRAM-SHA-256, SCRAM-SHA-1, X.509, Kerberos (GSSAPI), and LDAP authentication—without long loading times.

Table, Tree & JSON Views
Discover the most flexible MongoDB viewer. Open any MongoDB collection and show embedded fields next to parent fields with Table View, collapse or expand fields in Tree View, or browse entire documents in JSON View.

User & Role Managers
Add, edit, and remove users in just a few clicks, assign roles to individual users, and list out all users by role through a convenient MongoDB UI.

MongoDB client vs. MongoDB GUI vs. MongoDB IDE

Studio 3T as a MongoDB client
A client is a software program or application that allows you to connect to a server. Go wild with Studio 3T’s Connection Manager and connect to as many MongoDB servers as you need.

Studio 3T as a MongoDB GUI
A Graphical User Interface (GUI) does exactly as it says. It provides a user interface with graphical menus, icons, dialogs, wizards, and other visual elements. The alternative to using a MongoDB GUI would be to use the mongo shell, though Studio 3T still has IntelliShell – an easy-to-navigate, built-in version – for when you need one.

Studio 3T as a MongoDB IDE
An Integrated Development Environment (IDE) consolidates the many aspects of application and database development into one fully-featured “studio” environment. The app does exactly that by providing a GUI that has editors with auto-completion and syntax highlighting, built-in JSON validation, automatic query code generation in seven languages, and many other features that help you work faster and save time.

Note: The program's Core Edition is free for non-commercial usage. 14 days trial version.