Softpedia >Windows >Internet >Servers >Database Utils >Studio 3T for MongoDB >  Changelog

Studio 3T for MongoDB Changelog

What's new in Studio 3T for MongoDB 2024.2.0

Mar 13, 2024
  • New: Exports - Added a new type of export that allows writing documents directly into an MS Excel file.
  • Improved: Connection Manager - Added new options on the Advanced tab that allow setting the Write Concern for a connection configuration.
  • Improved: Visual Query Builder - Added labels such as Where, And, Either, and Or to the Query section of the VQB for better readability.
  • Improved: Operations View - Added task names to the entries shown in the Operations View for increased clarity.
  • Fixed: Data Compare & Sync - Fixed an issue where the export of differences could hang when documents have been deleted in the meantime.
  • Fixed: Data Compare & Sync - Added back the ability to set source or target connections by dragging and dropping them from the Connection Tree.

New in Studio 3T for MongoDB 2024.1.0 (Feb 6, 2024)

  • New: Collection Tab - Added syntax coloring and completion proposals to all query input fields.
  • New: Collection History - Now also supports remembering and restoring any edited documents.
  • Improved: General - Ensured that every operation can be cancelled at least 10 minutes after a loss of connectivity, instead of hanging indefinitely.
  • Improved: Connection Manager - Upgraded SSH libraries to support a bigger variety of SSH configurations.
  • Improved: Connection Manager - Allow to connect multiple selected connections with one single click.
  • Improved: Connection Manager - Added support for the import of Atlas Data Federation connection strings.
  • Improved: IntelliShell - The editor performance has been improved when working with bigger or more complex scripts.
  • Improved: Team Sharing - Cleaned up and improved Team Sharing related user interfaces for more clarity.
  • Improved: Task Manager - Ensured that corresponding tooltips are shown for all task types.
  • Improved: AI Helper - Improved how multiple source collections are shown on the AI Helpers user interface.
  • Improved: Query Manager - Allow optionally storing database and collection information with all saved queries, to clarify their context.
  • Improved: Exports - The Export Overview will now be selected, when opening a tab with multiple export units.
  • Improved: Session Restore - The "Enable session restore" option has been moved from the Appearance to the Behavior section.
  • Improved: Product Activation - Improved the Product Activation wizard to make it more clear how many machines are used on the current license.
  • Fixed: General - Fixed an issue that would have slowed down the user interface, especially on Linux.
  • Fixed: General - Fixed an issue where tooltips could be missing after changing the layout of the application (e.g. split, undock or move tabs).
  • Fixed: Connection Manager - Fixed situations in which some options on the Authentication tab of a connection configuration were not shown.
  • Fixed: Connection Manager - Fixed pasting Studio 3T connection strings containing nested folders.
  • Fixed: Connection Manager - Fixed an issue where the search on the Connection Manager would ignore the "DB Server" column.
  • Fixed: IntelliShell - Fixed syntax error that was mistakenly shown on special characters within single quotes.
  • Fixed: IntelliShell - Fixed syntax error that was mistakenly shown on back-tick template literals.
  • Fixed: Data Compare & Sync - Fixed documents being considered different, even though they only differed in fields that have been configured to be ignored.
  • Fixed: Query Profiler - Fixed an application failure that could occur when browsing through results of the Query Profiler.
  • Fixed: Index Manager - Fixed column header to read "Index type" instead of "Field type".
  • Fixed: Exports - Fixed an application failure that could occur when renaming a custom field in a CSV or SQL Export right before trying to rename it.
  • Fixed: IntelliShell Script Task - Fixed an issue where the script was not preserved when the tab was restored or duplicated.
  • Fixed: Users Tab - Disabled "Copy User" on privileges in the Users tab.

New in Studio 3T for MongoDB 2023.9.2 (Jan 8, 2024)

  • Improved: Bundled JRE - Updated the bundled Java Runtime (JRE) to version 17.0.9+9.

New in Studio 3T for MongoDB 2023.9.1 (Dec 11, 2023)

  • Fixed: Query Profiler - Fixed issues where error banners and the ON/OFF switch could show an incorrect state on the Query Profiler tab.
  • Improved: AI Helper - Update the ChatGPT model from "text-davinci-003" (to be deprecated on 4th of January 2024) to "gpt-3.5-turbo-instruct".
  • Improved: Result Views - Inline editors on the table and tree view will now properly show values with a center alignment.

New in Studio 3T for MongoDB 2023.9.0 (Nov 28, 2023)

  • New: Query Profiler - Find slow running queries, investigate, and fix Mongo DB queries to speed up performance.
  • Improved: Include "loadBalanced" option in non-SRV connections for compatibility with Oracle Autonomous Database.
  • Improved: IntelliShell is now able to handle large and complex scripts with better performance.
  • Improved: Added support for custom stage names in aggregation editor.
  • Improved: Detect when an email address is listed in both the "allow" and "block" lists in Team Sharing preferences.
  • Improved: More consistent icons for locked connections.
  • Improved: Support for aggregation stages $listSampledQueries and $listSearchIndexes, and operators $median and $percentile.
  • Improved: For compatibility with Amazon DocumentDB, Studio 3T now doesn't attempt to use "allowDiskUse" and "collation" options unless they differ from the defaults.
  • Improved: IntelliShell's autocomplete suggestions are now case-insensitive.
  • Improved: "Copy selection" contextual option now also available in raw shell output.
  • Improved: In the Query History and Query Browser windows, "Clear History" is now accessible without having to select an item first.
  • Improved: The "Insert JSON Document" feature now accepts an array of documents as well as a single document.
  • Improved: "Refresh" button now available also in IntelliShell results tab and SQL Query results tab.
  • Improved: In IntelliShell results, treat "findOne" results in a manner consistent with "find".
  • Improved: "Follow Reference" can now remember different target databases and/or collections for different source fields. Also, the choices are remembered even if the tab is closed.
  • Fixed: Studio 3T could crash when disabling the trial while having a collection tab open against a shared connection.
  • Fixed: Empty folder in connection manager would remain collapsed even after adding a connection to it.
  • Fixed: Compatibility problems from 2023.7 on with CSV export tasks created in previous versions.
  • Fixed: In the import connections dialog, all the folder options in the dropdown would duplicate each time a file is selected.
  • Fixed: Hitting "Ctrl/Cmd + Enter" in IntelliShell would insert a new line in certain cursor positions.
  • Fixed: Crash when rapidly removing and re-setting the read-only lock on a shared query.
  • Fixed: Input for OpenAI API Key accepted trailing newlines, resulting in an error when trying to use the key.
  • Fixed: UUIDs not properly displayed in Visual Query Builder.
  • Fixed: Field name proposals in SQL Query Tab could be sourced from the wrong collection if the SQL script had multiple SELECT statements.
  • Fixed: Existing indexes sometimes not available for selection for hints in aggregation options.
  • Fixed: Editing the index specification for the index hint in aggregation options would cause an error message to appear.
  • Fixed: Index hints were not applied to "Explain Query" within IntelliShell.
  • Fixed: IntelliShell result tabs would be persisted when restarting the shell, even if not pinned.
  • Fixed: Pressing enter when entering an email address in the block or allow list for team sharing would close the preferences.

New in Studio 3T for MongoDB 2023.8.0 (Oct 26, 2023)

  • New: AI Helper - Integrated the AI Helper with the Collection Tab, allowing users to write queries using natural language.

New in Studio 3T for MongoDB 2023.7.0 (Oct 12, 2023)

  • New: Aggregation Editor - Redesigned the Aggregation Editor for improved usability, e.g. replacing stage tabs with a list view.
  • New: Aggregation Editor - Integrated the AI Helper with the Aggregation Editor, allowing users to write queries using natural language.
  • New: Session Restore - Session Restore, which restores all open connections, tabs, etc. when restarting the app, is now enabled by default.
  • Improved: General - Streamlined the handling of unsaved changes when closing more than one tab to prevent multiple confirmation dialogs.
  • Improved: Collection Tab - A new option, "Open in aggregation editor", opens the current query as an aggregate query in the Aggregation Editor.
  • Improved: IntelliShell - Improved the behavior of the undo/redo feature on IntelliShell editors.
  • Improved: Schema Analyzer - GridFS collections are now excluded from the Schema analysis source dialog.
  • Improved: Exports - The field table for CSV and SQL exports has been greatly improved for better usability.
  • Improved: Team Sharing - Added a button in the Connection Manager to create a "New shared folder".
  • Improved: Team Sharing - For consistency, mentions of "admins" and "users" have been renamed to "managers" and "members" respectively.
  • Improved: Team Sharing - In Preferences, readability of the email address list in dark theme is improved on the Team Sharing page.
  • Improved: Query Manager - The Query Manager automatically refreshes when shared folders are added or removed through Team Sharing.
  • Improved: Query Manager - When opening the Query Manager, the focus is now on the search field, ready to start searching for queries.
  • Improved: Code Editors - With "Auto-complete bracket pairs", typing a bracket or quotation mark immediately after it has been auto-completed, will be ignored.
  • Fixed: Connection Manager - Fixed an issue where the "Connection folder" list on the "New Connection" dialog was empty on Linux.
  • Fixed: Connection Manager - Fixed an issue when editing connection configurations with certificate files containing a certificate followed by a private key.
  • Fixed: Connection Manager - Fixed the "Expand" option on the context menu for all folders.
  • Fixed: Collection Tab - Fixed an application failure that occurred when deleting a full line from the multi-line query editor.
  • Fixed: IntelliShell - Fixed an issue where collation options were ignored when running queries using Query Assist.
  • Fixed: IntelliShell - Fixed an issue where the read preference of the current connection to MongoDB was not shown correctly.
  • Fixed: Team Sharing - In My resources, fixed cases where the Local Resources folder couldn't be expanded because it contained only default folders.
  • Fixed: Team Sharing - Fixed an issue where quick connect shortcuts assigned to shared connections didn't work.
  • Fixed: Team Sharing - Fixed an issue where the My resources sidebar was empty on startup.
  • Fixed: Query Manager - Fixed the keyboard shortcut for deleting a resource or folder in the Query Manager.
  • Fixed: Task Manager - Fixed the keyboard shortcut for renaming items (F2), so that it works on folders.
  • Fixed: Data Masking - Fixed an error that occurred when excluding multiple fields at a time.
  • Fixed: What's New - Fixed an issue where the What's New tab failed to load when using dark theme.

New in Studio 3T for MongoDB 2023.6.1 (Sep 8, 2023)

  • Fixed: Fixed an internal issue that could affect the application performance.

New in Studio 3T for MongoDB 2023.6.0 (Aug 25, 2023)

  • New: Team Sharing - Share MongoDB connection configurations, queries and scripts with team members using the new Team Sharing feature.
  • New: Extended Trial - Extend your expired trial for another seven days with Studio 3T 2023.6 and try more of the powerful features.
  • New: Preferences Dialog - A new preferences dialog now provides easier access to all settings, including license and account details.
  • Improved: General - Most message dialogs can now be closed by pressing the RETURN or ENTER key, instead of clicking OK.
  • Improved: AI Helper - For full transparency, the AI Helper now allows users to review the full question that would be sent to OpenAI.
  • Improved: AI Helper - With Session Restore enabled, the user interface of the AI Helper is now fully restored after restarting Studio 3T.
  • Improved: IntelliShell - With the new MongoDB Shell (mongosh), IntelliShell now supports proxies on MongoDB connections, even without SSH.
  • Improved: Collection Tab - Table and Tree View now automatically hide the "_id" column, if that field is not present in the results.
  • Improved: Collection Tab - The "Add New Collection" dialog now supports Clustered Collections with a new option, "Create clustered collection".
  • Fixed: General - Fixed an issue where text editors presented invisible text, instead of long lines of code or JSON.
  • Fixed: General - Fixed an application failure that occurred on restart after closing Studio 3T while an operation was still running.
  • Fixed: Collection Tab - Fixed an "Index out of bounds" error which could occur on Linux when trying to save contents of a binary field to a file.
  • Fixed: IntelliShell - Fixed an issue with the Undo function in Studio 3T editors which sometimes gave unexpected results.
  • Fixed: IntelliShell - Fixed an issue where script editors incorrectly detected invalid escape sequences on valid template literals.
  • Fixed: Aggregation Editor - Fixed an issue where new Aggregation tabs were marked as having unsaved changes on opening the tab.
  • Fixed: Schema Analyzer - Fixed an issue where Session Restore failed to restore Schema tabs.

New in Studio 3T for MongoDB 2023.5.0 (Jun 13, 2023)

  • Improved: General - Updated Mongo Java Driver to version 4.7.2, with full support for MongoDB 6.0.
  • Improved: General - Updated the Mongo Shell that is shipped with Studio 3T from version 1.5 to version 1.8.
  • Improved: General - Added support for over a dozen new aggregation operators for MongoDB 5.0 and 6.0.
  • Improved: Aggregation Editor - Added support for the new aggregation stages: $densify, $documents, and $fill.
  • Improved: Aggregation Editor - Improved the $lookup stage to support templates for different use cases.
  • Improved: Aggregation Editor - The dropdown for the selection of stage operators now allows typing stage operators without the "$".
  • Improved: AI Helper - Added an "Limit number of fields ..." option to prevent running into token count limitations with ChatGPT.
  • Improved: Index Manager - Associated Index Manager tabs are now automatically closed after dropping a collection.
  • Improved: Index Manager - The "Add Index" and "Edit Index" dialogs now allow changing the field order via drag & drop or context menu actions.
  • Improved: IntelliShell - Added the ability to rename output tabs by right-clicking them and selecting "Rename tab".
  • Improved: Export Wizard - Introduced the ability to load saved queries (find and aggregate) on units of an export task.
  • Improved: Schema Analyzer - Added support for opening schema analysis results that are associated with a deleted connection.
  • Fixed: Index Manager - Fixed an application failure that occurred when closing an Index Manager tab while an index operation is still running.
  • Fixed: Aggregation Editor - When moving stages up or down the pipeline, the stage number next to the "Operator" field is now updated.
  • Fixed: Aggregation Editor - Fixed an crash that could occur when restarting Studio 3T after collapsing the result view for an aggregation stage.
  • Fixed: Connection Tree - Fixed an application failure that could occur when resizing the Open Connections tree.
  • Fixed: Query Manager - Fixed an application failure that could occur when trying to collapse the tree in the Query Manager.
  • Fixed: Imports - Importing CSV files now works correctly for all delimiter options.
  • Fixed: Task Manager - Fixed "Authentication failed" errors for scheduled tasks running on databases that do not require authentication.
  • Fixed: Aggregation Editor - Removed the misplaced option to open IntelliShell from exports of aggregation results.

New in Studio 3T for MongoDB 2023.4.1 (May 17, 2023)

  • Fixed: Index Manager - Fixed an issue with non-sparse indexes showing as "sparse".
  • Improved: IntelliShell - Result tabs can now be pinned with a button directly on their tab header.

