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
    • AI Helper
    • Team Sharing
    • Index Manager
    • 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

What’s New in Studio 3T 2021.4 | Customizable Shortcuts, SQL Auto-completion and More

Posted on: 24/06/2021 (last updated: 25/08/2021) by Cameron Moreno

2021.4.1 update: We have fixed an issue in Edit View where running the aggregation pipeline of a view would return incorrect or no results at all. We have also resolved an issue where the confirmation dialog of the JSON Editor could not be closed with Ctrl/Cmd + Return.

Boost your productivity with customizable shortcuts, SQL auto-completion, a more flexible JSON editor, and much more in the newest release of Studio 3T.

Headline features

Hotkeys | Customize and add your own shortcuts

Whether you’re getting started with Studio 3T from another IDE or your fingers just don’t want to move away from one corner of your keyboard, we’ve got you covered. With our new configurable shortcuts, you can easily modify and create hotkeys for a range of actions. 

Open Studio 3T > Preferences and navigate to the Keymap tab. Here you can search for functionalities and edit them by right clicking and selecting Add shortcut. 

Moving to another instance of Studio 3T and want to keep your shortcuts? No problem. Clicking Export keymap will create an XML file which you can import to the new instance by clicking Import keymap.

Customizable hotkeys in Studio 3T

Studio 3T Custom Keymap

Read more about configuring your keymap and find a full list of default shortcuts at our Hotkeys documentation.

SQL Query | Now supporting SQL smart auto-completion

Auto-completion has been an integral feature of our IntelliShell tool. We’ve expanded that functionality to SQL Query so that you start querying from day one, no matter what language you’re coming from.

SQL query auto-completion


Studio 3T SQL Query Auto-completion

JSON View and Editor | Simultaneously edit multiple JSON documents and view JSON results as pure JSON

Our JSON Editor allows for real-time and lossless editing in JSON. We’ve made working with JSON even more flexible and streamlined. You can now simultaneously edit multiple JSON documents and navigate to other tabs or collections without closing the editor.

Edit multiple JSON documents and view JSON results as pure JSON


Studio 3T JSON Editor 

We’ve also introduced the option to view and copy your JSON results in pure JSON, using only simple numbers, strings and booleans. After selecting JSON View from the dropdown on the top right of your collection, select the settings icon to the right and choose the JSON: Pure, without MongoDB types formatting option. Please be reminded that omitting MongoDB-specific types may cause a loss of accuracy.

JSON pure format

Studio 3T JSON Pure Format 

Read more in our JSON View documentation. 

Data Masking | Now supporting different source and target connections

When you’re working on a testing server, it might be important to mask sensitive data coming from a live collection on a different server. We’ve made it possible to change your data masking target to a connection different from the source connection, and vice versa.

In the Data Masking interface, under the Overview tab, click on Change target or Change source to open up the Connection Manager window.

Change connections in Data Masking


Studio 3T Data Masking Connection Change

Additionally, when you change data masking sources (whether that is a source connection or a collection/database), you now have the option to retain or discard the current data masking configuration.

Change source in Data Masking


Studio 3T Data Masking Source Change

To discover more use cases and ways Studio 3T’s data obfuscation tool can meet your needs, visit our Data Masking tool page. Learn more about how Data Masking works in our Data Masking documentation.

Fixes and improvements

User Shoutouts

We’d like to thank the many users of Studio 3T for reaching out for their own productivity needs: Scott Coffin for reporting a problem with Query Assist headings and line numbers; Ed Chalon for suggesting an increase in the number of fields for default mappings; Jan Tischler for reporting a sizing issue with input fields; Andrew Katz for reporting a problem relating to DNS fallback methods; Emin Alexandi for suggesting an increase in the limit of line numbers in the Raw Shell Output; Daragh Lavin for reporting a problem with erroneous syntax errors in IntelliShell; and to everyone else who made this release possible. 

App-wide

  • Extended the option to include a collection’s database name in tab titles to more tabs.
  • Indexes in a collection can now be individually copied and pasted.
  • Fixed issues that could occur with collection names that included spaces.
  • Fixed sizing issue for input fields in the collection tab.

IntelliShell

  • Query Assist result tabs now display headings corresponding to the line number at which the specific query was executed.
  • The limit on line numbers in the Raw Shell Output is now configurable.

MongoDB to SQL Migration

  • Increased field limit for default mappings when migrating to SQL.

Reschema

  • Fixed crash when editing a task associated with a disconnected connection.

SQL Query

  • Fixed issue where the export of results from some SQL queries would not be available.

Tasks

  • Tasks associated with a specific connection will now update properly when the connection is deleted.

Table, Tree, and JSON View

  • Optimized cell editing in Table View.

View the full list on our change log.

Download Studio 3T

Auto-update in the app, or start your free 30-day trial today:

Try Studio 3T 2021.4

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

Cameron Moreno

Cameron is not only a frontend developer; he's also a writer, skateboarder, crossword-solver, amateur historian, armchair philosopher, Arizonan but somehow Californian, and much more.

Related articles

  • What’s New in Studio 3T 2021.7 | Incremental migrations, customizable SQL types, and more
  • What’s New in Studio 3T 2021.8 | Custom Column Orders, new edition names, and more
  • What’s New in Studio 3T 2021.6 | Integrating Hackolade, code folding, and more
  • What’s New in Studio 3T 2021.5 | Streamlining UX and a new Data Masking technique
  • AMA: Do you have any shortcuts to Studio 3T productivity?

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 product management query regex releases schema security SQL Studio 3T studio3t tasks time series tips updates webinar windows

Browse by MongoDB topic

  • Connecting to MongoDB
  • Database Administration & Security
  • Getting Started with MongoDB
  • Getting Started with Studio 3T
  • Import/Export
  • Job Automation & Scheduling
  • MongoDB Aggregation Framework
  • MongoDB/Studio 3T Workshops
  • Performance
  • Query & CRUD Operations
  • Reference
  • Schema
  • Studio 3T Licensing
  • Support and other resources
  • Working with MongoDB & SQL
  • Working with MongoDB Atlas

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
✕