MongoDB Schema Discovery and Exploration

One of the great things that we love about MongoDB is of course that it's schema-less, which makes adapting your application to changing requirements a breeze. That said, your data will often have a fixed implicit schema, e.g. each document in your employees collection will likely always have a first and last name field. So, making sure [...]

How to Grant MongoDB Roles to Multiple Users

In MongoDB, users are defined for specific databases. Each user is then assigned a list of roles that in turn define the user’s privileges. Not surprisingly, MongoDB’s API therefore makes it easy to assign a user a list of roles via the grantRolesToUser method: db.grantRolesToUser( "<username>", [ <roles> ], { <writeConcern> } ) However, MongoDB’s [...]

How to Tell Your MongoDB Production and Test Databases Apart

Studio 3T has many advanced features, but it's the little things that also make it the best MongoDB GUI for Windows, Mac, and Linux. One of our users' favorite features is the ability to color-code collections and databases. It makes differentiating production data from test data easier and prevents accidents from mixing up the two. For example, you can [...]

How to Compare MongoDB Collections, Analyze Differences, and Sync Data

In this post, we'll show you how to compare MongoDB collections located in different databases and/or servers, analyze differences between their documents and fields, and sync your data using Studio 3T's Data Compare & Sync feature. The Importance of Comparing MongoDB Databases Choose Your Source and Target Connections Choose MongoDB Collections to Compare Configure Your [...]

How to Limit the Initial Number of Documents Loaded in a MongoDB Collection

By default, Studio 3T loads the first 50 documents of a collection (i.e. dbCursor.find({}).limit(50)) when first opening a collection view. As MongoDB documents can be up to 16MB in size, this can amount to serious traffic, so we've introduced a convenient way of limiting this initial number of documents either for all or specific collections. Limit [...]

Updating and Querying MongoDB Arrays

Introduction The $type Query Operator and Arrays $type Array Inconsistencies Detecting MongoDB Array Fields Common Operations Impacted by Arrays Conclusion Update: If you work with MongoDB data with lots of arrays and embedded fields, make sure to check out our improved Table View. It lets you step into array-valued columns, show nested fields next to parent [...]

How to List MongoDB Users by Role

In this tutorial, we will see how to easily find and list all users that have been granted a specific role in MongoDB using our GUI, Studio 3T. In MongoDB, users are defined for specific databases. Each user is then assigned a number of roles that in turn define the user’s privileges. While MongoDB’s API [...]

How to Export MongoDB to SQL

One of the most popular Studio 3T features is Export to SQL, available in our Pro and Enterprise editions. Try it out along with our other Pro features, free for 14 days. Download Studio 3T Get Download Link for Later Once you've downloaded Studio 3T, let's take a look at how easy it [...]