Studio 3T and Azure Cosmos DB for MongoDB

When working with MongoDB, having a reliable GUI tool makes all the difference. Studio 3T has been my go-to tool for years, and it obviously works seamlessly with MongoDB. And most importantly, it works very well with Azure Cosmos DB for MongoDB.

There are several MongoDB GUI tools available, but Studio 3T stands out for a few reasons:

• Visual Query Builder: Build queries visually if you prefer not to write JSON
• IntelliShell: Auto-completion for MongoDB queries with syntax highlighting
• Aggregation Editor: Step-by-step pipeline builder with stage-by-stage output preview
• SQL Query: Write SQL and have it translated to MongoDB query language
• Import/Export: Easily move data between MongoDB, JSON, CSV, and SQL databases

Connecting to Azure Cosmos DB for MongoDB from Studio 3T is just as easy as any MongoDB. Just copy the Connection String and paste it in, and you are connected.

Note: Azure Cosmos DB for MongoDB requires SSL, which is already included in the connection string.

SQL to MongoDB

If you are coming from a SQL background, the SQL Query feature is a lifesaver. Write a query like:

SELECT * 
FROM employees 
WHERE department = 'IT'
ORDER BY name 
LIMIT 10

And Studio 3T translates it to:

db.employees
    .find({ department: "IT" })
    .sort({ name: 1 })
    .limit(10);

Do try it out.

   Studio 3T

Happy Coding.

Regards,

Jaliya