New in Studio 3T for MongoDB 2023.4.0 (May 4, 2023)

  • New: Index Manager - See and manage all the indexes of a collection in one place, including information about their usage.
  • New: Collection History - Let Studio 3T keep track of documents that you deleted on a collection and restore them, if needed.
  • Improved: General - Improved user interface by tweaking borders, paddings and margins, for a sleeker look.
  • Improved: Quickstart - Added a link to our free webinars to the "Help and Learning" section of the Quickstart tab.
  • Improved: AI Helper - Added full support for proxies, and a better handling of collections with special characters in their name.
  • Improved: IntelliShell - Closing an IntelliShell with unsaved changes, now offers an option to save the changes to the script browser.
  • Improved: Visual Explain - Improved Visual Explain to support MongoDB servers earlier than version 3.6.
  • Improved: Aggregation Editor - Result views of Aggregation Editors can now be expanded or collapsed with a double-click on their headers.
  • Improved: Aggregation Editor - New Aggregation Editors now automatically create a first stage and its tab, ready to be edited.
  • Improved: Code Editors - Improved the padding in line number rulers so that the numbers are now further away from the left edge.
  • Improved: Query Manager - All tree elements of the Query Manager and Query history and query browser, can now be expanded or collapsed.
  • Fixed: General - Fixed an issue where the dialog for entering custom keystore passwords would not display on the same monitor as the application.
  • Fixed: IntelliShell - Fixed keyboard shortcuts and File menu options for loading scripts and files.
  • Fixed: Aggregation Editor - The $set stage on aggregation queries now chooses a more appropriate data type for numbers.
  • Fixed: Aggregation Editor - Fixed an application failure that occurred when using DBRef values in an aggregation query.
  • Fixed: Collection Tab - The Remove Field dialog now works with query conditions that match date tags.
  • Fixed: Query Manager - The "&" character in saved query names and script names is now displayed throughout the application.
  • Fixed: Query Manager - Fixed an issue with line delimiters in saved queries that were causing an application failure.
  • Fixed: Connection Tree - Fixed an application failure that occurred when clicking "more matches" in search results.
  • Fixed: Search in ... - Fixed an issue that caused an application failure when using the search on a connection that has no databases.
  • Fixed: Task Manager - Moving a task in the task tree of the Task Manager will not update the "Last modified" timestamp anymore.
  • Fixed: Task Manager - Saving or moving a task in the task tree of the Task Manager will now automatically expand all relevant folders.
  • Fixed: Imports - When importing data, the application now remembers custom field names when saving and reopening an import task.
  • Fixed: Data Masking - Fixed an issue where the "Add unit" button was unavailable in duplicated or session restored Data Masking tabs.

New in Studio 3T for MongoDB 2023.3.0 (Mar 30, 2023)

  • New: IntelliShell - OpenAI Integration: Let GPT-3.5 create queries for you when you ask natural language questions about your data.
  • Improved: General - Introduced some general application stability improvements.

New in Studio 3T for MongoDB 2023.2.0 (Mar 17, 2023)

  • New: General - The new Connection Sidebar now tracks the connection, database or collection of the currently active tab.
  • New: General - Numeric fields of newly created or edited documents are now automatically stored with the most efficient data type.
  • Improved: General - Added new options to duplicate (Command / Ctrl + D) or delete (Option / Alt + Backspace) lines in all code editors.
  • Improved: Connection Manager - MongoDB's retryable writes option is now read from and written to connection strings.
  • Improved: IntelliShell - The startup time of the IntelliShell has been greatly reduced.
  • Improved: Connection Manager - All connections can now be viewed, edited, and tested, regardless of possible Studio 3T license restrictions.
  • Improved: Connection Tree - Collections can now be pasted directly to connections, creating missing databases if necessary.
  • Improved: IntelliShell - In case of problems during IntelliShell startup, Studio 3T now includes more details within the error dialog.
  • Improved: IntelliShell - The IntelliShell now fully respects MongoDB's retryable writes option when spawning a mongo shell.
  • Fixed: General - Fixed some icons that could appear blurry in Studio 3T's user interface.
  • Fixed: Connections - Instead of timing out, when a task execution requires a connection password, users are now prompted to enter the password.
  • Fixed: Collection Tab - When working with undocked tabs, new tabs now open in the undocked window instead of the main application window.
  • Fixed: Collection Tab - Fixed formatting of queries copied to the system clipboard, e.g. alignments and spacing between field name and value.
  • Fixed: Collection Tab - Copying a query to the system clipboard now uses the correct line endings for the target operating system.
  • Fixed: Aggregation Editor - Fixed an issue where the "Pipeline" tab did not correctly update the shown stage specifications.
  • Fixed: Code Editors - Fixed an application failure that occurred when trying to open the context menu in some code editors in Studio 3T.
  • Fixed: Code Editors - Fixed an issue that could occur in IntelliShell when opening the Visual Query Builder on a find query statement with no arguments.
  • Fixed: BSON Import - Added an option to forcefully disable retryable writes in imports of BSON archives (mongorestore).
  • Fixed: Studio 3T Free - Fixed an application failure that occurred when trying to follow a DBRef using "Follow Reference" on a MongoDB field.

New in Studio 3T for MongoDB 2023.1.1 (Feb 13, 2023)

  • Fixed: Data Compare & Sync - Fixed some issues around loading and restoring Data Compare & Sync tasks and tabs.

New in Studio 3T for MongoDB 2022.10.0 (Dec 7, 2022)

  • New: General - Code and JSON editors are now automatically completing brackets and quotes.
  • Improved: Visual Query Builder - Tweak position of automatic tooltips so that they are not blocking input fields.
  • Improved: Aliases - Reduce delay before showing tooltips on tabs in cases where these do not show collection or database aliases.
  • Improved: Aliases - Make it easier to see name clashes when creating a new alias for a connection or database.
  • Improved: IntelliShell - Made the limit for automatically generated result tabs configurable.
  • Improved: IntelliShell - Both Aliases and Notes are now available with auto completion proposals on the IntelliShell.
  • Improved: IntelliShell - Limit errors shown at once on IntelliShell editors to 100, showing a notification when there are more.
  • Improved: Data Masking - Aliases for collections are now also shown for the mapping tree on Data Masking configurations.
  • Improved: Tasks - Added the action to Rename a task to the toolbar of the Tasks view.
  • Improved: Tasks - Added the option to change the order of tasks, by simply dragging and dropping them in the Tasks view.
  • Improved: Aggregation Editor - The stage input/output pane can now be collapsed in order to maximize the stage editor's space.
  • Improved: General - Added a new Advanced option to set the connection pool size, useful in cases where big connection pools cause problems.
  • Improved: Connection Manager - Stop adding "- imported on ..." to imported connection names and include a numeric suffix when names already exist.
  • Improved: Exports - Make it easier to add a new database or collection when choosing the target of an export.
  • Fixed: General - Fixed an issue where, occasionally, duplicated tabs could immediately close.
  • Fixed: General - On Ubuntu, the Match Case checkbox now renders correctly in light mode.
  • Fixed: General - On Ubuntu, the Target Collection selection on Ubuntu now selects the relevant connection.
  • Fixed: Collections - Capped Collection settings in Create Collections are again correctly enabled for 5.0.6 and earlier MongoDB servers.
  • Fixed: Collection Tab - Studio 3T is now more resilient to badly formatted queries on the clipboard being pasted.
  • Fixed: IntelliShell - Syntax coloring on the script editor now shows back-ticked template literals as strings.
  • Fixed: IntelliShell - Completion proposals on mongosh stop showing the deprecated/removed "save()" function.
  • Fixed: IntelliShell - Now bundling the native mongosh executable for M1/M2 macs, so that Rosetta is no longer needed.
  • Fixed: User Copying - Copying users on the same server could mistakenly offer to resolve issues by creating a role.
  • Fixed: User Copying - Copying users between different servers could fail to resolve issues if the user's role did not exist on the target server.
  • Fixed: Exports - Index Hints are now applied correctly when an Aggregation is used for export.
  • Fixed: CSV Import - CSV Imports no longer leave a lock on imported files.
  • Fixed: CSV Export - Export CSV now defaults to using Windows or Unix end of line characters according to the operating system.
  • Fixed: Imports and Exports - Export tasks now also save a find query's options.
  • Fixed: Mongodump/Mongorestore - Exports using mongodump and imports using mongorestore now correctly work with Atlas serverless instances.
  • Fixed: Search In - Upper case field names are now correctly matched in the Search In ... feature.
  • Fixed: Reschema - Renaming fields in Reschema shows as a modification on the tab.

New in Studio 3T for MongoDB 2022.9.2 (Nov 15, 2022)

  • Fixed: UUID function with no argument causing mongosh shell restart

New in Studio 3T for MongoDB 2022.9.1 (Nov 10, 2022)

  • Fixed: Exports - Fixed an issue that could prevent Studio 3T from loading Export Tasks that have been saved with older releases.
  • Fixed: IntelliShell - Reintroduced helper functions for creating UUIDs on mongosh: UUID(), JUUID(), CSUUID(), PYUUID(), LUUID().
  • Fixed: IntelliShell - Removed a warning that would show up when using KERBEROS/LDAP authentication methods on the bundled mongosh.

New in Studio 3T for MongoDB 2022.9.0 (Nov 1, 2022)

  • New: Mongosh - Bundled Mongosh 1.5.4 and set it as the default mongo shell in Studio 3T.
  • New: Time Series - Added full support for creating and working with Time Series collections.
  • New: User Copying - Copy and paste users between different MongoDB databases, complete with their configured roles.
  • Improved: Auto Completion - Improved the responsiveness of editors that offer auto completion proposals, like the IntelliShell.
  • Improved: Exports - Added a new action to the toolbar and context menu of export units, allowing to clone them.
  • Improved: Tasks - Double-clicking a Task now opens a tab to edit it, while renaming is still available from its context menu.
  • Improved: Collection Tab - The dialog for inserting a document will now move the focus to the JSON editor directly after opening.
  • Improved: Reschema - The process of selecting and deselecting fields is more intuitive and simpler.
  • Improved: Reschema - Changing the type or deleting the target _id field is now disallowed.
  • Fixed: Aliases - The "Search in ..." tab and tooltips now display aliases.
  • Fixed: GridFS - Users of GridFS features will see various refinements to the user interface.
  • Fixed: Tasks - Weekly and Monthly scheduled tasks will now only run when scheduled.
  • Fixed: IntelliShell - Now able to connect Replica Sets with self-signed SSL certificates.
  • Fixed: IntelliShell - Exporting from IntelliShell toArray() is shown as Array-JSON in Operation pane.
  • Fixed: Export - When using the Aggregation Editor, the Open dialogs remain correctly labelled.
  • Fixed: Export - Data Masking options only appear when appropriate and can be hidden in General Export Options/Advanced Features settings.
  • Fixed: Copy Collections - The dialog is more explanatory when there is a collection name collision.
  • Fixed: Collections - The Restore Default Query button operates correctly in the presence of the Visual Query Builder.
  • Fixed: Refresh All will not trigger the appearance of a non-existent "Loading..." collection.
  • Fixed: Connections - Search will only search for Functions, Users and Roles if those items are selected to be displayed in Preferences.
  • Fixed: SQL Migration - More robust handling of array length limits (or lack of them) has been implemented.

New in Studio 3T for MongoDB 2022.8.3 (Oct 7, 2022)

  • Fixed: Show feature overview dialog before activating Studio 3T Free.

New in Studio 3T for MongoDB 2022.8.2 (Oct 4, 2022)

  • Improved: Simplified the steps that new users take to activate Studio 3T Free.

New in Studio 3T for MongoDB 2022.8.1 (Sep 7, 2022)

  • Fixed: Tasks - Fixed an issue that would occur when loading tasks that have a recurring schedule.
  • Fixed: JSON View - Fixed an issue with legacy UUIDs, where CSUUIDs were wrongly shown as "NUUID".
  • Fixed: Collection Tab - Fixed an issue that could prevent the tooltips of Collection Tabs from showing.
  • Improved: Connection Tree - The context menu action "Manage Metadata" has been renamed to "Aliases / Notes".

New in Studio 3T for MongoDB 2022.7.2 (Aug 15, 2022)

  • Improved: Reworked the steps that new users take to activate Studio 3T and Studio 3T Free.

New in Studio 3T for MongoDB 2022.7.1 (Jul 26, 2022)

  • Fixed: General - Fixed an issue with long running queries that would not complete correctly.

New in Studio 3T for MongoDB 2022.7.0 (Jul 22, 2022)

  • New: Aliases and Notes - Introduced aliases and notes for databases and collections on the connection tree.
  • New: Connection Padlock Icon - Read-only connections are now shown with a padlock icon throughout the whole application.
  • Improved: PostgreSQL - The driver for PostgreSQL was upgraded to enable support of SCRAM-SHA-256 passwords.
  • Fixed: Connection Tree - The keyboard shortcut for "Refresh Selected Item" now refreshes the selected item, instead of behaving like "Refresh All".
  • Fixed: Connection Tree - Fixed a crash that could occur under specific circumstances when copying collections using copy and paste.
  • Fixed: Connection Tree - The context menu is now available anywhere in the tree area, even opened without a selected connection.
  • Fixed: IntelliShell - The "Refresh View" option will now be disabled when there are no refreshable results views.
  • Fixed: IntelliShell - Fixed an issue on Windows, where the search box would reveal a gray field when users deleted content.
  • Fixed: Table View - Fixed an issue with resizing columns on Linux when there were few columns and there was a change in the table order.
  • Fixed: Exports - Connection colors in the source collection selection are now visible.
  • Fixed: BSON Import - Fixed an issue with saving and loading options for tasks that import from BSON mongodump folders and archives.
  • Fixed: SQL Import - Fixed a crash that could occur when clicking on an unset target collection of an SQL Import Unit.
  • Fixed: Connections - Fixed an issue where users could not connect to MongoDB when their user was lacking permission to run "buildinfo".
  • Fixed: Session Restore - Data Masking units will now restore correctly, even if they have not been saved as a Task or they lack any masked fields.
  • Fixed: Copy Collections - Fixed an issues that could occur when copying collections between servers where the user has limited permissions.
  • Fixed: Application Logs - Fixed an issue where Null Pointer Exceptions were being logged when UUIDs were converted to strings.

New in Studio 3T for MongoDB 2022.6.1 (Jun 27, 2022)

  • Fixed: Connection Tree - Fixed a crash that could occur with the "Refresh All" action when there is no selection.
  • Fixed: Collection Import/Export - Fixed an issue that did not allow exporting/importing different collections of the same name.

