Connections Manager 
Import Wizard 
Collections Tab 
Visual Query Builder 
SQL Query 
SQL Connection Manager 
Team Sharing 
LDAP/ Kerberos
Export Wizard .svg){kind=icon}
SQL to MongoDB.svg){kind=icon}
MongoDB to SQL
Data Compare & Sync 
Task Scheduler 
Intellishell 
Schema Explorer 
AI Helper 
Aggregration Editor 
Query Code 
Query Profiler 
Index Manager 
Visual Explain 
Reschema 
Users and Roles Manager 
Data Masking 
Studio 3T’s first release in 2018 brings you extended SQL support for GROUP BY, COUNT, MAX, MIN, SUM, and AVG functions, support for additional date formats in CSV imports, and better control for retaining expired operations.
Extended SQL Query Support
SQL Query – the Studio 3T feature that lets you use SQL to query MongoDB – now supports GROUP BY, COUNT, MAX, MIN, SUM, and AVG functions.
Check out the complete feature documentation here and learn more about the currently-supported expressions and joins.
Additional Date Format Support in CSV Imports
Go wild with date formatting in your CSV imports. Studio 3T now supports eight date formats:
- ISO
- Locale
- MDY
- DMY
- YMD
- MYD
- DYM
- YDM
Read more about the CSV import feature and the supported date formats and separators.
Better Control Over Retained Expired Operations
With Studio 3T 2018.1, you have better control over your expired operations. Define the interval over which your expired ops are retained, now a quick and simple configuration under the Current Operations tab.
Other Improvements and Fixes
You can view the full list in our change log, but here are a few you’ve requested:
- Count Documents now available in Aggregation Editor
- Tabs in New / Edit Connection dialogs now scrollable on smaller screens
- Table View now reverts to correct default view when new projection is used
Do you want something improved in Studio 3T? Or simply want to let us know how we’re doing? We’d love to hear from you!
