What’s New in Studio 3T 2018.6 | Visual Explain, IntelliShell Code Formatting, and More

Posted on: 19/12/2018 (last updated: 13/08/2021) by Kathryn Vargas

Experiencing connection issues after updating to 2018.6? Read our follow-up blog post.

Studio 3T 2018.6 focuses on performance with the launch of the new Visual Explain feature, as well as improvements to core features like IntelliShell and Connection Manager.

New features

Visual Explain | See query plans stage by stage 

Before we had the Explain tab, now we have Visual Explain.

With Visual Explain, you can view how MongoDB executed your query at a glance, with the option to view runtime statistics like stage outputs and execution times.

Studio 3T's Visual Explain feature displays query plans in a diagram format

For those who prefer JSON, Visual Explain also lets you view query plans in JSON, whether in full or for individual stages.

Displays the stage's specific JSON fragment

Open Visual Explain by clicking on the Explain Tab, which is part of the greater Collection Tab.

Here it is in action:

Query plans visualized with the help of Studio 3T's Visual Explain

IntelliShell | Reformat your mongo shell code

Make mongo shell code even prettier in IntelliShell with a hotkey or a right-click.

With 2018.6, you can define your Editor tab width preferences under Studio 3T > Preferences > General:

Define editor tab width under Studio 3T > General > Preferences
The default editor tab width setting is 4 spaces.

Once set, you can easily apply your chosen setting to reformat your IntelliShell code, simply by right-clicking and choosing Format code, or by pressing the hotkey Ctrl + Alt + L (or ⌥ + ⌘ + L on Mac):

Reformat your mongo shell code with a hotkey or right-click

The tab width setting affects the code in the following areas of Studio 3T:

  • IntelliShell
  • Remove and update dialogs
  • The mongo shell tab under Query Code

We will continue to expand support for the tab width throughout the application in future releases.

Connection Manager | SCRAM-SHA-256 support

Studio 3T now supports SCRAM-SHA-256, which was rolled out with MongoDB 4.0 to addresses the vulnerabilities of SHA-1.

Studio 3T now also supports SCRAM-SHA-256

Please note that as of Studio 3T 2018.6, it will no longer be possible to connect to MongoDB version 2.6, which reached its end of life in October 2016. Only MongoDB versions 3.0 and higher are supported.

Fixes and improvements

  • Connection Tree – Right-click on any item to copy that item’s name into the clipboard
  • JSON View – Copy field name now possible, line separator added to better distinguish documents
  • Visual Query Builder – Fixed querying within subgroups

Download Studio 3T

Already using Studio 3T? Auto-updater has you covered. Discovering our MongoDB GUI for the first time? Then get the latest version here:

Try Studio 3T 2018.6
How helpful was this article?
This article was hideous
This article was bad
This article was ok
This article was good
This article was great
Thank you for your feedback!

About The Author

Kathryn Vargas

When she's not writing about working with MongoDB, Kathryn spends her free time exploring Berlin's food scene, playing the drums, learning languages (current mission: German), and hiking.

Tags

2022 academy aggregation AMA atlas Certification christmas community connections culture date tags events export features hackolade import intellishell In Use JSON knowledge base migration modelling mongodb mongoodb mongosh My 3T productivity query regex releases schema security SQL Studio 3T tasks time series tips updates webinar windows

Browse by MongoDB topic