New in Studio 3T for MongoDB 2022.6.0 (Jun 21, 2022)

  • New: Customize Global Toolbar - Freely choose large or small toolbar icons and whether to show labels or not.
  • Improved: Connection Manager - New users will now see the Connection Manager appear automatically when they use Studio 3T for the first time.
  • Improved: Preferences - The editor font setting now has a "Back to default" button to restore default settings.
  • Improved: Date Tags - Date Tags are now preserved when used in an export task's aggregation query.
  • Improved: Mongo Java Driver - The mongo java driver has been updated to version 4.6.0.
  • Improved: Java Runtime - The Java Runtime has been updated to the latest JRE version 17.0.3.
  • Fixed: Connection Manager - Editing connections now preserves their shortcut settings.
  • Fixed: Connection Tree - The action "Refresh All" now refreshes all servers.
  • Fixed: Connection Tree - Copy & paste multiple collections within the same database now functions reliably.
  • Fixed: Connection Tree - Fixed a crash that could occur when trying to copy & paste a view.
  • Fixed: JSON View - Spaces are no longer appended to lines in the JSON View.
  • Fixed: Operations View - Operations progress for copying databases is now more precise.
  • Fixed: Reschema - Reschema JSON previews now reliably show foreign key fields.
  • Fixed: Reschema - Reschema now expands unwound arrays in target collections.
  • Fixed: IntelliShell - Computing auto-completion no longer hangs when querying the "local.oplog.rs" collection.
  • Fixed: Migration to SQL - For Custom SQL Types, "Reset to default" SQL type will only be shown when there are changes.
  • Fixed: SQL Connection Manager - SQL Connection Manager now displays a "Close", instead of an "OK" button when launched from the "File" menu.
  • Fixed: Data Masking - Unsaved data masking configurations are now correctly restored by Session Restore.
  • Fixed: Ubuntu Wayland - Resolved a number of UI issues with the newly released Ubuntu 22.04 and its new windowing system.

New in Studio 3T for MongoDB 2022.5.0 (May 19, 2022)

  • New: Load Tasks - Load tasks whenever you are about to create a savable task, or directly from an open tab.
  • New: IntelliShell Progress - IntelliShell now has reports progress of on-going queries.
  • New: JSON Find and Replace - A new toolbar makes finding and replacing in the JSON document editor more accessible.
  • Improved: Hidden Indexes - Studio 3T now supports Hidden Indexes.
  • Improved: Export - Studio 3T now offers additional options to automatically handle the target path when changing the source of an export.
  • Improved: Query Find - Improved the performance of performing a Find on query results.
  • Improved: Updates - Studio 3T Free no longer enforces the limit of three deferred reminders before updating.
  • Improved: Schema Validators - Schema Validations are now copied when a collection or database with validations attached to them are copied.
  • Improved: Field Editor - There is now a warning when you edit or delete a field and select "All Documents in Collection" to remind the user that this will affect the entire collection.
  • Improved: IntelliShell - When Mongosh is in use, a new Mongosh serializer is used to give a more compatible JSON representation.
  • Improved: Atlas - When using Atlas, users without listCollections privileges can see collections they have access to by setting "Always show all databases and collections defined in the roles of the user account" on the Authentication tab of the Connection Manager.
  • Improved: New Users - Studio 3T now informs users that their Robo 3T connections have been automatically imported.
  • Fixed: Export - Mongodump exports with find queries no longer generate a spurious warning.
  • Fixed: Export - It is no longer possible to try and export using a tab with results of a now deleted connection.
  • Fixed: SQL Server - A new option to Trust the Server Certificate is available in the SQL Server connection options. It defaults to On. The SQL Server driver has also been updated and is now shipped complete with all required drivers.
  • Fixed: Reschema - Type conversions are more resilient.
  • Fixed: JSON Editor - The Enable Word Wrap menu item has been aligned correctly. The Enable Word Wrap menu item and checkbox are also correctly synchronized.
  • Fixed: Help - Multiple open help windows can now be dismissed.
  • Fixed: Task Scheduling - The Custom Time schedule can now safely resize.
  • Fixed: Indexes - Improved resilience on opening indexes after disconnection.
  • Fixed: SQL Migration - Improved reliability of PostgreSQL Timestamp and Timezone conversions in Migration from SQL.
  • Fixed: Aggregation - Corrected the background color of controls Find Value is displayed in a set of out-of-date aggregation results.
  • Fixed: IntelliShell - Disable Query Assist (for IntelliShell) now works consistently within connection and global preferences.
  • Fixed: IntelliShell - Parsing empty arrays in Intellishell now works correctly.

New in Studio 3T for MongoDB 2022.4.1 (Apr 28, 2022)

  • Fixed: Collection Tab - Fixed margins of query input fields
  • Fixed: Collection Tab - Fixed an additional whitespace being inserted in queries when hitting ENTER
  • Fixed: Visual Query Builder - Fixed an crash that could occur with queries that are using empty text values
  • Fixed: Tree View - Fixed an issue that would not expand the first document of a query result anymore

New in Studio 3T for MongoDB 2022.3.0 (Mar 28, 2022)

  • New: Studio 3T Free - A new, fully free edition of Studio 3T that includes all essential features.
  • Fixed: Index Tab - Fixed an issue where fields would be removed from the overview when editing the index JSON.
  • Fixed: Intellishell - A race condition with shell startup and the user typing into the shell's editor has been resolved.

New in Studio 3T for MongoDB 2022.2.0 (Feb 24, 2022)

  • New Full native support on macOS for Apple Silicon systems with a new installer available on our download page.
  • New Collection Tab - Added support for additional options on find queries, like setting "Allow disk use" or a collation.
  • Improved General - Upgraded to the latest MongoDB Java driver of version 4.4.1, which supports MongoDB 5.2.
  • Improved Aggregation Editor - Added stage operator "$setWindowFields", which was introduced with MongoDB 5.0.
  • Improved Exports - Exports to another collection now export to a new collection in the same database by default.
  • Improved Connection Tree - The connection tree will now automatically refresh after a database has been copied and pasted.
  • Improved General - File choosers now behave consistently across platforms, remembering the path to the last folder opened.
  • Improved SQL Imports - Reporting on SQL Imports is now more readable in the Operations Pane.
  • Improved General - Typing performance in editors with code-folding support has been improved in cases of complex documents.
  • Improved Migration to SQL - Enhanced table management when dropping tables during a migration.
  • Improved IntelliShell Improvements to Windows Dark mode handling in autocompletion popups.
  • Fixed Server Status Charts - Fixed an issue that prevented Studio 3T from closing correctly on Ubuntu.
  • Fixed Connection Tree - Users and Roles no longer duplicate themselves when the tree is refreshed.
  • Fixed Aggregation Editor - Fixed a crash which could occur when an invalid query was entered and formatted in the stage editor.
  • Fixed JSON View - Selecting documents for Edit, Copy or Remove now selects the correct documents when using code folding.
  • Fixed Data Compare & Sync - Fixed a crash that could occur when selecting "Show Documents" in the Compare/Sync "Multiple Matches" tab.
  • Fixed Stored Functions - Fixed a crash which could occur when saving a stored function.
  • Fixed IntelliShell - When the selected mongo shell is not executable, an improved error message is now displayed.
  • Fixed Value Search - JSON view modes now behave correctly when using "Open in Collection".

New in Studio 3T for MongoDB 2022.1.1 (Jan 27, 2022)

  • Fixed: Visual Query Builder - Fixed projections not being correctly restored with Session Restore.
  • Fixed: Index Tab - Fixed an issue where the "Validate JSON" button was missing on the "Partial Index Options" tab.

New in Studio 3T for MongoDB 2021.10.1 (Dec 14, 2021)

  • Fixed: Connection Tree - Resolved an issue that could cause Studio 3T to crash when refreshing the connection tree.

New in Studio 3T for MongoDB 2021.10.0 (Dec 9, 2021)

  • New: Value Search - Search multiple collections for a specific field value.
  • New: Task Scheduler - Introduced a new task scheduler that allows for more powerful schedules.
  • New: Import Data Masking - Integrated data masking with imports, to direcly obscure, shuffle or exclude any imported fields.
  • New: IntelliShell - Experimental support for the new Mongo Shell executable "mongosh".
  • New: Database Copy - Copy entire databases and multiple databases and paste them into other servers.
  • Improved: IntelliShell - Updated JavaScript parser to support a wider range of syntax features.
  • Improved: Connection Tree - Improved connection tree performance when handling thousands of databases or collections.
  • Improved: Connection Tree - The search functionality of the connection tree now supports case-sensitive matches.
  • Improved: Collection Tab - "Add/Edit Document" now allows to continue editing a document after the MongoDB server rejected it.
  • Improved: Visual Query Builder - Greatly improved the handling of arrays and fields inside arrays when building queries visually.
  • Improved: GridFS Tab - Improved messaging when a GridFS collection would contain illegal metadata entries.
  • Fixed: General - Fixed an issue where window sizes and positions were not saved when Session Restore was off.
  • Fixed: General - Fixed an issue where users would not be prompted to save their unsaved changes when exiting the application.
  • Fixed: General - Fixed a crash that could occur when closing one of the notifications shown below the application's toolbar.
  • Fixed: IntelliShell - Fixed restoring IntelliShell tabs that were switched to using a horizontal split of editor and result view.
  • Fixed: Aggregation Editor - Fixed an issue where certain aggregation scripts could not be loaded from a file or the clipboard.
  • Fixed: Result Views - Fixed an issue where "Step Into Cell" would behave incorrectly when document ids are not unique.
  • Fixed: Index Tab - Fixed an issue where the option "storageEngine" wasn't preserved when updating an index definition.
  • Fixed: Result Views - Fixed an issue that did not show embedded fields next to their parent column with a custom column order in place.
  • Fixed: Exports - Fixed possible error when using Incremental Execution with existing export configurations.

New in Studio 3T for MongoDB 2021.9.0 (Nov 10, 2021)

  • New: Aggregation Editor - Added support for aggregation index hints under the "Options" tab.
  • New: MongoDB 5.0 - Now bundling version 100.5 of mongodump and mongorestore with Studio 3T installations.
  • New: SQL Tab - Added a toolbar option that allows turning off automatic completion proposals when writing SQL queries.
  • New: Collection Tab - Automatically open the Visual Query Builder when a user starts dragging a field from the result view.
  • Improved: Table View - Improved the performance of all table views in Dark Mode.
  • Improved: Collection Tab - Collection queries restored with Session Restore will no longer be run automatically.
  • Improved: Collection Tab - Extended the quick syntax feature to support more data types, like strings, numbers and many more.
  • Improved: Migration to SQL - Added support for changing the source collection of existing units in a Migration to SQL task.
  • Improved: IntelliShell - Added a new toolbar and context menu action to clear the contents of the "Raw Shell Output" tab.
  • Improved: IntelliShell - The "Restart Mongo Shell" link is now a standard toolbar item for better discoverability.
  • Improved: Operations Tab - Improved the user interface of the Operations view to better reflect the status of any shown tasks.
  • Improved: Connection Tree - Studio 3T will now show all accessible collections, even if the "listCollections" privilege is missing.
  • Improved: Aggregation Editor - The aggregation editor will now be more flexible when parsing queries from the clipboard or a file.
  • Fixed: Auto Updater - (Windows only) Fixed issues with downloaded updates not installing before the application is closed manually.
  • Fixed: Exports - Fixed crashes that could occur when trying to export collections that have a name ending with a period.
  • Fixed: Exports - Fixed crashes that could occur when trying to change the target file or folder of an export to the clipboard.
  • Fixed: Visual Query Builder - Fixed cursor position in text input fields being reset when they lose and regain their focus.
  • Fixed: IntelliShell - Fixed the IntelliShell failing to start on databases with special characters in their name.
  • Fixed: Data Masking - Fixed an issue that could occur when masking documents that are missing one of the fields that are to be masked.

New in Studio 3T for MongoDB 2021.8.1 (Oct 20, 2021)

  • Fixed: Table View - Fixed crashes that could occur when simply running queries or paging through results.
  • Fixed: Migration from SQL - Fixed a crash that could occur when trying to edit the dataset properties of an array mapping.

New in Studio 3T for MongoDB 2021.8.0 (Oct 13, 2021)

  • New: Table View - Added support for custom, persistent column orders in table views.
  • New: IntelliShell - Added support for retryable writes on the IntelliShell (--retryWrites).
  • New: General - Renamed Studio 3T Core to Basic and Enterprise to Ultimate to better reflect what's included in each edition.
  • Improved: Setting a font in the General tab of Preferences now updates the font of windows that have already been opened.
  • Improved: Migration from SQL - Allow strings (LONGTEXT or VARCHAR) to be converted into a valid ObjectId.
  • Improved: Exports - When exporting to CSV or SQL, manually entered fields are now preserved when a query is altered.
  • Improved: Exports - (Linux only) Better handling of export errors when two exports are run concurrently.
  • Improved: Exports - Export to JSON displays more information for composite sources.
  • Improved: Exports - JSON Export "other options" now displayed as radio buttons.
  • Improved: Collection Tab - Table view column sorting now correctly sorts columns that are within an array.
  • Improved: Collection Tab - Better handling of cancelled "Next page" requests.
  • Fixed: General - Fixed issues with a high CPU usage on macOS in Dark Mode.
  • Fixed: General - Toolbar item's hover-on labels now appear for all icons in the global toolbar.
  • Fixed: Migration from SQL - Handling of unresolved units with custom SQL queries now generates appropriate error messages.
  • Fixed: Migration from SQL - Warning about free trial limit of 1000 documents now appears when needed.
  • Fixed: Exports - Export to Mongodump folder now defaults to target destination folder.
  • Fixed: Exports - Fixed situations where the "Add Custom Field" button would be disabled.
  • Fixed: Exports - File-based exports now change target file-names if the source is changed.
  • Fixed: Collection Tab - Brought back type icons for null values in Tables and Trees.
  • Fixed: Connection Manager - Robo 3T connection passwords are now correctly imported.
  • Fixed: Current Operations - Fixed Kill Operation not working with MongoDB 4.0 mongos servers.
  • Fixed: IntelliShell - "Auto-completion enabled" indicator now reflects state correctly.
  • Fixed: Query Code - Code for Node.js now correctly forms regular expressions.
  • Fixed: Roles Tab - The "Add New Privilege" dialog's collections option is always populated.
  • Fixed: GridFS Tab - Tab data is now correctly restored when Session Restore is enabled.
  • Fixed: Data Masking - Various stability and usability issues have been resolved.

New in Studio 3T for MongoDB 2021.7.1 (Sep 21, 2021)

  • Fixed: Export Wizard - Fixed an issue that would block running new exports.
  • Fixed: Export Wizard - Fixed a crash that could occur when changing the default target folder for exports to a path that ends with a slash.

