Query & CRUD Operations

Curious about how to query MongoDB? Here are four ways to do so.

Visual Query Builder lets users build queries visually by dragging and dropping fields, without the knowledge of JSON query syntax.

SQL Query makes it possible to write SQL expressions and joins to query MongoDB.

IntelliShell is the built-in mongo shell interface with smart auto-completion of collection names, shell methods, document key names, operators, and field names.

Query Code is the automatic code generation feature that converts MongoDB, aggregation, and SQL queries to JavaScript (Node.js), Java (2.x and 3.x driver API), Python, C#, Ruby, and the mongo shell language.

Take a look at how to build aggregation queries stage-by-stage with the Aggregation Editor, starting with this example that uses $match, $group and $sort.

Here's a list of frequently-used MongoDB commands, replaced by a few clicks through Studio 3T's context menus.

Discover the simplest way to explore nested fields and arrays with Table View.

Table View is the spreadsheet view that supports advanced features like showing embedded fields, stepping into array-valued columns, and hiding columns - even when dealing with massive datasets.

Tree View displays data in a hierarchical view, which can be expanded or collapsed as needed.

JSON View displays documents within a collection in JSON.

Learn how to copy and paste MongoDB documents across Studio 3T.

Copy a MongoDB collection to another database in a few clicks using Studio 3T's convenient built-in copy and paste features.

Studio 3T's handy guide to transferring MongoDB databases across connections.

A guide on how to perform CRUD operations on documents in MongoDB.

Learn how to change a field type in MongoDB in a single document or across all documents in your collection.

New to MongoDB? Check out our helpful beginner's guide for the basics of creating, modifying, deleting and analyzing MongoDB collections.

A simple workaround for renaming MongoDB databases when using Studio 3T.

Compare MongoDB collections, sync data, and export results with Data Compare & Sync.

Data Compare and Sync shows the differences between any two MongoDB collections side-by-side for an easier, more visual data comparison.

An introduction to the find() method along with query examples.

Learn how to filter elements from arrays in MongoDB by using the $elemMatch operator alongside find(), $match, and the $project and $filter functions.

In this tutorial, learn how to query MongoDB arrays and filter array string values using Studio 3T's drag-and-drop Visual Query Builder.

Learn how to handle cases where MongoDB arrays impact query and update operations.

We introduce the idea of MongoDB views - what they are, why they’re useful, when to use them, and how they relate to data aggregations - and walk you through how to create a view in Studio 3T using a small practice database courtesy of the UK’s Met Office.

Create a view in MongoDB using Studio 3T's View Editor

Learn how GridFS works and how to use it within Studio 3T.

Learn how to run a MongoDB map-reduce job using Studio 3T's Map-Reduce screen.

A short post on how to avoid a common gotcha when querying replica set secondary members (secondaries).

Discover how MongoDB handles UUID data & learn a few best practices when working with such data.

Studio 3T lets you bookmark frequently-used queries and keeps track of your query history wherever possible in the GUI.