This collection of short videos is geared towards discovering ‘lesser-known’ Studio 3T features. Here you’ll find tips and tricks 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 Tips and Tricks series will be periodically updated, so continue to check back for more videos!
Here you can find the instructions on how to claim and/or assign seats, depending on your situation:
- I’ve purchased a Studio 3T license for personal use
- I’ve purchased a Studio 3T license for another user
- I’ve received a Studio 3T invite from another user
Managing your MongoDB users is a breeze in Studio 3T.
- Open Studio 3T and connect to a server.
- Right-click a database and go to ‘Manage Users’.
- 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.
Creating and managing roles in MongoDB is done in the ‘Roles’ area of Studio 3T.
- Access ‘Roles’ by right clicking on a database in the Connection Pane, and choosing ‘Manage 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.
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.
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’
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”
- Right click the database in the Connection Pane
- And choose “Drop Database”
Clean up your Connection Pane by dropping unnecessary collections.
You can drop collections by:
- Right clicking the collection in the Connection Pane
- Then selecting “Drop Collection”
- Highlight the collection you want to drop
- Select the “Collection” tab at the top of the Global Toolbar
- And click ‘Drop Collection’.
Want to change the font or choose which mongodb executables to use?
You’ll find those options and much more by going to
- then clicking ‘Preferences’.
Here you’re able to change default settings, specify the font size, toggle on/off auto-completion, and much more!
Save time when querying by loading your MongoDB queries.
- Go to IntelliShell, SQL, or the Aggregation Editor
- Select the ‘Open Folder” icon and click ‘Ok’.
Now that your query’s been loaded, run the query and explore your data!
Want to look at your test and production data-sets simultaneously?
- 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.
Free up just a little bit of screen space by collapsing your currently open connections.
After successfully connecting to a Mongo database, you will find that connection open in the Connection Pane.
- To collapse (or expand) the Connection Pane, click the green arrow.
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’
Retain your previous 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
While Studio 3T does offer the IntelliShell – a full-blown mongo shell with auto-completion, Visual Query Builder, and more – you can also work in ‘Raw Shell Mode’.
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
By using the Aggregation Editor and an $out Operator, you can export query results in Studio 3T.
All you need to do is:
- Create a query in Studio 3T via SQL, the Aggregation Editor, the IntelliShell, or Visual Query Builder
- Copy your query into the first stage of the Aggregation Editor.
- Add a second stage in the Aggregation Editor and give a name to the “output-collection”
- Refresh your database
- Right click your new collection and begin to export your query’s results (formats include: to another collection, a mongodump, or as SQL, CSV, and JSON files)
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
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.
Stop jumping in and out of cells to see nested fields.
- Right Click
- Go to ‘Show All Embedded Fields’
Ensure you’ve input JSON correctly with the ‘Validate JSON’ feature.
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’.
Prefer to edit an entire JSON document all at once?
When in Table or Tree View, right click a cell and go to ‘Document’ –> ‘Edit Document’. This will open the ‘Document JSON Editor’ and let you make changes to the entire JSON document.