New in Studio 3T for MongoDB 2021.7.0 (Sep 16, 2021)

  • New: Incremental Migrations & Exports - Export only the newest documents in your collections.
  • New: MongoDB to SQL Migration - Customize target SQL types or create your own.
  • New: Data Masking - Added bulk editing, conditional masking based on field types and a new technique: "Replace field value with random string".
  • New: Import Wizard - Improved and updated the look of the Import Wizard.
  • Improved: General - Improved application look when the selected light/dark theme differs from the operating system default (Windows and Mac OS only).
  • Improved: General - Added support on Windows for a dark theme title bar.
  • Improved: Data Masking - Improved performance when masking an object with nested arrays.
  • Improved: Export Wizard - The Export Wizard now remembers and suggests the last chosen format selection.
  • Improved: IntelliShell - Added partial support for mongo shell 5.0.
  • Improved: IntelliShell - Add auto completion proposals for the shell helper commands "show databases" and "show roles".
  • Improved: SQL Query - Now supporting comparisons with other fields by using the $expr operator in MongoDB queries.
  • Improved: Query Code - Now supporting Mongo Java Driver 4.x.
  • Improved: Table and Tree View - Both Table and Tree View now support navigation with the HOME and END keys.
  • Improved: Connection Manager - Studio 3T will now remember the width of columns on the Connection Manager window.
  • Improved: Tasks - Added a new option to rename a task from its contextual menu.
  • Improved: Query History and Bookmark Manager - Searches in the Bookmark Manager are now case insensitive.
  • Fixed: General - Fixed crash when dropping a high number of databases.
  • Fixed: General - Fixed issue where read-only results would continue to allow operations if the _id field was projected out.
  • Fixed: General - Fixed issue where the read-only lock icon would erroneously display as disabled in read-only Query Assist results.
  • Fixed: Connection Manager - Fixed issue where directly connecting to a single replica set member would erroneously connect to the entire replica set.
  • Fixed: Connection Manager - Fixed a crash that could occur when importing an invalid connection string from the clipboard.
  • Fixed: Data Masking - Fixed issue when masking a string field with the substring regex match technique.
  • Fixed: IntelliShell - Fixed a crash that could occur when using Studio 3T's code formatter on a script.
  • Fixed: IntelliShell - Fixed an issue where a direct connection to a server would connect to the full replica set.
  • Fixed: Visual Query Builder - Fixed an issue where the Visual Query Builder would mistake an "ObjectId" in a textual query to be a "String".
  • Fixed: JSON Editors and Viewers - Fixed Studio 3T hanging when a search would find a match in a collapsed section.

New in Studio 3T for MongoDB 2021.6.1 (Aug 30, 2021)

  • Fixed: IntelliShell - Some cursor methods not working for DNS Seedlist connections.

New in Studio 3T for MongoDB 2021.6.0 (Aug 24, 2021)

  • New: SQL Migrations - Load and use Hackolade schema files within Studio 3T.
  • New: Connection Manager - Now supporting MongoDB Read Preference Tag Sets.
  • New: Connection Manager - Added option to set initial page size on a per-connection basis.
  • New: Export Wizard - Support for placeholders in target file and folder names.
  • New: JSON Editor and Viewers - Collapse and expand sections of JSON documents.
  • Improved: General - Upgraded to the latest MongoDB Java driver of version 4.3, compatible with MongoDB 5.0.
  • Improved: General - Added support for connecting to a serverless Atlas instance.
  • Improved: General - Added option to "Open recent" files in IntelliShell, SQL Query tab, Aggregation Editor, and Map-Reduce tab.
  • Improved: JSON Editor - Added support for the UUID function without arguments in all JSON documents.
  • Improved: Aggregation Editor - Support $out stages that write to Data Lake with Amazon S3.
  • Improved: Aggregation Editor - Added $search operator to aggregation pipeline, and other aggregation improvements released with MongoDB 4.4.
  • Improved: IntelliShell - Optimized IntelliShell startup time and improved startup UI.
  • Improved: IntelliShell - Added support for more find query cursor methods in Query Assist.
  • Improved: IntelliShell - Added support for using index specification documents when creating an aggregation hint.
  • Improved: Migration from SQL - Drastically improved speed of SQL operations with Oracle SQL; they now execute up to 44 times faster than before.
  • Fixed: General - Fixed issue with blurry data type icons, e.g. as shown in Table and Tree Views.
  • Fixed: General - Fixed issue where the JSON formatter compressed queries erroneously.
  • Fixed: Connection Tree - Fixed issue of replica set members not shown in the Connection Tree.
  • Fixed: Tree View - Fixed issue when navigating a nested result tree with the left and right arrow keys.
  • Fixed: Table and Tree View - Fixed issue with shortcuts AltGr + 1/2/3 on some keyboard layouts.
  • Fixed: Collection Tab - Fixed crash that could occur with some invalid queries.
  • Fixed: SQL Query - Fixed pop-up menu appearing in the SQL tab, even when there is no document present.
  • Fixed: Visual Explain: Fixed missing icon for EOF stages.
  • Fixed: IntelliShell - Fixed issue where saving an IntelliShell script would not update its respective tab title.
  • Fixed: IntelliShell - Fixed issue with code formatting that could break shell helper commands that contain names with special characters.
  • Fixed: Visual Query Builder - Fixed crash when changing field type to Reference.
  • Fixed: Export and Import Wizard - Fixed issue where exports with mongodump and imports with mongorestore would report an unclear status.
  • Fixed: Session Restore - Fixed crash that could occur when restarting Studio 3T with Session Restore enabled.
  • Fixed: Data Masking - Fixed crash occurring when editing a Data Masking task and the source connection is deleted.

New in Studio 3T for MongoDB 2021.5.1 (Jul 28, 2021)

  • Fixed:
  • General - Fixed a crash that could occur when working with connections that have a huge number (> 800) of databases.
  • Exports - Fixed an issue that could crash Studio 3T when working with a task that uses disconnected or deleted connections.
  • Exports - Fixed an issue where the command logged for mongodump and mongorestore could reveal the credentials of a connection.
  • IntelliShell - Reverted a change that could create a big number of result tabs from documents embedded in textual shell output.

New in Studio 3T for MongoDB 2021.5.0 (Jul 20, 2021)

  • New: Data Masking - Shuffle, a new Data Masking technique.
  • New: Collection Tab - Added two-way interaction between the Query Bar and Visual Query Builder on a collection tab.
  • New: Operations Tab - Added an option to expand the Operations pane into its own tab.
  • New: MongoDB 4.4 - Now bundling MongoDB 4.4 tools with Studio 3T installations.
  • Improved: Connection Manager - The connection manager now allows to assign a keyboard shortcut to every connection.
  • Improved: Connection Tree - The connection tree will now include nodes for the users, roles and functions of a database.
  • Improved: Connection Tree - Improved search and added a context menu to the search results.
  • Improved: Connection Tree - Show the size of an index in the Index Properties tab (right-click index > Show Properties).
  • Improved: IntelliShell - Added a new option to pin all result tabs of a script execution to keep them open.
  • Improved: IntelliShell - Introduced a new option to restart the mongo shell process from the toolbar of an IntelliShell tab.
  • Improved: Visual Query Builder - Introduced an option to turn off the automatic completion of field names while typing.
  • Improved: Export Wizard - The exact command line of a mongodump or mongorestore execution is now available from an export unit's log.
  • Improved: Migration from SQL - Improved overall performance of a running migration task.
  • Fixed: Aggregation Editor - Fixed error thrown when using simplified form of the $merge pipeline stage.
  • Fixed: Table View - Fixed shift + double-click behavior, in order to let it step into a cell again.
  • Fixed: Visual Explain - Change the default double-click behavior on explain stages to show the original JSON fragment for each stage.
  • Fixed: Data Compare & Sync - Fixed an issue where the option "Retain original target document _id" did not work as expected.
  • Fixed: Migration from SQL - Fixed a crash that could occur when nesting array mappings.
  • Fixed: Session Restore - Fixed crash when editing a restored "Edit View" tab.
  • Fixed: Session Restore - Fixed an issue with the Visual Query Builder not restoring field values.

New in Studio 3T for MongoDB 2021.4.1 (Jul 1, 2021)

  • Fixed: Edit View - Fixed an issue where running the aggregation pipeline of a view would return incorrect or no results at all.
  • Fixed: JSON Editor - Fixed an issue where the confirmation dialog of the JSON Editor could not be closed with Ctrl/Cmd + Return.

New in Studio 3T for MongoDB 2021.4.0 (Jun 24, 2021)

  • New: Hotkeys - Customize and add your own shortcuts
  • New: SQL Query - Now supporting SQL smart auto-completion
  • New: JSON View and Editor - Simultaneously edit multiple JSON documents and view JSON results as pure JSON
  • New: Data Masking - Now supporting different source and target connections
  • New: Indexes in a collection can now be individually copied and pasted
  • Improved: General - Extended the option to include a collection's database name in tab titles to more tabs
  • Improved: IntelliShell- Query Assist result tabs now always display headings corresponding to the line number of the executed query
  • Improved: IntelliShell - The limit on the maximum line count in the Raw Shell Output is now configurable
  • Improved: MongoDB to SQL Migration - Increased field limit for default mappings from a hundred to a thousand fields
  • Fixed: General - Fixed issues that could occur with collection names that included spaces
  • Fixed: General - Fixed an issue that could occur when trying to resolve server addresses using MongoDB DNS SRV connection strings
  • Fixed: SQL Query - Fixed an issue where the export of results from some SQL queries would not be available
  • Fixed: Collection Tab - Fixed sizing issue for input fields in the collection tab
  • Fixed: Reschema - Fixed a crash that could occur when editing a task associated with a disconnected connection
  • Fixed: Tasks - Tasks associated with a specific connection will now update properly when the connection is deleted
  • Fixed: Table View - Optimized cell editing in Table View

New in Studio 3T for MongoDB 2021.3.1 (Jun 2, 2021)

  • Fixed: SQL Query - Fixed a crash that could occur when trying to export the results of a query.

New in Studio 3T for MongoDB 2021.3.0 (May 25, 2021)

  • New: Improved Dark Theme.
  • New: Data Masking - Now available on exports.
  • New: Visual Explain - Improve aggregation query performance.
  • New: Improved search in Tasks, Data Masking & Query History.
  • General: Fixed bug when attempting to navigate between tabs from the toolbar.
  • Improved: Aggregation Editor - Added option to deactivate automatic completion on Aggregation Editor stage tabs.
  • Improved: Data Compare & Sync - Added option to allow treating 'null' values on match fields just like any other value.
  • Improved: Export Wizard - Added rescan component to the source widget, CSV, and SQL export unit tabs.
  • Improved: Export Wizard - Added option to clear an existing collection, instead of dropping it, to preserve index definitions.
  • Improved: Import Wizard - Added option to clear an existing collection, instead of dropping it, to preserve index definitions.
  • Improved: In-Place Data Editing - Now supporting aggregation pipeline commands to update your documents.
  • Improved: In-Place Data Editing - Added option to introduce new field in all existing documents of a collection.
  • Improved: IntelliShell - Now fully supporting index hint options in IntelliShell.
  • Improved: MongoDB to SQL Migration - Increased maximum number of documents that can be scanned to set up a migration.
  • Improved: Query History - New functions in query history and bookmarks: Save a query history item as a bookmark, clear history, and more.
  • Improved: Reschema - Added rescan component to the source widget.
  • Improved: Reschema - Now pre-filling connection tree in source and target selection wizards.
  • Improved: SQL to MongoDB Migration - Improved import UI navigation.
  • Improved: SQL to MongoDB Migration - Added option to clear an existing collection, instead of dropping it, to preserve index definitions.
  • Fixed: IntelliShell - Fixed bug when executing long lines of script.
  • Fixed: Query History - Fixed missing toolbar action when opening a new SQL tab.
  • Fixed: Table View - Fixed additional columns showing up after editing on Table View.

New in Studio 3T for MongoDB 2021.2.0 (Mar 15, 2021)

  • New:
  • Task Scheduler - Now available in all editions.
  • Result Tab - Copy and paste query results to Excel and CSV.
  • General - Multi-line text editor for JSON now supports automatic word wrapping.
  • Improved:
  • Aggregation Editor - Included "Other" option in the stage operator drop-down menu.
  • Connection Manager - Now preserving the checkbox state when changing the order of connections during import.
  • Data Compare & Sync - Added ability to turn off the "noCursorTimeout" option.
  • Export Wizard - Now pre-filling the Connection Tree in the wizard when choosing "Connection Tree item" as a source.
  • -IntelliShell - Restored parsing of up to 10 non-contiguous documents and arrays from the raw shell output.
  • SQL to MongoDB Migration - Improved UX when importing units using custom SQL queries.
  • Fixed:
  • General - Fixed query formatting to again include missing space characters.
  • General - Fixed application freezing when disconnecting without a network connection.
  • Aggregation Editor - Now excluding $out and $merge stages when counting aggregation results.
  • Collection Tab - Fixed bug when changing fields using "Document matching query criteria" with unsupported field types.
  • Connection Manager - Fixed "RSA modulus is even" error when opening SSH tunnel.
  • Current Operations - Restored option to "Kill Operation".
  • Data Masking - Fixed crash that could occur when collections contain OS reserved characters.
  • GridFS Support - Fixed UX issues in the bottom bar of the GridFS Bucket tab.
  • Index Manager - Fixed crash with invalid collation options in “Add Index”, improved validation error messages.
  • IntelliShell - Fixed crash that could occur when executing invalid queries at cursor.
  • Query History and Bookmark Manager - Clicking the down arrow now again opens a search on the query history.
  • Query History and Bookmark Manager - "Overview" component no longer disappears when changing the window width.
  • Reschema - Now correctly applying the chosen insertion mode when updated.
  • Session Restore - Fixed Session Restore for Visual Query Builder.
  • Visual Explain - Now recognizing projections and rendering them correctly.

New in Studio 3T for MongoDB 2021.1.1 (Feb 11, 2021)

  • Fixed: Result Tab - Fixed crashes when editing "regex" values using the dialog that opens with the "..." button.
  • Fixed: IntelliShell - Fixed a crash that would occur when trying to cycle through tabs of an IntelliShell.
  • Fixed: IntelliShell - Fixed crashes that could occur when trying to run a script while the shell is still busy.
  • Fixed: IntelliShell - Fixed crashes that would occur when executing big scripts with over a million characters.
  • Fixed: IntelliShell - Fixed missing syntax highlighting for multi-line comments (/* ... */) in script editors.
  • Fixed: IntelliShell - Fixed shortcut Ctrl/Cmd-Enter to run the command at the cursor position, like in previous releases.

