Studio 3T Quick Tips

This collection of short videos is geared towards discovering ‘lesser-known’ Studio 3T features. Here you’ll find quick tips related to DevOps tasks such as managing MongoDB users and roles, but you’ll also learn handy tips such as color-coding tabs, keyboard shortcuts, and more.

The Studio 3T Quick Tips series will be periodically updated, so continue to check back for more videos!

Quick Tips

#1 Managing Users And Roles

Studio 3T makes managing your MongoDB users and their roles a breeze.

Open Studio 3T and connect to a server.
Right-click a database and go to ‘Manage Users’.

TIP: You can also use the ‘Users’ button in the Global Toolbar to access user information.

Click ‘Add’ and give your new user a name and password.
Click ‘Add User’ and your new user is set up and ready to go.

Additionally, you can edit an existing user or delete the user entirely.

Access ‘Roles’ by right clicking on a database in the Connection Pane, and choosing ‘Manage Roles’.

You can also use the ‘Roles’ button in the Global Toolbar to access user roles.

Click ‘Add’ and give the role a title.
Click ‘Add’ again to decide where the role will be applied and the privileges that go along with it.
After clicking ‘Create Rule’ the new Role is now added to the chosen database.

#2 Three Ways to View MongoDB Data

Once you’ve opened Studio 3T and connected to a MongoDB collection you have three ways to view your data.

JSON View – view your data as a JSON file
Table View – the classic “spreadsheet” format
Tree View – glimpse all data hierarchies at once.

#3 Saving SQL Queries, Scripts and JavaScript

Save your MongoDB queries in Studio 3T.

To save a query in the Aggregation Editor, IntelliShell, or SQL:

Create the query in Studio 3T
Click the ‘save’ icon (floppy disk)
Give it a name and choose where to save it
Click ‘OK’

#4 Drop an Unused Database or Collection

Need to drop a database?

Dropping a database can be done in two different ways:

Select the database in the Connection Pane
Go to the ‘Database’ tabat the top of the Global Toolbar
Click “Drop Database”

Alternatively…

Right click the database in the Connection Pane
And choose “Drop Database”

#5 Customize Studio 3T

Easily customize the look of your Studio 3T experience to how you like working best.

You’ll find those options and much more by going to

‘Edit’
then clicking ‘Preferences’.

Here you’re able to change default settings, specify the font size, toggle on/off auto-completion, and much more!

#6 Save and Load MongoDB Queries

Saving and loading your MongoDB queries is made easy with Studio 3T.

Saving

Go to IntelliShell, SQL, or the Aggregation Editor
Create a Query
Click the disk icon and select where you want to save your query.
Give your file a name and click ‘Ok’.

Loading

Go to IntelliShell, SQL, or the Aggregation Editor
Select the ‘Open Folder” icon
Find your saved query and click ‘Ok’.
Now that your query’s been loaded, run the query and explore your data!

#7 Importing JSON Data into MongoDB

Bringing your JSON data into MongoDB is simple and quick with Studio 3T’s JSON Import.

#8 Multiple View Options In Studio 3T

Want to look at your test and production data-sets simultaneously? Discover the various ways to arrange your MongoDB data views to how you like working best.

You can click and drag the Collection Tab to open your data in a new window.
Alternatively, you can right-click the Collection Tab and choose to split them horizontally, vertically, or un-docked.

#9 View & Edit JSON Documents

Use JSON to look at individual documents.

You can open the Document JSON Viewer via:

the F3 shortcut
click the “View” document button
or right-click, ‘View Document, ‘Document’.

To quickly edit documents in JSON

use ‘CTRL+J’

#10 Intellishell Editor Options

See how Studio 3T offers options within the IntelliShell Editor to work in Raw Shell Mode and allows users to retain their results.

You can toggle on and off this feature, allowing you to view only your current results OR all previous results.

Open a collection in IntelliShell or the Aggregation Editor.
In the collection toolbar, click the ‘Retain previous results tabs’ button to toggle this on/off.
- Or use the shortcut – ALT+SHIFT+P

Toggling on the Raw Shell will display query results in typical mongo shell format. To turn this on or off:

Click on the shell icon in the toolbar

#11 Export Query Results

Exporting your MongoDB query results is made easy in Studio 3T. Go straight from a query or an aggregation to exporting!

Go more in-depth with our Import and Export Wizards!

#12 Export to Excel

How to export MongoDB data to Excel and Google Sheets by copying query results and then using it to create a CSV file.

#13 Creating MongoDB Views

A view lets you pre-specify a query so that you can quickly view and share it’s results. (Read more about SQL Views in MongoDB here)

To create a view:

Right click on the desired collection in the Connection Pane and select, “Add View Here”.
This will open the View Editor where you can modify your query as desired.
Once the query is set, click “Create View” and you’re new view is now in the Connection Pane

#14 Copy and Paste MongoDB Documents and Collections

Copying and pasting your MongoDB collections and documents is a quick way to manage and move your data around MongoDB with Studio 3T.

#15 Color Code MongoDB Collections

To begin color coding your MongoDB connections in Studio 3T, you can:

Right click the server, database, or collection in the Connection Pane.
Highlight ‘Choose Color’.
And click on the desired color.

Similarly, if you have a few collections open:

Right click the Collection’s Tab
Highlight ‘Choose Color’.
And pick the color from there.

#16 Viewing Embedded Fields & Arrays

Stop jumping in and out of cells to see nested fields.

Simply:

Right Click
Go to ‘Show All Embedded Fields’

#17 Validate JSON Documents

When accessing and editing JSON Documents, always make sure your JSON is valid before updating. Studio 3T helps safeguard this process.

In JSON View, you can edit your JSON Documents by:

Accessing the ‘Document JSON Editor’ from the Collection Toolbar or using the shortcut “CTRL + J”
Input your JSON and click ‘Validate’ to ensure all edits have been added correctly before clicking ‘Update’.