Import a license
Before you’re able to create a new connection, you’ll have to install your new license key.
Watch the above video or simply follow these steps to import a license:
- Open Studio 3T and select “Help” in the toolbar.
- Go to the “License Manager” and click “Import New License”.
- Paste your license key (the entire text between both “—” lines including the “—” lines themselves) into the dialog box and hit “OK”.
- Click “OK” once more after you’ve reviewed your customer information.
Now your license is installed and you’re ready to make your first MongoDB connection.
Connect to MongoDB
Have your connection details ready
Whether you’re MongoDB is hosted on-premise or through a cloud hosting service, the quickest way to connect to your database is to have a connection string ready.
The standard connection string or URI format
The good news is, cloud hosting services like MongoDB Atlas, Compose, mLab and ObjectRocket readily provide this connection string, so all you need to do is make a few modifications (e.g. insert SSH and/or SSL details), and paste it into Studio 3T.
Alternatively, you can also save the connection string as a URI file.
Create a new connection
Enter your connection string or upload your URI file in the Connection Manager following these steps.
Take a tour
The global toolbar is available throughout your Studio 3T journey, providing you one-click access to the following features:
- Connection Manager (Connect)
- Collections Tab (Collection)
- SQL Query (SQL)
- Aggregation Editor (Aggregate)
- User Manager (Users)
- Role Manager (Roles)
- Schema Explorer (Schema)
- Data Compare and Sync (Compare)
On the left-hand side, you’ll always find the Connection Tree, which displays all your active MongoDB connections and their respective databases and collections.
Double-click on any collection in the Connection Tree to open a collection tab.
The Collections Tab is the starting point for using Studio 3T. Here you can view, edit, and query your collection, and access other features.
We highly encourage you to get familiar with the Collections Tab and read the full documentation here.
Build your query
With Studio 3T, anyone can build a MongoDB query.
It doesn’t matter if you don’t know the MongoDB query language, use SQL, or write JSON documents like a pro – there’s a feature that’s right for you.
If you have no knowledge of the MongoDB query language, you can still get some serious querying done with the Visual Query Builder.
Simply drag and drop the fields you want to query into the builder, define your operators, and let the feature do the work – no MongoDB query syntax required.
Read about Visual Query Builder in full here.
Those familiar with the mongo shell will feel right at home with IntelliShell, which boasts an extra perk: rich, smart autocompletion which was even made more robust with Version 2018.4.
View the full documentation on IntelliShell here.
If you’re a SQL veteran new to MongoDB, you can be just as productive with your SQL querying skills.
Through SQL Query, you can write SQL statements and joins to query MongoDB.
You also get to see how your SQL queries translate to the MongoDB query language, which is a great learning tool.
Read about SQL Query in full here.
For a better way of building aggregation queries (which even the MongoDB pros will appreciate), there’s the Aggregation Editor.
It lets you define aggregation pipeline operators and check inputs and outputs one stage at a time, so that you know your pipeline is accurate each step of the way.
View the full documentation on Aggregation Editor here.
View your results
You’ve built your query – now it’s time to check the results.
Studio 3T lets you view your data in three ways.
View your data in the familiar spreadsheet format and enjoy features unique to Studio 3T like showing embedded fields, stepping into array-valued columns, showing/hiding columns, and more.
Read about Table View in full here.
Tree View shows your data in hierarchies that you can expand or collapse as needed.
View the full documentation on Tree View here.
Go old school and view your collection as JSON documents, complemented by a built-in JSON editor that validates your syntax as you go.
View the full documentation on JSON View here.
Explore your collections
Use Studio 3T’s many advanced features to dive deeper into your data.
Discover schema outliers
Visualize your schema
Compare and sync collections
Use Data Compare and Sync to compare any two MongoDB collections across different databases and servers and sync differences as needed.