New in Studio 3T for MongoDB 2021.1.0 (Feb 4, 2021)

  • Improved: IntelliShell - A better, faster mongo shell.
  • Improved: General - Rolled out the second phase of Big Sur compatibility updates.
  • Improved: General - Now limiting batch size for simple queries to optimize performance.
  • Improved: Connection Manager - Now remembers sort column and order when reopened.
  • Improved: Connection Tree - Shortcut to expand/collapse connections now works on all selected connections.
  • Improved: Collection Tab - Introduced a broom icon that clears the query, projection, sort, skip, and limit parameters in one click.
  • Improved: Collection Tab - Added more options in the Result tab drop-down to view 1, 5, 10, 25, 50, 100, or 200 documents per page.
  • Improved: Document JSON Viewer - Added _id hover tooltip.
  • Improved: Document JSON Viewer - JSON formatter now recognizes single-quoted strings.
  • Improved: Migration from SQL - Improved error messaging when connection times out while adding a one-to-many relationship.
  • Improved: Migration from SQL - Added "Reuse Dataset" option to make it easier to re-add all fields in a previously-used dataset.
  • Improved: Migration to SQL - Renamed MongoDB type option from "Unknown", which is used when multiple types have been detected, to "Mixed".
  • Improved: Role Manager - Added missing privilege actions: replSetStateChange, moveChunk, and renameCollectionSameDB.
  • Fixed: General - Fixed crash that could occur when changing themes without restarting Studio 3T.
  • Fixed: General - Fixed display issues that could occur in multi-monitor setups with different scaling.
  • Fixed: Binary Value Editor - Fixed errors when exporting binary, binary legacy, and function data types.
  • Fixed: Connection Manager - Fixed performance issues that could occur when opening a database with thousands of collections.
  • Fixed: Data Compare & Sync - Fixed scrolling issues that could occur in the Differences tab.
  • Fixed: Data Masking - Now showing all fields as the default view when a configuration is reset.
  • Fixed: Data Masking - Fixed random values generated by the masking technique "Negate boolean value".
  • Fixed: Migration to SQL - MongoDB to SQL migrations run from the Task Manager now reflect the correct SQL target format.
  • Fixed: Query Manager - Fix the time shown for "Execution date and time" and "Last modified date and time" to show in 24-hour format.
  • Fixed: Reschema - Fixed an issue with "unwind" on arrays.
  • Fixed: Reschema - Fixed an issue where the toolbar icons in Light Mode appeared too small.
  • Fixed: Result Tab - Introduced a keyboard short-cut for "Follow Reference".
  • Fixed: SQL Tab - Fixed UX issue, Query History and Bookmark Manager icons now always visible.
  • Fixed: View Manager - Now saving custom collation options, fixed redundant in-app messaging.
  • Fixed: Visual Explain - Fixed display issues when using high DPI settings (Windows only).
  • Fixed: Visual Query Builder - Fixed display issues when using high DPI settings (Windows only).

New in Studio 3T for MongoDB 2020.10.1 (Dec 16, 2020)

  • Fixed: Reschema - Fixed a crash that could occur when trying to unwind an empty array.
  • Fixed: Editor Search - Fixed freezes of Studio 3T that could happen when using the editor search feature.
  • Fixed: Copy Collection - Fixed failures with collections that contain indexes with a TTL value of type 'NumberInt'.
  • Fixed: Collection Statistics - Fixed the collection statistics tree to show more than one level of information.

New in Studio 3T for MongoDB 2020.10.0 (Dec 9, 2020)

  • New:
  • Data Masking - Obfuscate collections on a field level. (Enterprise only)
  • Reschema - Move collections to a new schema. (Pro and Enterprise only)
  • General - Operations timer now runs when carrying out various operations like copy/paste collections and exports.
  • Formatting - Fixed issue of illegal space characters being added to regexes.
  • Data Compare and Sync - Fixed issue with differences appearing in the Overview tab but not in the Differences tab.
  • Data Compare and Sync - Fixed crash that could occur when used with Tasks.
  • Export Wizard - Fixed crash that could occur when exporting an aggregation query from the clipboard.
  • Export Wizard - Fixed exports failing with "Illegal state: No users to detach".
  • MongoDB to SQL Migration - "New mapping" will now respect the provided number of documents to scan, instead of defaulting to 50.
  • Server Status Charts - Fixed an issue where errors were reported redundantly.
  • Session Restore - Fixed an issue with auto-completion not working in restored stage editors of Aggregation Editor tabs.
  • Session Restore - Fixed an issue where a broken saved session would prevent Studio 3T from starting.
  • Session Restore - Fixed a crash that could occur when closing restored SQL to MongoDB migration tabs.
  • Tasks - Fixed a crash that could occur when trying to edit an export task with a deleted source connection.
  • Improved:
  • General - Rolled out first phase of macOS Big Sur compatibility
  • General - Removed mongo tool bundles of version 3.0, 3.2, and 3.4 to reduce installer size.
  • General - Implemented new design for source/target selection widget in export tasks.
  • Collection Tab - Added short-hand query options to search by _id in the Query Bar.
  • Collection Tab - Restored milliseconds view in the Result Tab's query elapsed time indicator.Connection Tree - Now displaying replica set names.
  • Dark Theme - Fixed UX issues when used in tandem with Export Wizard.
  • Dark Theme - Improved legibility of drop-down options in Aggregation Editor and toolbar texts.
  • Dark Theme - Brought back foreground colors on Ubuntu, e.g. color coded connections in the Connection Tree.
  • Export Wizard - Improved UX flow.

New in Studio 3T for MongoDB 2020.9.3 (Oct 28, 2020)

  • New: Licensing - Added proxy authentication support for License Manager connections.
  • Fixed: Connection Manager - Fixed an issue in some connections where server addresses fail to resolve.
  • Fixed: JSON Formatter - Fixed issues that could occur when formatting constructor arguments or empty arrays.

New in Studio 3T for MongoDB 2020.9.2 (Oct 21, 2020)

  • Fixed: Query Manager - Fixed a crash that could occur while using bookmarks created with Studio 3T versions older than 2019.7.

New in Studio 3T for MongoDB 2020.9.1 (Oct 20, 2020)

  • Fixed: General - (macOS only) Fixed an issue that could lead to random crashes on macOS.

New in Studio 3T for MongoDB 2020.9.0 (Oct 15, 2020)

  • New: Query Manager - Unify Query History and Bookmark Manager.
  • New: Result Tab - The elapsed time for running queries is now shown in many places.
  • New: Connection Manager - Allow more control over databases that are added to the connection tree.
  • Improved: Feedback - Improved in-app feedback mechanism, now auto-filling fields.
  • Fixed: General - Fixed issues that could occur when typing Chinese characters in editors.
  • Fixed: General - Fixed issue where "Copy Database" would continue to copy views, even after it has been cancelled.
  • Improved: Dark Theme - [macOS only] Fixed visual glitch in Visual Query Builder during certain hover actions.
  • Improved: Preferences - Improved messaging under Preferences > Proxy to warn about missing proxy support on IntelliShell.
  • Improved: Export Wizard - Improved UX when invalid input is detected while editing the query of an export unit.
  • Improved: Collection Tab - Improved the Multi-line query editor UX to match those found in other places.
  • Improved: Aggregation Editor - Added support for $unionWith stage.
  • Improved: Aggregation Editor - Stage operators now shown in the stage tabs for easier navigation.
  • Improved: Connection Manager - Now automatically detects and parses connection strings from MongoDB Compass.
  • Improved: Connection Manager - Now displaying a security reminder when "None" or "Legacy" is chosen as the authentication method.
  • Improved: MongoDB to SQL Migration - Improved in-app tutorial.
  • Improved: Visual Query Builder - Now rejecting drag-and-drop of fields with unsupported data types, showing a message dialog instead.
  • Fixed: Tasks - Brought back confirming and closing "Save Task" dialogs with the Enter key.
  • Fixed: Tasks - [Ubuntu only] Fixed UI issues when highlighting a cell in the Status column; icons also now showing when a task is selected.
  • Fixed: Dark Theme - Improved readability of the selected task's name in the Task Manager.
  • Fixed: Export Wizard - Fixed crash that could occur when running an export task after closing all of its unit tabs.
  • Fixed: Collection Tab - [Windows only] Fixed Expand and Expand Recursively when multiple documents are selected.
  • Fixed: Connection Tree - [Ubuntu only] Fixed issue with color-coded connections.
  • Fixed: Connection Tree - Fixed issue with collections being removed, even though they haven't been dropped, e.g. due to missing permissions.
  • Fixed: Connection Manager - [Ubuntu only] Fixed status colors in the Test Connection window.
  • Fixed: Connection Manager - Fixed parsing issue with NoSQLBooster connection strings.
  • Fixed: Connection Manager - Fixed SRV connections that failed when configured to use a custom Root CA certificate.
  • Fixed: Aggregation Editor - Fixed code formatting issues in the stage editor.
  • Fixed: Data Compare and Sync - Fixed color transparency levels in the Comparison Unit table.

New in Studio 3T for MongoDB 2020.8.0 (Sep 10, 2020)

  • New: Introducing our new product: Server 3T - Run migrations between SQL and MongoDB remotely.
  • New: Collection Tab - Change sort order of queries in one click.
  • New: Connection Manager - Disconnect from all connections in one go.
  • New: Connection Manager - Auto-detect and import connection strings copied to clipboard.
  • Improved: General - Improved responsiveness of auto-completion in scripts.
  • Improved: General - Improved visibility of separator labels on Ubuntu 20.04.
  • Improved: General - Now showing dark title and toolbar on macOS in dark mode.
  • Improved: Visual Query Builder - Improved color definitions in Visual Query Builder.
  • Improved: Export Wizard - "Other options" now updating whenever source is updated.
  • Improved: Export Wizard - Export units with cursor/selected documents as source can now be saved.
  • Improved: Map-Reduce - Database names now displayed in Map-Reduce tab names.
  • Improved: SQL to MongoDB Migration - Improved custom SQL query in-app messaging.
  • Fixed: General - Fixed issue with weird characters appearing as tab names.
  • Fixed: SQL Query - Restored missing right-click copy options.
  • Fixed: Map-Reduce - Restored missing right-click copy options.
  • Fixed: Aggregation Editor - Restored missing right-click copy options.
  • Fixed: Visual Query Builder - Fixed UI issues on Linux.
  • Fixed: Role Manager - Fixed issues with editing and updating role privilege actions.
  • Fixed: Quickstart Tab - Now showing correctly upodated colors in color-coded connections.
  • Fixed: Export Wizard - Fixed issues with loading indicators shown on Ubuntu.
  • Fixed: Export Wizard - Fixed crash on export issues on Linux with unsupported MongoDB version.
  • Fixed: Export Wizard - Fixed issues related to mongodump exports failing when collection names contain a colon.
  • Fixed: Export Wizard - Fixed issue related to export files being overwritten during failed current cursor exports.
  • Fixed: Data Compare & Sync - Fixed crash that could occur when editing a DCAS task on an undocked window.
  • Fixed: Import Wizard - Fixed crash that could occur when clicking options on and off with BSON archive imports.
  • Fixed: Import Wizard - Target collection now emptied when target database is disabled during BSON archive imports.
  • Fixed: SQL to MongoDB Migration - Fixed issues with username label shown for Oracle connections.

New in Studio 3T for MongoDB 2020.7.1 (Aug 10, 2020)

  • New: Licensing - Added proxy support.

New in Studio 3T for MongoDB 2020.7.0 (Jul 27, 2020)

  • New: Table View - Copy selected documents to CSV
  • New: Export Wizard - Edit find() queries on an export tab
  • New: Query History - Added a new option to allow a custom limit for the number of history entries
  • New: MongoDB to SQL Migration - Running a migration will write warnings and errors to a log file
  • Improved: SQL to MongoDB Migration - Removed special handling of the internal MongoDB timestamp field type
  • Fixed: Result Tab - Brought back "Copy Field Name" option on all table and tree views
  • Fixed: Result Tab - Fixed issue with tooltip values being cut off by their corresponding column widths
  • Fixed: Aggregation Editor - Pasting a script from clipboard now doesn't override the associated script file
  • Fixed: IntelliShell - Fixed an issue that could occur on connections using an SSL certificate and a passphrase
  • Fixed: Reference Dialog and Follow Reference - Fixed a crash that could occur when trying to resolve an invalid DBRef
  • Fixed: JSON Validator - Fixed the width of the "Edit Validator" dialog when opened on connections that have long names
  • Fixed: SQL Import - Fixed a crash that could occur when disconnecting from then reconnecting to a target connection
  • Fixed: Connection Manager - Fixed inconsistencies in server names and port numbers when importing connection URIs from other tools
  • Fixed: Export Wizard - Fixed an issue with missing export source information when exporting current cursor/selected documents
  • Fixed: Session Restore - Fixed a crash that could occur when closing a restored collection tab when the Explain tab is selected

New in Studio 3T for MongoDB 2020.6.1 (Jul 9, 2020)

  • Fixed: General - Fixed a memory management issue that could lead to crashes and slower app performance.

New in Studio 3T for MongoDB 2020.6.0 (Jul 3, 2020)

  • New: In-app makeover with a new look, new colors and better tabs.
  • Improved: General - Improve behavior when closing tabs with using the middle mouse button.
  • Improved: Connection Manager - Each connection now shows the date it had last been accessed.
  • Improved: Connection Manager - Improved handling of imported Robo 3T connections, SSL credentials now being imported.
  • Improved: Connection Manager - Include local mongo tools settings for connections in exports and imports.
  • Improved: Connection Tree - Added update shown connection names after they have been edited.
  • Improved: Export Wizard - Improved handling of GridFS bucket exports.
  • Improved: Export Wizard - Improved handling of export units that write results to the clipboard.
  • Improved: Aggregation Editor - Drastically improved performance when working with many aggregation stages.
  • Improved: Aggregation Editor - Added shortcuts for new stages: $merge, $planCacheStats, $replaceWith, $set, $unset.
  • Improved: Aggregation Editor - Added ability to change databases, collections, and connections for aggregation queries.
  • Improved: Aggregation Editor - Improved legibility of Refresh button and pagination controls when results are out of date.
  • Improved: Aggregation Editor - Support code formatting in stage editor (use Ctrl + Alt + L to format code).
  • Improved: Aggregation Editor - Improved notifications in the Explain tab.
  • Improved: SQL Query - Commenting with line comment now preserves selection.
  • Improved: Schema Explorer - Improved readability of schema analysis progress.
  • Improved: Data Compare & Sync - Improved UX of compare results tab after session restore.
  • Improved: Visual Query Builder - Added support for DBref (Reference) value.
  • Fixed: Table View - Fixed bug when sorting a query result on a binary data field.
  • Fixed: Table View - Fixed settings so that changes to views do not affect global settings.
  • Fixed: Tasks - mongodump and mongorestore imports and exports now work with MongoDB Atlas SRV connections.
  • Fixed: Export Wizard - Fixed a crash that could occur when trying to directly export an index of a collection.
  • Fixed: Aggregation Editor - Fixed crash that could occur when reordering the pipeline in an undocked aggregation window.
  • Fixed: Data Compare & Sync - Fixed bug in exported data when there is an instance of "No source/target document matched".
  • Fixed: Data Compare & Sync - Fixed bug when adding non-object, non-array values.
  • Fixed: Ubuntu Installer - Fixed text visibility on the installer for Ubuntu 20.04 in Dark Mode.
  • Fixed: IntelliShell - Fixed keyboard shortcuts when switching between Table, Tree, and JSON Views.
  • Fixed: Import Wizard - Fixed a crash that could occur when using a source file name with special characters.
  • Fixed: MongoDB Migration - Fixed bug where the "Scanning collections" would overlap the "First steps".
  • Fixed: Session Restore - Custom tab names are now restored when starting from a previous session.
  • Fixed: Session Restore - Data Compare & Sync now restores comparisons configured for system collections.
  • Fixed: SQL to MongoDB Migration - Fixed validation issues.
  • Fixed: SQL to MongoDB Migration - Fixed truncated source and target connections.
  • Fixed: SQL to MongoDB Migration - Fixed SQL Server import behavior for columns names with trailing spaces.
  • Fixed: SQL to MongoDB Migration - Fixed blank lines that appeared when clicking on an empty source SQL database.
  • Fixed: SQL to MongoDB Migration - Fixed decimal type handling and mapping, now maps to the BSON counterpart Decimal128.
  • Fixed: SQL Query - Fixed keyboard shortcuts when switching between Table, Tree, and JSON Views.

New in Studio 3T for MongoDB 2020.5.0 (May 13, 2020)

  • New: Connection Manager - Encrypt stored passwords via our new cryptographic key store
  • Improved: SQL to MongoDB Migration - Added support for importing custom SQL Queries to MongoDB
  • Improved: Export Tasks - Added the ability to change target folders for all export units of a task
  • Improved: Session Restore - Restore the width of Visual Query Builder in Collection Tab and IntelliShell
  • Fixed: Table View - Make "Step Into Cell" behave correctly with documents missing the '_id' column
  • Fixed: Table View and Visual Query Builder - Fixed situations where tool tips would 'block' input editors
  • Fixed: Session Restore - Fixed an issue with restoring the option "Allow disk use" in Aggregation Editors
  • Fixed: Copy/Paste Collection - Preserve all 'capped' options and settings when copying a collection
  • Fixed: Collection Statistics - Fixed an error that could occur with very large databases or collections

New in Studio 3T for MongoDB 2020.4.0 (Apr 14, 2020)

  • New: License Manager - Manage licenses in one place, online.
  • New: SQL Migration - Added support for the migration from and to IBM DB2.
  • Improved: SQL Migration - The migration to SQL now allows to automatically drop existing tables.
  • Improved: Export Tasks - Improved handling of connections with password prompts.
  • Improved: Export Tasks - Added support for changing the source of a configured export task.
  • Improved: Export Tasks - Introduce a global and customizable default target folder for new export units.
  • Improved: Aggregation Editor - Fixed disabled editors of stages that have been excluded from the pipeline.
  • Improved: Server Status Charts - Added a notification that is shown for users with insufficient permissions.
  • Fixed: Export Tasks - Restored the option to show the results of an export in the system's file explorer.
  • Fixed: Export Tasks - Fixed several issues with the schema scan and export of long running aggregate queries.
  • Fixed: CSV Import - Fixed a crash that could occur when the delimiter of a CSV import task was changed.

New in Studio 3T for MongoDB 2020.3.0 (Mar 7, 2020)

  • New: Connection Configuration - Improved interface for different connection types.
  • Fix: Table View - Fixed a crash that could occur when dragging values during a running operation.
  • Fix: Aggregation Editor - Fixed appearance of pipeline and stage result views in Dark Mode.
  • Fix: Aggregation Editor - Fixed shortcut ALT + '7' for users of non-international keyboard layouts.
  • Fix: Data Compare and Sync - Fixed an error that could occur with documents that have many children.
  • Fix: Refresh View - Fixed menu entries and shortcuts for "Refresh View".
  • Improved: MongoDB Tool Bundles - Updated bundled MongoDB tools for version 4.0.
  • Improved: Application Startup on Linux - Improved long startup times of Studio 3T on Linux.

New in Studio 3T for MongoDB 2020.2.1 (Feb 18, 2020)

  • Fix: Studio 3T on macOS - Fixed startup of fresh installations of Studio 3T on macOS.
  • Fix: Connection Configuration - Fixed empty server address for connections of type DNS Seedlist.

New in Studio 3T for MongoDB 2020.1.2 (Jan 17, 2020)

  • Fix: Collection Statistics - Fixed an error that occurred with big values of 'storageSize'.

New in Studio 3T for MongoDB 2020.1.1 (Jan 10, 2020)

  • Fix: Table View - Improved horizontal scroll experience in table view when no search is active.
  • Fix: CosmosDB - Fixed listing collections for connections to Microsoft Azure CosmosDB (no official support).

New in Studio 3T for MongoDB 2020.1.0 (Jan 7, 2020)

  • New: Quickstart - Enjoy quick access to the most popular options and features in Studio 3T at one glance.
  • New: What's New - Find the latest Studio 3T release notes, product updates etc. under the separate What's New tab.
  • Fix: Table View - Fixed a rare crash on Windows that occurred when a table view with an id column was shown.
  • Fix: Aggregation Editor - Fixed a noticable slowdown in the stage editor performance with bigger aggregation stages.
  • Improved: Dark Theme - Many improvements to the user interface with dark theme enabled.
  • Improved: SQL Migration - The migration to SQL now supports a wider charset for the data export: UTF8 MB4.
  • Improved: JSON View - Support standard options to copy documents, just as in the table and tree view.
  • Improved: Connection Tree - Introduced option "Duplicate Collection" to easily duplicate a collection.

New in Studio 3T for MongoDB 2019.7.1 (Nov 18, 2019)

  • Fix: Table View - Fixed broken up/down arrow key navigation.

New in Studio 3T for MongoDB 2019.7.0 (Nov 18, 2019)

  • New: Session Restore - Automatically save the state of Studio 3T on shutdown and restore it on the next start (BETA).
  • New: MongoDB Tools Integration - Allow connections to define a specific set of MongoDB tools, overriding global defaults from preferences.
  • New: Table and Tree View - Both the table and tree view for documents now come with their own, integrated search feature.
  • New: Table View - The table view now allows to configure and automatically apply automatic column widths to result views.
  • Fix: Create Index - Fixed creating indices with the partial index option.
  • Fix: Add Collection - Fixed applying custom collation options when a new collection is created.
  • Fix: Connection Manager - Fixed situations where shown connections would not be updated after changes when a table search was active.
  • Fix: Fixed a rare crash of the preferences dialog on Linux operating systems when it was opened with the dark theme enabled.

New in Studio 3T for MongoDB 2019.6.1 (Oct 22, 2019)

  • Fixed: Issue that prevented selecting/deselecting databases and collections in BSON Import.

New in Studio 3T for MongoDB 2019.6.0 (Oct 16, 2019)

  • New: Query Code - Now supports Ruby driver code generation.
  • New: Aggregation Editor - Added 'Duplicate Stage' option.
  • Improved: Query Code - Improved PHP driver code syntax.
  • Improved: Query Code - 'Open in IntelliShell' option is now included everywhere Query Code appears.
  • Improved: JSON View - Introduces clearer, full-width line separators.
  • Improved: Support full range of all accepted ISO date formats.
  • Fixed: Certain index options were not honoured at index creation under particular configurations.
  • Fixed: Export - Order of fields correctly restored when a saved export configuration is loaded.
  • Fixed: Shift + Del would fail to cut text on Windows in specific situations.
  • Fixed: Aggregation Editor - Improved handling of non-breaking space characters.
  • Plus many other smaller fixes and improvements.

New in Studio 3T for MongoDB 2019.5.1 (Sep 20, 2019)

  • Fixed: Typing slowdown in Aggregation Editor has been addressed
  • Fixed: Retain user preferences after theming is applied

New in Studio 3T for MongoDB 2019.5.0 (Aug 28, 2019)

  • New: Dark Mode - Studio 3T now includes a dark theme.
  • Improved: SQL to MongoDB Migration - By default, a mapping for the _id field is now created for the source table's primary key.
  • Improved: SQL to MongoDB Migration - When connecting to a new SQL server, the validity of existing configured mappings are automatically checked.
  • Improved: IntelliShell - Fixed connection failures to particular configurations of MongoDB 3.4 or older.
  • Fixed: Aggregation Editor - Fixed script copied to the clipboard for empty pipelines with collation option.
  • Fixed: Table View - "Make All Columns Visible" will now also restore all columns that have been reduced to a zero width.
  • Fixed: Collection Statistics could fail to report in particular circumstances with MongoDB 4.2.
  • Fixed: Collection Import - Fixed an issue where unique indices could result in collisions.
  • Plus several other smaller fixes and improvements.

New in Studio 3T for MongoDB 2019.4.1 (Aug 2, 2019)

  • Improved: Aggregation Editor - Auto-completion will now activate successfully for users that do not have the 'listDatabases' privilege.
  • Improved: Document editors now support specifying a MongoDB ISODate without separators, such as ISODate("20190801T000000Z").
  • Plus several other smaller fixes and improvements.

New in Studio 3T for MongoDB 2019.4.0 (Jul 31, 2019)

  • New: Aggregation Editor - Auto-completion has now been added to the Aggregation Editor.
  • New: Collection View - Shell-format find queries (e.g. db.coll.find(...)) can now be pasted directly into Collection View.
  • Improved: Oracle SQL Connections - Internally using services-based connections for improved compatibility.
  • Improved: Collection copy no longer exhibits a possible performance drag when there are undefined fields.
  • Improved: IntelliShell - Selected text can be (un)indented by pressing (Shift+)Tab.
  • Improved: Aggregation Editor - Queries viewed in Query Code can be opened directly in IntelliShell.
  • Plus many other smaller fixes and improvements.

New in Studio 3T for MongoDB 2019.3.0 (Jun 3, 2019)

  • New: MongoDB to SQL Migration - Export your entire MongoDB domain model, expressing full document structure and relationships, into a rich SQL relational model. (Enterprise only)
  • New: Connection Groups - Arrange connections in related groups in Connection Manager.
  • New: Query History - Aggregation Editor, SQL Query and IntelliShell all now offer Query History.
  • New: From the View menu, or via keyboard shortcut, the main toolbar can be hidden/shown.
  • New: Visual Query Builder - Query clauses and Project and Sort sections can now be dynamically included/excluded in the query.
  • New: Support for --retryWrites option available in Advanced connection settings.
  • New: SQL Query - Added support for regexes in JSON where blocks.
  • New: SQL Query - Queries that translate to a MongoDB aggregation query can now be opened in the Aggregation Editor directly from the Query Code tab.
  • Improved: SQL to MongoDB Migration - Improved and simplified Mappings tab.
  • Improved: SQL to MongoDB Migration - Simplified specifying one-to-many relationships.
  • Improved: SQL Query - Automatically running explain initially is deferred to when the Explain tab is switched to.
  • Improved: IntelliShell - Faster start-up and command execution times in high latency environments.
  • Improved: Recent connections - Upon use, recent connections are moved to the top of the recent connections list.
  • Improved: Visual Query Builder - The shortcut Ctrl/Cmd+B is now used to show/hide the Visual Query Builder.
  • Improved: CSV Import Task - Manually tweaked mapping types are saved in the task.
  • Improved: Field Edit Value/Type - Symbol type supported in auto-converting field types.
  • Improved: Auto-Update - Improved start-up times when checking for new update.
  • Improved: Current Operations - Included 'Show JSON Document' option for each operation.
  • Improved: Current Operations - Included 'Show/Hide All Embedded Fields' options in table view.
  • Fixed: Data Compare and Sync - Comparison succeeds with excluded fields that have null value.
  • Fixed: Automation - Scheduled tasks can have their schedule removed when no longer using a trial or Enterprise license.
  • Fixed: Open Connections Tree - Improved handling of invalid validation schema, which may have lead to collections not appearing in MongoDB 4.0 and later.
  • Fixed: macOS - Restore fullscreen when restarting.
  • Fixed: Resolved 'No Route To Host' issue in IPv6 handling on macOS.
  • Fixed: "SSH tunnel error I/O: Bad Item Length" error which could occur in particular configurations.
  • And several other smaller fixes and improvements.

New in Studio 3T for MongoDB 2019.2.1 (Apr 1, 2019)

  • New: Double-click a tab header to maximize the tab (within the main application window).
  • Fixed: SQL to MongoDB Migration - Improved handling of foreign keys.
  • Fixed: Tasks - Retain scheduling after particular tasks are edited.

New in Studio 3T for MongoDB 2019.2.0 (Mar 22, 2019)

  • New: SQL to MongoDB Migration - Import your entire SQL domain model, capturing relationships between tables, into a rich MongoDB document model. (Enterprise only)
  • New: Tasks - Turn often used import, SQL to MongoDB migration and Data Compare & Sync job into tasks, and be able to conveniently view, manage and execute those tasks all with the new Tasks manager.
  • New: Automation - Schedule tasks to automatically run at specific times or at regular intervals, as you require. (Enterprise only)
  • New: Support for short SRV connection strings.
  • Fixed: Prompt for password if empty for basic (SCRAM-SHA-256) authentication.

New in Studio 3T for MongoDB 2019.1.0 (Mar 6, 2019)

  • New: SQL Query - Support for SELECT DISTINCT statements has now been added. Please see the SQL Query tutorial at https://studio3t.com/knowledge-base/articles/sql-query/ for details.
  • New: SQL Query - Object values are now supported in SQL queries. Please see the SQL Query tutorial at https://studio3t.com/knowledge-base/articles/sql-query/ for details.
  • New: The Field menu -> Edit Value / Type... option now supports changing the type of a field, but preserving its value where possible, allowing you to cleanse data types throughout a collection.
  • New: What's New and Feature Galleries.
  • Improved: JSON View - UUID types are now rendered in UUID format, rather than in their BinData representation.
  • Improved: Rendering of Import/Export dialogs on smaller resolutions.
  • Fixed: Collection View - Certain complex queries failed to export to CSV.
  • Fixed: Visual Explain - Improved count statistics in certain complex scenarios.
  • Fixed: Visual Explain - Resolves 'Failed to determine query execution plan' error when running on a newly copied collection.
  • Fixed: Shortcut to close without being prompted to save is now correctly reported on Windows to be 'Control+Shift+F4'.
  • Fixed: 'Unsatisfied link error' error which some customers experienced on startup.
  • Fixed: IntelliShell - Now retains JSON formatting preference selection from elsewhere in the application.
  • Fixed: Map/Reduce - 'Sample the output of the map() function' option would fail to run in certain conditions.

New in Studio 3T for MongoDB 2018.6.1 (Dec 24, 2018)

  • Compatibility: Please note, that as of Studio 3T 2018.6.0, support for the deprecated MongoDB Challenge-Response (MONGODB-CR) authentication mechanism has been discontinued.
  • Improved: Aggregation Editor - Automatically running explain initially is deferred to when the Explain tab is switched to.
  • Fixed: Visual Explain - Improved handling of unexpected input.

New in Studio 3T for MongoDB 2018.6.0 (Dec 20, 2018)

  • Compatibility: Support for MongoDB server version 2.6 connections is now discontinued (https://www.mongodb.com/blog/post/mongodb-2-6-end-of-life).
  • New: For new feature releases such as this, you can now opt in to the 7-day re-activated trial, where you can try the amazing Pro and Enterprise features of Studio 3T!
  • New: Visual Explain - Clear diagrams demonstrate how MongoDB executed your query at a glance, with the option to view runtime statistics like stage output counts and execution times.
  • New: MongoDB 4.0 SCRAM-SHA-256 authentication supported.
  • New: IntelliShell - Code formatting is now available!
  • New: IntelliShell - X.509 authentication with encrypted user certificate now supported.
  • New: Copy collection name from the open connections tree.
  • New: Copy field name from results.
  • Improved: Aggregation Editor - Clearly shows errors in queries that are pasted in.
  • Improved: Aggregation Editor - Additional 'Close tab' options introduced.
  • Improved: Connection Manager - Improved usability on lower resolution screens.
  • Improved: JSON View - Documents are visually separated with a distinct separator line.
  • Fixed: Enterprise - Improved Windows Kerberos compatibility with MongoDB 4.0.3+.
  • Fixed: SQL Query - GROUP BY now succeeds when _id is composite and its subfields are used in aggregation.
  • Fixed: Visual Query Builder - Use explicit $and root group if root group contains more than one subgroup of the same type.
  • Fixed: Some dialogs for which 'Don't show again' was selected may have been shown again.
  • Fixed: Password-backed SSL certificates could fail to connect in some cases.

New in Studio 3T for MongoDB 2018.5.1 (Nov 20, 2018)

  • New: Visual Query Builder - New field rules can now be created by cloning existing ones using the "clone field rule" button.
  • Improved: Improved compatibility with MongoDB Atlas for reporting collection statistics.
  • Improved: Aggregation Editor results now offer full 'large table' facilities, e.g. showing and hiding embedded fields.
  • And other smaller fixes and improvements.

New in Studio 3T for MongoDB 2018.5.0 (Nov 7, 2018)

  • New: Enterprise Edition - License key and several application properties include disabling auto-update, branding, path to Oracle Database driver can now be configured with Windows Group Policies / Administrative Templates. These configuration files are included the Enterprise .MSI download bundle.
  • New: IntelliShell Visual Query Builder - the Visual Query Builder you know and love from Collection View now comes to IntelliShell!
  • New: Type Coloring - values in tree and table views are colored according to their type. Colors and types are configurable in Preferences.
  • New: Read-only Connections - Configure whether individual connections are read-only in Studio 3T by default.
  • New: Instantly view the equivalent PHP code for your queries with the new PHP support in Query Code.
  • New: (Un)commenting shortcuts in Aggregation Editor and SQL Query tabs.
  • Improved: IntelliShell - Faster start-up times.
  • Improved: Aggregation Editor - Added keyboard shortcuts to create new stage, above and below current stage.
  • Improved: Introduced option to show a simplified progress report during export, which will be faster when exporting very large amounts of data.
  • Improved: Import Connections dialog - can now optionally import from clipboard.
  • Improved appearance of toolbar separators on Ubuntu.
  • Improved: Simplified open connections view - attempting to open an already open connection simply selects it in the open connections view, rather than showing it twice.
  • Fixed: Some dialogs may be shown at an extremely small size under some configurations.
  • And several other smaller fixes and improvements.

New in Studio 3T for MongoDB 2018.4.6 (Oct 9, 2018)

  • New: Updated bundled MongoDB tools to version 4.0.2.
  • Fixed: Improved legibility of selected auto-completion proposal on Windows.
  • Fixed: Editor rendering issue on Linux.

New in Studio 3T for MongoDB 2018.4.5 (Sep 29, 2018)

  • Fixed: On macOS Mojave, Connection Manager could fail to render properly.
  • Fixed: Under some configurations, the application would fail to exit upon quit.

New in Studio 3T for MongoDB 2018.4.4 (Sep 21, 2018)

  • New:
  • Added JSON format chooser to stand-alone JSON document viewer dialog.
  • Fixed F3 key short-cut wasn't activated in JSON view.
  • Fixed: Crash fix for menu when no ConnectionTree node is selected.

New in Studio 3T for MongoDB 2018.4.3 (Sep 12, 2018)

  • New: HTTP and SOCKS proxy server support.
  • New: Monitor slow queries of varying duration in the Current Operations tab.
  • Improved: Current Operations - Can now select to show only a user's own operations.
  • Improved: IntelliShell - Improved auto-completion of 'rs' and 'sh' objects.
  • Improved: IntelliShell - Auto-suggesting hints as you type is now configurable in Preferences (auto-completion may always be explicitly invoked with Ctrl+Space).
  • Improved: IntelliShell tabs closed when connection they were opened on is disconnected.
  • Improved: Columns in Connection Manager and SQL Connection Manager are sortable.
  • Improved: Visual Query Builder - Set focus on value after dragging in fields.
  • Fixed: Added Server Status Charts support for multiple shard servers.
  • Fixed: Connection Manager - Fixed case where replica set discovery would not succeed.
  • Fixed: Visual Query Builder - Improved field name character escaping.
  • Fixed: Schema Explorer - Export to MS Word includes updated Studio 3T logo.
  • Fixed: Query Code - Removed redundant $project stage from mongo shell equivalents of certain SQL queries.
  • Fixed: Match Excel's handling of backslash characters when importing CSV.
  • Fixed: All collation options included in the Add New Collection dialog.
  • Fixed: GridFS - Successfully cancel adding a file via drag and drop.
  • Fixed: Auto-import of external connections correctly handles UTF-8.

New in Studio 3T for MongoDB 2018.4.2 (Aug 7, 2018)

  • Improved: Auto-completion performance improved on remote connections.

New in Studio 3T for MongoDB 2018.3.2 (Jun 22, 2018)

  • New: Non-commercial licenses can now be obtained at https://studio3t.com/discount/non-commercial/
  • New: 'Fuzzy' comparison option in Data Compare and Sync for floating point values.
  • New: Improved Query Builder
  • Improved: Enterprise Edition - Multiple Kerberos realms support.
  • Improved: Handling of special regular expression characters in find and replace.
  • Improved: DNS resolution in particular complex setups.
  • Fixed: SQL joins with group by and having or order by clauses that referenced dotted names could erroneously report an empty result set.
  • Fixed: IntelliShell - Field name suggestions are included in first auto-completion invocation.
  • Fixed: Improved legibility of find options in dark mode.

New in Studio 3T for MongoDB 2018.3.1 (May 29, 2018)

  • Improved: Handling of escaped collection/view names in IntelliShell auto-completion.
  • Improved: Auto-generated shell code favours the getCollection method.
  • Fixed: Attempting to export aggregation results results in 'Cursor has been closed' error in some circumstances.
  • Fixed: Field name suggestions in IntelliShell's auto-completion would fail to show in some circumstances.
  • Fixed: Certain Aggregation Query steps would produce a crash.

New in Studio 3T for MongoDB 2018.3 (May 21, 2018)

  • New: SQL Joins - Support for inner and left joins via the aggregation $lookup operator in SQL Query.
  • New: IntelliShell - Support for ES6.
  • New: Save/load export job settings.
  • New: MongoDB tools bundled on Linux (Ubuntu).
  • New: Enterprise Edition - MSI installer with auto-update disabled.
  • New: SQL Query - 'Execute Selection' query execution mode.
  • New: Schema Explorer includes 'Top UUIDs' values chart.
  • New: Table View - Option to expand all embedded fields, i.e. show a 'flattened' view, by default.
  • New: Export SQL queries that translate to MongoDB aggregation queries.
  • New: Crash reporter.
  • Improved: Studio 3T query performance improved over many different workloads.
  • Improved: Faster CSV import.
  • Improved: Display of long strings in 'Top Strings' values chart in Schema Explorer.
  • Improved: Auto-convert OS reserved file name characters in export.
  • Fixed: Large collections can be successfully copied into themselves.
  • Fixed: Query Builder inputs may be clipped when using high scaling on Ubuntu.
  • Fixed: Restored handling of explain option in aggregation queries in IntelliShell.
  • Fixed: Query Builder menu item correctly enabled.
  • Fixed: Improved handling of restoring DCS configuration after collection names have changed.
  • Fixed: Internal document parser accepts empty strings as keys.
  • Fixed: Import from MS SQL Server auto-suggests long for INT64 data type.
  • And many other smaller fixes and improvements.

New in Studio 3T for MongoDB 2018.2.5 (Apr 11, 2018)

  • New: Initial trial of Studio 3T is now 30 days!
  • Improved: Upgraded the bundled mongo tools on Mac to improve compatibility with newer TLS standards (now required by IBM Compose)
  • Improved: Changed labels on $or and $and buttons to be more meaningful
  • Fixed: False negative status when running Test Connection on some MongoDB Atlas instances.

New in Studio 3T for MongoDB 2018.2.4 (Mar 10, 2018)

  • Fixed: Issues relating to uninstall failing on Windows.
  • Fixed: Reintroduce progress indicator for long running Aggregation Editor queries.
  • Fixed: Clipped port number box in Connection Manager for some Mac configurations.

New in Studio 3T for MongoDB 2018.2.3 (Mar 6, 2018)

  • New: SQL Query - support for aggregate functions in ORDER BY and HAVING clauses.
  • Improved: IntelliShell - further improved support for very large aggregation queries.
  • Improved: Data Compare and Sync - improved handling of connections that are now invalid or missing.

New in Studio 3T for MongoDB 2018.2.2 (Mar 3, 2018)

  • Improved: Test connection result reporting for Atlas connections.
  • Fixed: Deserialization of "Allow disk use" option in aggregation queries.
  • Fixed: Correct 'Count Documents' results for aggregation queries with "$limit" and/or "$skip" stages.
  • Fixed: ObjectId validation can be subverted in Query Builder.

New in Studio 3T for MongoDB 2018.2.1 (Feb 22, 2018)

  • Improved: Download failures for auto-update are more clearly reported
  • Fixed: Bundled tools use v3.6.2 for all Windows configurations
  • Fixed: Linux desktop shortcut was not created under some configurations
  • Fixed: Aggregation Query Code failed to update for some particular operators
  • Fixed: SQL Query - Count of initial empty result succeeds

New in Studio 3T for MongoDB 2018.2.0 (Feb 16, 2018)

  • New: Query Code comes to Aggregation Builder!
  • New: Data Compare and Sync - you can now export to CSV the differences discovered in an analysis.
  • Improved: SQL Query - Query Code now covers SQL queries that translate to a MongoDB aggregation query.
  • Improved: IntelliShell - improved support for very large aggregation queries.
  • Improved: Data Compare and Sync - improved support for differences scrolling sync when scrolling via mouse wheel on Mac.
  • Fixed: CSV import did not correctly import arrays.
  • Fixed: IntelliShell may hold file locks under certain Windows configurations.
  • Fixed: Windows desktop shortcut was not created under some configurations.

New in Studio 3T for MongoDB 2018.1.0 (Feb 8, 2018)

  • Extended SQL Query Support, Retained Expired Ops, and More:
  • 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 query criteria, advanced expressions, and the newly added functions.
  • 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 2018.1.0, 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
  • Full Changelog:
  • New: The SQL Query tab now supports GROUP BY and COUNT, MAX, MIN, SUM, and AVG aggregate functions.
  • New: CSV import now supports various date formats, selectable on a per column basis.
  • New: Retain Expired Ops in Current Operations now allows to select the interval over which expired ops are retained.
  • Improved: Stored Functions tab - mark tab as unsaved if another tab overwrites the function.
  • Improved: Tabs in New / Edit Connection dialog (Server, Authentication, etc.) now become scrollable when viewed on small screens, allowing all thew content to be viewed.
  • Improved: Aggregation tab now includes 'Count Documents' function.
  • Fixed: SSH tunnel converts § in password to different character.
  • Fixed: Redraw issue in Data Compare and Sync tab when expanding/collapsing all.
  • Fixed: Table correctly reset to root view when new projection is used.

New in Studio 3T for MongoDB 5.7.4 (Jan 18, 2018)

  • Fixed: databases and collections visible again when connected to Atlas
  • Fixed: Connect to SQL database server button (on import)
  • Fixed: Use read preference "Primary" for system.profile
  • Fixed: Short-cut Ctrl/Cmd + E in GridFS tab wasn't working

New in Studio 3T for MongoDB 5.7.3 (Jan 11, 2018)

  • Improved: Copy multiple collections and paste (i.e. merge) them into a single target collection
  • Improved: Multiline in-place editor - added Find & Replace options
  • Improved: Editor - "replace all" honors case sensitivity
  • Improved: Prompt to save changes upon hitting quit short-cut
  • Fixed: Connection with hundreds of databases (and each hundreds of collections) could stall UI
  • Fixed: Close/Save confirm dialog were hidden behind pulled out tabs
  • Fixed: On Linux - exit short cut is now Ctrl+Q again
  • Fixed: Unicode chars were not stored properly in query history
  • Fixed: Databases and collection names weren't visible when directly connecting to a secondary
  • Fixed: From URI - proper handling of '+' characters in passwords

New in Studio 3T for MongoDB 5.7.2 (Dec 21, 2017)

  • New: Updated to latest 3.6 MongoDB driver => fixes issue with $out aggregation stages
  • Improved: Copy Field menu option copies full path name of field now
  • Improved: Installer dialog windows are now resizable
  • Fixed: JSON editor - Find & Replace UI

New in Studio 3T for MongoDB 5.7.1 (Dec 6, 2017)

  • Fixed: Check for previous versions during installations on Windows could end up taking a long time to finish
  • Fixed: S3T accidentally was always-on-top on Windows

New in Studio 3T for MongoDB 5.7.0 (Dec 6, 2017)

  • New: Added support for "$listSessions" aggregation stage operator (MongoDB 3.6)
  • New: Added support for custom Server Name Indication (SNI) when using SSL connections.
  • New: Data Compare & Sync - specify source and target projections
  • New: Data Compare & Sync - option to show only differing fields
  • Improved: Expand / Collapse all menu items in Data Compare & Sync differences tab
  • Improved: Allow choosing and opening multiple scripts
  • Improved: Double click didn't expand tree items on import from another collection tree view
  • Improved: Add maximize button to View JSON dialog
  • Improved: conventional keyboard short-cuts to flick through tabs
  • Improved: "Close tab" short-cut applies to (sub) tab folder that has focus
  • Improved: Use more conventional exit short-cut Alt+X on Windows and Linux (rather than Ctrl+Q)
  • Improved: Handle display of invalid UUIDs (BinData(4, "...") and BinData(3, "...") ) more gracefully
  • Improved: Expand/collapse Operations pane by double-clicking header
  • Fixed: Issue with View menu/Shortcuts being disabled for comparison results tabs
  • Fixed: Right-click on GridFS collection showed to menu items with "enter" shortcut
  • Fixed: Wrong timestamps of MS Word files generated for schema documentation
  • Fixed: Short-cuts weren't refreshed after tab was pulled out
  • Fixed: Data compare & sync - when synchronizing entire document, UI status could get stuck
  • Fixed: Flickering progress report of mongodump exports of large collections
  • Fixed: CSV export of static array results in IntelliShell
  • Fixed: "Follow Reference" option in IntelliShell results
  • Fixed: Data Compare & Sync - "Compare" tab in configuration dialog - option selection was faulty
  • Fixed: Query builder - elemMatch with "equals", "contains", "starts with", and "ends with" operators
  • Fixed: DB-level collection stats: suppress redundant and empty _id column
  • Fixed: Expired operations weren't grayed out in Current Ops View

New in Studio 3T for MongoDB 5.6.4 (Nov 18, 2017)

  • Improved: Performance when opening collections (especially with large documents)
  • Improved: More robust launch script for Linux
  • Fixed: Better error handling of broken connection setting files

New in Studio 3T for MongoDB 5.6.3 (Nov 3, 2017)

  • Fixed: Data Compare & Sync - when synchronizing entire document, UI status got stuck
  • Fixed: SQL export - when exporting selected documents only, export was stuck in "pending"

New in Studio 3T for MongoDB 5.6.2 (Oct 25, 2017)

  • Fixed: Wrong column order in table view component when expanding embedded fields after stepping into array column.
  • Fixed: Table view component: accept default values in in-place editor of empty cells

New in Studio 3T for MongoDB 5.6.1 (Oct 20, 2017)

  • Fixed: Potential application exit when opening "Collection Statistics" on a database
  • Fixed: Issue with opening IntelliShell on some Windows configurations

New in Studio 3T for MongoDB 5.6.0 (Oct 19, 2017)

  • New: All new table view component
  • New: Connections tree is now collapsible
  • New: Ctrl+DEL shortcut for "clear collection"
  • New: CSV import - header names are now editable in place
  • New: Global short-cut to close tabs without save prompts
  • Improved: Improved syntax colouring across all languages
  • Improved: IntelliShell - GUI-centric display of find and aggregate accessed via getSiblingDB
  • Improved: IntelliShell - Extra large arrays are more conveniently handled
  • Improved: IntelliShell - Querying made more robust against formatting demands of the MongoDB shell
  • Improved: CSV import - Changed "Start import from line" with a default of 1 to much clearer "Skip first <n> lines" with default of 0
  • Improved: Stored functions tab refreshable via Ctrl/Cmd+R short-cut
  • Improved: Excluded aggregation stages in the list are marked gray
  • Improved: Bundled MongoDB tools updated to latest 3.4.9
  • Improved: Collection tab: "Run count(...)" now clears status bar before showing result pop-up
  • Improved: JSON editor - show number of matches in search bar
  • Improved: Better warning message when trying to refresh the tab of a JS function that was deleted in the background
  • Fixed: CSV import - after the import is complete, the file could remain “locked”
  • Fixed: On aggregation tab toolbar buttons are being disabled as appropriate
  • Fixed: Editor tabs for deleted stored functions are being closed
  • Fixed: JSON parser - recognizes capitalized E notation
  • Fixed: SQL tab - error message upon hitting Cmd+R to refresh before the first query was executed
  • Fixed: Aggregation tab - open script short-cut immediately available upon opening tab

New in Studio 3T for MongoDB 5.5.1 (Sep 29, 2017)

  • Fixed: macOS High Sierra: disabled menu items when system language is set to something other than English
  • Fixed: Confusing, duplicate icon usage in view tab

New in Studio 3T for MongoDB 5.5.0 (Sep 21, 2017)

  • New: Query Code - see the corresponding driver code for your query, instantly generated automatically in Java, C#, Python, JavaScript / Node or JavaScript / MongoDB shell!
  • Improved: The target database can now be explicitly specified in SQL export jobs.
  • Improved: Multiline comment syntax colouring accuracy.
  • Improved: stats tooltips in connections tree show when they were last refreshed
  • Fixed: SQL import only selected columns.
  • Fixed: Show copied collection names in tree right after copy&paste is complete.
  • Fixed: Potential application exit for some aggregation configurations
  • Fixed: Changing the color of a connection in the connection manager didn't overwrite individually set colors of child nodes
  • Fixed: Changing the color of a connection in the connection manager didn't refresh it in the open connections tree
  • Fixed: "Close tabs to the right" will also close hidden tabs to the right
  • Fixed: Code editor pop-up menu had inconsistent copy-to-clipboard icon
  • Fixed: In Collection View, "Count documents" button didn't correlate with visible results if search criteria were edited but not yet executed
  • Fixed: potentially unintentionally setting the color of a tree node on macOS because of auto-selected color in color picker dialog

New in Studio 3T for MongoDB 5.3.0 (May 30, 2017)

  • New: Query MongoDB using SQL! Check out the new SQL tab!
  • New: Import data direct from live SQL databases into MongoDB. Check out the new SQL Import option!
  • Added: Option to retain expired operations in the task monitor
  • Added: Option to hide particular graph lines in Server Status Charts
  • Added: "Add & Continue" button on add document dialog
  • Added: Option to include "replicaSet" option when exporting connection setting URI
  • Improved: Import multiple files into the same collection in one go
  • Improved: More flexible triggering of auto-completion in IntelliShell.
  • Improved: documents tree view: handling of large documents
  • Improved: More robust & consistent SSL certificate parsing & handling
  • Improved: More descriptive connection error messages
  • Improved: Better UI for SSL certificates in the "Edit Connection" tab.
  • Improved: Intellishell support for .hint("index_name")
  • Improved: GridFS view now also shows custom fields (besides meta fields)
  • Fixed: Do not choke on aggregation queries with large resulting data set
  • Fixed: Undo/redo support in search boxes of the collection view
  • Fixed: Failure to view collection statistics in a database that contains views
  • Fixed: Boolean values now default back to previous value on 'wrong' input
  • Fixed: Intellishell's handling of DB names with special characters
  • Fixed: When editing a read-only view, escape view name to fix issue with names that are not valid JS identifiers
  • Fixed: Correct tabs coloring
  • Fixed: IntelliShell's update of tool items toggle status when invoked via keyboard shortcuts

New in Studio 3T for MongoDB 5.2.2 (Apr 21, 2017)

  • Fixed: Exporting of views doesn't set unsupported noCursorTimeout anymore
  • Fixed: IntelliShell launch issues on some Windows configurations.

New in Studio 3T for MongoDB 3.6.0 (Jun 2, 2016)

  • Added: HiDPI support
  • Added: New 3T Software Labs Limited EULA
  • Improved: Export wizard replaces complex former export dialog
  • Improved: Import wizard replaces complex former import dialog
  • Improved: better handling of time-out cursors in result views
  • Fixed: Use correct skip and limit when exporting live query result set from IntelliShell

New in Studio 3T for MongoDB 3.5.3 (May 24, 2016)

  • Improved: Kill running operation
  • Fixed: Read preference wasn't properly shown in connection settings dialog

New in Studio 3T for MongoDB 3.5.2 (May 19, 2016)

  • Added: all tabs now also show the current user
  • Improved: much better query history
  • Improved: Use human readable byte count in DB and collection stats
  • Fixed: Error when creating text index
  • Fixed: JS function editor now correctly shows Code objects
  • Fixed: Ensure remembered window positions are always on screen
  • Fixed: Ensure remembered window size is at least 100x100 pixels
  • Fixed: Export of aggregation query results

New in Studio 3T for MongoDB 3.5.1 (Apr 26, 2016)

  • Added: Support for client-side SSL certificates.
  • Fixed: Mac bundled shell would fail to start under some configurations.
  • Fixed: Progress tracker of imports could get stuck in "pending"
  • Fixed: Redundant double use statements failed to parse on Windows.
  • Fixed: new Date() in collection view returns current date
  • Fixed: SSL CA Root Certificate file path was not loaded on application start.

New in Studio 3T for MongoDB 3.5.0 (Mar 26, 2016)

  • Added: bulk write operations on multiple threads
  • Added: The mongo shell executable in now bundled with MongoChef for Windows x64 and Mac.
  • Added: Count documents button in the bottom status bar
  • Added: Discard ongoing aggregation queries
  • Added: Discard ongoing IntelliShell operations
  • Improved: removed hard page size limit of 1,000
  • Improved: multi write option in edit value dialog
  • Improved: Use no-timeout cursors when exporting to CSV and json files
  • Improved: Connections through SSH tunnels now reconnect when dropped
  • Improved: Root CA certificate can be provided for SSL connections
  • Improved: Double-click sensitivity in query builder
  • Fixed: clear collection tooltip stats after it is cleared
  • Fixed: Bottom status bar cancel button
  • Fixed: json parser now enforces quotes around dot-noted field names

New in Studio 3T for MongoDB 3.4.1 (Feb 24, 2016)

  • Added: Connection settings can now be exported and imported
  • Added: "skip to last page" button
  • Fixed: Properly escape search string for "contains", "starts with", "ends with" query builder operators.
  • Fixed: IntelliShell: Under some configurations, shell helper methods may have resulted in an execution error.

New in Studio 3T for MongoDB 3.4.0 (Feb 13, 2016)

  • Added: Tabs can now be viewed side-by-side, split horizontally and vertically
  • Added: Drag and drop tabs to reorder
  • Added: Connections, databases, and collections can now be colored individually
  • Added: Show db and collection stats as tooltip.
  • Added: Editor font is configurable.
  • Added: IntelliShell - For greater convenience, a find command is inserted by default when opened on a collection.
  • Added: UUID helper functions, both in IntelliShell and collection view.
  • Added: Ignore trailing/leading spaces during CSV import.
  • Improved: Proper paging in tree and table result views
  • Improved: Greater tolerance in IntelliShell parser, e.g. dangling elses, no semicolons.
  • Improved: Auto-select new target collection option when pasting collection into its own database
  • Improved: Aggregate queries performed in IntelliShell will display result sets of any size.
  • Improved: IntelliShell displays a status indicator when an operation is currently running.
  • Improved: Scientific notation is no longer used for doubles in shell export and JSON editor
  • Improved: Toggle state of query builder is no longer persisted
  • Fixed: Layout issue in copy collection dialog
  • Fixed: "Drop duplicates" index option disabled for MongoDB >= 3.0
  • Fixed: Stored Functions editor now writes value field of functions in system.js as Code fields (not strings)

New in Studio 3T for MongoDB 3.3.0 (Feb 13, 2016)

  • Added: copy indices when copying collections
  • Added: MongoChef remembers its last position and size
  • Improved: JSON editor window remembers its last position and size (for the duration of a MongoChef session)
  • Improved: Replica set discovery with support for passive secondaries
  • Improved: Results for queries such as 'db.getCollection("myCollection").find()' are now shown the same way as for queries such as 'db.myCollection.find()' or 'db["myCollection"].find()'.
  • Improved: Use no-timeout cursors for import/export operations

New in Studio 3T for MongoDB 3.2.4 (Feb 13, 2016)

  • Added: "Rename" option to popup menu on stored JS functions tab
  • Added: Copy full query command to clipboard from within collection view tab
  • Added: Tooltip with ObjectID details
  • Improved: Copy Value As Text, Copy Value, and Copy Field options
  • Improved: Exporting only selected documents from aggregation will not reset cursor any more
  • Improved: Minor JavaScript parser improvements
  • Improved: More specific info messages when script, selection or cursor position has no executable statements
  • Fixed: Pressing and holding execution shortcut key could cause app to exit unexpectedly under some circumstances
  • Fixed: Opening an IntelliShell tab on a connection directly will only default to db "test" if test actually exists
  • Fixed: Export of live documents from IntelliShell always honors query criteria
  • Fixed: Application could exit unexpectedly on right-click in empty roles tab
  • - Fixed: Reading in of old connection settings

New in Studio 3T for MongoDB 3.2.3 (Feb 13, 2016)

  • Added: Support for X.509 authentication mode.
  • Fixed: For very large collections, export set check could erroneously report that there are no documents to export.
  • Fixed: Document count was wrongly reported for very large collections.
  • Improved: Update notifications will not be logged anymore.

New in Studio 3T for MongoDB 3.2.1 (Feb 13, 2016)

  • Fixed: disable validation support for admin, local, config databases and system.* collections
  • Fixed: ignore max and size for non-capped collections

New in Studio 3T for MongoDB 3.2.0 (Feb 13, 2016)

  • Added: MongoDB 3.2 compatibility
  • Added: export from aggregation and IntelliShell output.
  • Added: IntelliShell: Source code of corresponding query shown in result tab tool tip.
  • Added: Dedicated management tab for stored JS functions.
  • Improved: Better error messages when opening or pasting in a query within the Aggregation Screen.
  • Improved: Export documents dialog now allows skip and limit.
  • Improved: Simplified toolbar and execution shortcuts in IntelliShell.
  • Improved: IntelliShell authentication will now accept special characters.

New in Studio 3T for MongoDB 3.1.0 (Feb 13, 2016)

  • Added: CSV import
  • Added: Line numbers in JSON editors
  • Added: Bracket matching in JSON editors
  • Improved: All revamped task monitor
  • Improved: Show "Export Collections" dialog immediately. Do not wait until collection names have been read.
  • Improved: Pre-select field name of new field in Ctrl+K dialog on Linux too.
  • Fixed: Truncate issue when copying collections
  • Fixed: Fixed button order on Windows in "Document JSON Editor" dialog

New in Studio 3T for MongoDB 3.0.7 (Feb 13, 2016)

  • Added: Copy/paste aggregation query
  • Improved: comma error detection in JSON parser.
  • Improved: Improved handling of large queries in IntelliShell.
  • Fixed: Aggregation screen: "Add New Stage" in drop-down menu would not work on empty aggregation pipeline.

New in Studio 3T for MongoDB 3.0.6 (Feb 13, 2016)

  • Added: Show execution time of queries
  • Fixed: Vertical table scroll bars were not showing on Linux.
  • Fixed: UUID("39691D9E-BD5B-45A0-92FA-3BEDD1C9656D") now returns a BinData-4-UUID.
  • Fixed: Import of JSON doc without _id field would result in "_id": null