{"id":9442,"date":"2025-02-11T08:14:35","date_gmt":"2025-02-11T16:14:35","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=9442"},"modified":"2025-02-11T08:14:35","modified_gmt":"2025-02-11T16:14:35","slug":"a-powerful-open-source-mongodb-gui-for-everyone","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/a-powerful-open-source-mongodb-gui-for-everyone\/","title":{"rendered":"A Powerful, Open-Source MongoDB GUI for Everyone"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>Azure Cosmos DB for MongoDB provides robust support through its Request Units (RU) model and vCore-based architecture, enabling flexible and scalable options for various workloads. <strong>We are now on a mission to deliver the ultimate developer experience.<\/strong> To achieve this, we have integrated Azure Cosmos DB for MongoDB support into the Azure Databases VS Code Extension.<\/p>\n<p>The free Azure Databases VS Code Extension, available on the <a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ms-azuretools.vscode-cosmosdb\" target=\"_blank\" rel=\"noopener\">VS Code Marketplace<\/a>, provides a reliable and intuitive MongoDB GUI for developers, database administrators, and teams working with MongoDB &#8211; on Azure and beyond.<\/p>\n<h4>MongoDB Support Comes to Azure Databases VS Code Extension<\/h4>\n<p><figure id=\"attachment_9531\" aria-labelledby=\"figcaption_attachment_9531\" class=\"wp-caption aligncenter\" ><img decoding=\"async\" class=\"wp-image-9531 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-mongodb-collection-overview.png\" alt=\"A screenshot of Azure Databases VS Code Extension showing a collection view\" width=\"2256\" height=\"1432\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-mongodb-collection-overview.png 2256w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-mongodb-collection-overview-300x190.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-mongodb-collection-overview-1024x650.png 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-mongodb-collection-overview-768x487.png 768w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-mongodb-collection-overview-1536x975.png 1536w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-mongodb-collection-overview-2048x1300.png 2048w\" sizes=\"(max-width: 2256px) 100vw, 2256px\" \/><figcaption id=\"figcaption_attachment_9531\" class=\"wp-caption-text\">Azure Databases VS Code Extension: The MongoDB Collection View<\/figcaption><\/figure><\/p>\n<p data-pm-slice=\"1 1 []\">We have worked hard to ensure that the <strong>Azure Databases VS Code Extension<\/strong> meets your needs. Our goal is to deliver a <strong>first-class MongoDB experience<\/strong> directly within VS Code. We focused on:<\/p>\n<ul data-spread=\"false\">\n<li><strong>Integration with Azure Cosmos DB for MongoDB<\/strong>: You can connect to and manage Azure Cosmos DB for MongoDB (RU and vCore) directly from VS Code. Perform operations like browsing, querying, and modifying data with ease.<\/li>\n<li><strong>Universal MongoDB Connectivity<\/strong>: You can connect to any MongoDB instance, whether it&#8217;s hosted on Azure, another cloud provider, or an on-premises server, ensuring full compatibility.<\/li>\n<li><strong>Flexible Collection Viewer<\/strong>: You can navigate and analyze collections using <strong>Table, Tree, and JSON views<\/strong>. Built-in pagination controls allow you to manage large datasets effortlessly.<\/li>\n<li><strong>Document Management<\/strong>: You can view, edit, and delete individual documents directly within the extension, making database modifications quick and efficient without requiring external tools.<\/li>\n<\/ul>\n<p><strong>\u2705 Azure Databases VS Code Extension unifies MongoDB workflows by offering a user-friendly and feature-rich MongoDB GUI<\/strong><\/p>\n<h2>Use It with Any MongoDB Cluster<\/h2>\n<p>The Azure Databases VS Code Extension works with any MongoDB deployment, whether your database is on Azure, in another cloud environment, or even on a local machine.<\/p>\n<p>If you are an Azure user, browse your subscription in VS Code to select your Azure Cosmos DB for NoSQL instance &#8211; available with either the Request Units (RU) model or the vCore-based architecture &#8211; for a seamless connection.<\/p>\n<p>For any other MongoDB environment, simply enter your complete <strong>connection string<\/strong> in the <code><strong>MongoDB Cluster Accounts<\/strong><\/code>\u00a0workspace area.<\/p>\n<h2>Truly Open Source<\/h2>\n<p>We believe in open development and collaboration. Our entire development process is <strong><a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\" target=\"_blank\" rel=\"noopener\">public on GitHub<\/a> &#8211; <\/strong>including <a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\/discussions\" target=\"_blank\" rel=\"noopener\">discussions<\/a>, contributions, and improvements.<\/p>\n<p><strong>Follow Our Public Roadmap:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\/projects\" target=\"_blank\" rel=\"noopener\"><strong>Planned features<\/strong><\/a> \ud83d\ude80<\/li>\n<li><a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\/projects\" target=\"_blank\" rel=\"noopener\"><strong>Active development<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\/issues\" target=\"_blank\" rel=\"noopener\"><strong>Challenges and known issues<\/strong><\/a><\/li>\n<\/ul>\n<p>All <a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\/pulls\" target=\"_blank\" rel=\"noopener\"><strong>Pull Requests (PRs) are reviewed publicly<\/strong><\/a>, so you can follow along as we develop, debug, and enhance the extension.<\/p>\n<h2>\ud83c\udf93 How To Get Started\u00a0(Tutorial)<\/h2>\n<p>In this tutorial, we\u2019ll guide you through installing the <strong>Azure Databases VS Code Extension<\/strong>, setting it up, and connecting to a MongoDB database. Once set up, we\u2019ll import sample data and explore the extension\u2019s data exploration features.<\/p>\n<p>Getting started requires installing VS Code, adding the Azure Databases extension, and setting up a MongoDB-compatible database. Follow these steps to prepare your environment.<\/p>\n<h3><strong>1. Install VS Code<\/strong><\/h3>\n<ul>\n<li>Download and install <a href=\"https:\/\/code.visualstudio.com\/\" target=\"_blank\" rel=\"noopener\">Visual Studio Code<\/a>.<\/li>\n<li>Ensure you have the latest version for the best compatibility.<\/li>\n<\/ul>\n<h3><strong>2. Install the Azure Databases VS Code Extension<\/strong><\/h3>\n<ul>\n<li>Open <strong>VS Code<\/strong>.<\/li>\n<li>Navigate to the <strong>Extensions<\/strong> view by selecting <strong>View &gt; Extensions<\/strong> or using the shortcut <code><strong>Ctrl + Shift + X<\/strong><\/code> on Windows and <code><strong>Command + Shift + X<\/strong><\/code> on macOS.<\/li>\n<li>Search for <strong>Azure Databases<\/strong> in the Marketplace and select it from the list.<\/li>\n<li>Click <strong>Install<\/strong> to add the extension.<\/li>\n<\/ul>\n<h3><strong>3. Prepare Your MongoDB Database<\/strong><\/h3>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<thead>\n<tr>\n<td style=\"width: 50%;\"><strong>Using Azure Services<\/strong><\/td>\n<td style=\"width: 50%;\"><strong>Using Third-Party Services<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 50%; vertical-align: top;\">\n<ol>\n<li>Navigate to the <a href=\"https:\/\/ms.portal.azure.com\/#browse\/Microsoft.DocumentDB%2FmongoClusters\" target=\"_blank\" rel=\"noopener\"><strong>Azure Cosmos DB for MongoDB (vCore)<\/strong><\/a> section in the <strong>Azure Portal<\/strong>.<\/li>\n<li>Create a new <strong>Azure Cosmos DB for MongoDB (vCore)<\/strong> cluster.<\/li>\n<li>When setting up the cluster, set an administrator password and keep it available for later use.<\/li>\n<\/ol>\n<\/td>\n<td style=\"width: 50%; vertical-align: top;\">\n<ol>\n<li>Prepare the <strong>connection string<\/strong> for your MongoDB deployment\u00a0and keep it available for later use.\n<ul>\n<li>The connection string must start with <code><strong>mongodb:\/\/<\/strong><\/code> or <code><strong>mongodb+srv:\/\/<\/strong><\/code>.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>\u2705 You have now installed VS Code, set up the Azure Databases VS Code Extension, and prepared a MongoDB-compatible database for connection.<\/strong><\/p>\n<h3><strong>4. Connect to Your Database<\/strong><\/h3>\n<p>With the setup complete, the next step is connecting to your MongoDB database using either Azure Cosmos DB or a third-party MongoDB deployment.<\/p>\n<table style=\"border-collapse: collapse; width: 100%; height: 344px;\">\n<thead>\n<tr style=\"height: 24px;\">\n<td style=\"width: 50%; height: 24px;\"><strong>Using Azure Services<\/strong><\/td>\n<td style=\"width: 50%; height: 24px;\"><strong>Using Third-Party Services<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr style=\"height: 320px;\">\n<td style=\"width: 50%; vertical-align: top; height: 320px;\">\n<ol>\n<li>Open the <strong>Azure Databases Extension<\/strong> in <strong>VS Code<\/strong>.\n<ul>\n<li>Locate and select the <strong>Azure<\/strong> icon in the primary VS Code sidebar on the left-hand side.<\/li>\n<\/ul>\n<\/li>\n<li>Navigate to your <strong>Azure Cosmos DB for MongoDB (vCore)<\/strong> cluster:\n<ul>\n<li>Locate the <strong>Resources<\/strong> area.<\/li>\n<li>Expand the node containing your <strong>Azure Subscription name<\/strong>.<\/li>\n<li>Expand the <strong>Azure Cosmos DB for MongoDB (vCore)<\/strong> node.<\/li>\n<\/ul>\n<\/li>\n<li>Connect to your MongoDB cluster:\n<ul>\n<li>Find your cluster in the list and expand it.<\/li>\n<li>Enter the <strong>administrator password<\/strong> when prompted.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/td>\n<td style=\"width: 50%; vertical-align: top; height: 320px;\">\n<ol>\n<li>Open the <strong>Azure Databases Extension<\/strong> in <strong>VS Code<\/strong>.\n<ul>\n<li>Locate and select the <strong>Azure<\/strong> icon in the primary VS Code sidebar on the left-hand side.<\/li>\n<\/ul>\n<\/li>\n<li>Add a new connection to your MongoDB deployment:\n<ul>\n<li>In the <strong>Workspace<\/strong> area, locate and expand the <strong>MongoDB Cluster Connections<\/strong> node.<\/li>\n<li>Select <strong>New Connection<\/strong> in the <strong>MongoDB Cluster Connections<\/strong> tree.<\/li>\n<li>Paste your <strong>MongoDB connection string<\/strong> and confirm the <strong>username and password<\/strong>.<\/li>\n<li>A new entry will be added and listed under <strong>MongoDB Cluster Connections<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<li>Connect to your MongoDB cluster:\n<ul>\n<li>Locate and expand your newly created <strong>MongoDB cluster connection<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-9499 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-empty-server.webp\" alt=\"A screenshot showing the Azure Databases VS Code Extension connected to an empty MongoDB server.\" width=\"1521\" height=\"675\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-empty-server.webp 1521w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-empty-server-300x133.webp 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-empty-server-1024x454.webp 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-empty-server-768x341.webp 768w\" sizes=\"(max-width: 1521px) 100vw, 1521px\" \/><\/p>\n<p><strong>\u2705 Your MongoDB database is now connected, and you can begin managing and exploring your data.<\/strong><\/p>\n<h3><strong>5. Create a New Database and a Collection<\/strong><\/h3>\n<p>Once connected, create a new database and collection to start managing data.<\/p>\n<ol>\n<li>Right-click your <strong>MongoDB cluster<\/strong> and select <strong>Create Database\u2026<\/strong> from the context menu.<\/li>\n<li>Enter <code><strong>MyDatabase<\/strong><\/code> when prompted for the database name.<\/li>\n<li>Expand the newly created <strong>MyDatabase<\/strong> node.<\/li>\n<li>Select <strong>Create Collection<\/strong>.<\/li>\n<li>Enter <code><strong>MyCollection<\/strong><\/code> when prompted for the collection name.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-9502 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-mycollection-tree.png\" alt=\"A screenshot of Azure Databases VS Code Extension showing a resources tree\" width=\"500\" height=\"161\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-mycollection-tree.png 500w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-mycollection-tree-300x97.png 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/p>\n<p><strong>\u2705 You have successfully created a new database and collection.<\/strong><\/p>\n<h3><strong>6. Import Sample Data<\/strong><\/h3>\n<p>Populate your collection with sample data to explore the extension\u2019s features. <a href=\"https:\/\/gist.github.com\/tnaum-ms\/fe56a0dcff69f10793d2875ad9d7498a\" target=\"_blank\" rel=\"noopener\"><strong>Here<\/strong><\/a> is a download link for a sample file containing a description of 500 restaurants and their reviews. Download the file and have it available for the next steps.<\/p>\n<ol>\n<li>Expand the newly created <strong>MyCollection<\/strong> node.<\/li>\n<li>Click <strong>Documents<\/strong> to open the <strong>Collection View<\/strong>.<\/li>\n<li>In the <strong>Collection View<\/strong>, click the <strong>Import<\/strong> button in the upper right corner.<\/li>\n<li>Select <strong>Import from JSON\u2026<\/strong>.<\/li>\n<li>Navigate to the downloaded file <a href=\"https:\/\/gist.github.com\/tnaum-ms\/fe56a0dcff69f10793d2875ad9d7498a\" target=\"_blank\" rel=\"noopener\"><code><strong>restaurants.json<\/strong><\/code><\/a>.<\/li>\n<li>A confirmation message will indicate that <strong>500 documents<\/strong> were imported.<\/li>\n<li>Click <strong>Refresh<\/strong> to see them in the <strong>Collection View<\/strong>.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-9504 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-post-import.png\" alt=\"A screenshot of Azure Databases VS Code Extension showing a collection view\" width=\"2256\" height=\"1432\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-post-import.png 2256w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-post-import-300x190.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-post-import-1024x650.png 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-post-import-768x487.png 768w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-post-import-1536x975.png 1536w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-post-import-2048x1300.png 2048w\" sizes=\"(max-width: 2256px) 100vw, 2256px\" \/><\/p>\n<p><strong>\u2705 Your collection now contains sample data, ready for exploration.<\/strong><\/p>\n<h3><strong>7. Explore the Data Exploration Features<\/strong><\/h3>\n<p>Use the <strong>JSON<\/strong>, <strong>Tree<\/strong>, and <strong>Table<\/strong> <strong>Views<\/strong> to analyze your data in different formats.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-9506 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-change-views.png\" alt=\"A screenshot of Azure Databases VS Code Extension\" width=\"1545\" height=\"683\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-change-views.png 1545w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-change-views-300x133.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-change-views-1024x453.png 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-change-views-768x340.png 768w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-change-views-1536x679.png 1536w\" sizes=\"(max-width: 1545px) 100vw, 1545px\" \/><\/p>\n<ul>\n<li><strong>JSON View<\/strong>\n<ul>\n<li>The JSON View displays documents in raw format, making it useful for quick inspection of specific properties.<\/li>\n<li>It includes syntax highlighting to enhance readability and help distinguish key elements quickly.<\/li>\n<li>Get familiar with the structure of imported documents and locate the <code><strong>additionalInfo<\/strong><\/code>\u00a0property containing an embedded object.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Tree View<\/strong>\n<ul>\n<li>The Tree View organizes documents hierarchically. Expand and collapse properties to focus on relevant details and better understand individual document structures.<\/li>\n<li>Expand the <code><strong>additionalInfo<\/strong><\/code>\u00a0property to explore embedded objects.\u00a0Observe three columns: <strong>property name, value, and data type<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Table View<\/strong>\n<ul>\n<li>The Table View presents multiple documents at once, grouping values from different documents into columns. This helps detect patterns, spot inconsistencies, and identify missing values.<\/li>\n<li>Column names are inferred automatically from document properties and used to group values.\u00a0Each cell displays the actual data type of its value for clarity.<\/li>\n<li>Double-click <code><strong>additionalInfo<\/strong><\/code>\u00a0in the first document to inspect all embedded objects.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Navigate through the <strong>paging controls<\/strong> to explore beyond the first <strong>10 documents<\/strong>.<\/p>\n<p><strong>\u2705 You have explored different ways to view and analyze your data.<\/strong><\/p>\n<h3><strong>8. Run Queries and Manage Your Database<\/strong><\/h3>\n<p>Run queries to filter and retrieve data efficiently.<\/p>\n<ol>\n<li>Navigate to the <strong>query area<\/strong>.\n<ul>\n<li><img decoding=\"async\" class=\"aligncenter wp-image-9524 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-query-area.png\" alt=\"Screenshot of the Azure Databases VS Code Extension\" width=\"1545\" height=\"617\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-query-area.png 1545w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-query-area-300x120.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-query-area-1024x409.png 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-query-area-768x307.png 768w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-query-area-1536x613.png 1536w\" sizes=\"(max-width: 1545px) 100vw, 1545px\" \/><\/li>\n<\/ul>\n<\/li>\n<li>Run a query to find all vegetarian restaurants: <strong><code>{ \"cuisine\": \"Vegetarian\" }<\/code><\/strong><\/li>\n<li>Use auto-completion for complex queries:\n<ul>\n<li>Start typing <strong><code>{ add<\/code><\/strong> and wait for suggestions.\n<ul>\n<li><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-add.png\">\n<img decoding=\"async\" class=\"aligncenter wp-image-9508 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-add.png\" alt=\"Screenshot of Azure Databases VS Code Extension\" width=\"1545\" height=\"624\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-add.png 1545w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-add-300x121.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-add-1024x414.png 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-add-768x310.png 768w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-add-1536x620.png 1536w\" sizes=\"(max-width: 1545px) 100vw, 1545px\" \/>\n<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Select <code><strong>additionalInfo.hasOutdoorSeating<\/strong><\/code>, type <strong><code>:<\/code><\/strong> and select <code><strong>true<\/strong><\/code>.\n<ul>\n<li><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-true.png\">\n<img decoding=\"async\" class=\"aligncenter wp-image-9509 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-true.png\" alt=\"Screenshot of Azure Databases VS Code Extension\" width=\"1544\" height=\"561\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-true.png 1544w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-true-300x109.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-true-1024x372.png 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-true-768x279.png 768w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2025\/02\/screenshot-azure-databases-collection-view-autocomplete-true-1536x558.png 1536w\" sizes=\"(max-width: 1544px) 100vw, 1544px\" \/>\n<\/a><\/li>\n<li>Azure Databases inferred that the most common data type for this property is a Boolean, which is why it is suggested here.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>Explore more complex queries:<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Start typing in <code><strong>{ \"rating\":<\/strong><\/code> to see <strong>auto-complete suggestions<\/strong>.<\/li>\n<li>To find restaurants rated above 4 stars, choose the suggestion with the <code>$gt<\/code> operator:\n<ul>\n<li><code><strong>{ \"rating\": { \"$gt\": 4 } }<\/strong><\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>\u2705 You have successfully run queries to explore your data.<\/strong><\/p>\n<h3><strong>9. There Is More<\/strong><\/h3>\n<p>The tutorial above introduced the core functionalities of the Azure Databases VS Code Extension, covering setup, data exploration, and queries. However, there\u2019s much more to discover. The extension includes additional tools that enhance productivity and improve database management.<\/p>\n<p><strong>Collection View Enhancements<\/strong><\/p>\n<ul>\n<li>Adjust page size to control how many documents are displayed at once.<\/li>\n<li>Navigate embedded objects more effectively in Table View.<\/li>\n<li>Use the Export feature to save data for external use.<\/li>\n<li>Add or edit documents directly within the extension.<\/li>\n<\/ul>\n<p><strong>Advanced Tree View Features<\/strong><\/p>\n<ul>\n<li>Use the context menu to add or remove databases and collections.<\/li>\n<li>Start MongoDB Shell to run advanced queries.<\/li>\n<li>Open a local scrapbook to experiment with commands and keep track of useful queries.<\/li>\n<\/ul>\n<p>These features provide more control and flexibility, making database management even more efficient. Explore these tools to refine your workflow and maximize your use of the extension.<\/p>\n<p><strong>\u2705 Congratulations! <\/strong>You\u2019ve completed your first steps with the Azure Databases VS Code Extension and are now ready to manage MongoDB databases efficiently. Explore more features and best practices to enhance your experience!<\/p>\n<h2>\ud83d\udcac Join the Discussion!<\/h2>\n<p>Join our <a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\/discussions\" target=\"_blank\" rel=\"noopener\"><strong>GitHub<\/strong> <strong>discussion boards<\/strong><\/a>\u00a0to share feedback, ask questions, and help shape the future of this extension with your ideas:<\/p>\n<ul>\n<li><a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\/discussions\/categories\/announcements\" target=\"_blank\" rel=\"noopener\"><strong>Announcements<\/strong><\/a> \u2013 Updates on releases, new features, and upcoming plans.<\/li>\n<li><a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\/discussions\/categories\/ideas\" target=\"_blank\" rel=\"noopener\"><strong>Ideas<\/strong><\/a> \u2013 Suggest new features or improvements.<\/li>\n<li><a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\/discussions\/categories\/general\" target=\"_blank\" rel=\"noopener\"><strong>General<\/strong><\/a> \u2013 Ask questions and discuss anything about the extension.<\/li>\n<\/ul>\n<p><strong>Your feedback drives development!<\/strong> Vote on features, report issues, or suggest improvements in our <a href=\"https:\/\/github.com\/microsoft\/vscode-cosmosdb\/issues?q=state%3Aopen%20label%3A%22feedback%20wanted%22\" target=\"_blank\" rel=\"noopener\"><strong>Feedback Wanted<\/strong><\/a> section.<\/p>\n<h2>More Than Just MongoDB!<\/h2>\n<p>The Azure Databases VS Code Extension isn&#8217;t just about MongoDB! It supports <strong>Azure Cosmos DB for NoSQL<\/strong>\u00a0as well, giving developers a single tool to manage different database models with ease.<\/p>\n<p>You can connect to <strong>Azure Cosmos DB for NoSQL<\/strong>, perform CRUD operations, and switch seamlessly between MongoDB and NoSQL environments. This extension simplifies workflows and provides a unified experience for managing cloud databases.<\/p>\n<h2>Conclusion<\/h2>\n<p>The <a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ms-azuretools.vscode-cosmosdb\" target=\"_blank\" rel=\"noopener\"><strong>Azure Databases VS Code Extension<\/strong><\/a> is more than just a database management tool &#8211; it provides a <strong>full-featured MongoDB GUI<\/strong> alongside support for <strong>Azure Cosmos DB for NoSQL<\/strong>. Whether you&#8217;re working with MongoDB or NoSQL databases, this extension brings database management together in one place, making it easier to connect, explore, and manage your data.<\/p>\n<p>With built-in tools for <strong>querying, document management, and data exploration<\/strong>, you can work with your databases efficiently without switching between multiple applications. Browse collections, import data, and run queries directly from VS Code.<\/p>\n<p>Try it today and see how this open-source MongoDB GUI helps simplify database development and improve productivity.<\/p>\n<h2><strong>Leave a review<\/strong><\/h2>\n<p>Tell us about your Azure Cosmos DB experience! Leave a review on PeerSpot and we\u2019ll gift you $50. <a href=\"https:\/\/peerspotdotcom.my.site.com\/proReviews\/?SalesOpportunityProduct=00kPy000004TKXJIA4&amp;productPeerspotNumber=30881&amp;CalendlyAccount=peerspot&amp;CalendlyFormLink=peerspot-product-reviews-ps-gc-vi-sf-50&amp;giftCard=50\" target=\"_blank\" rel=\"noopener\">Get started here<\/a>.<\/p>\n<h2><strong>About Azure Cosmos DB<\/strong><\/h2>\n<p>Azure Cosmos DB is a fully managed and serverless NoSQL and vector database for modern app development, including AI applications. With its SLA-backed speed and availability as well as instant dynamic scalability, it is ideal for real-time NoSQL and MongoDB applications that require high performance and distributed computing over massive volumes of NoSQL and vector data.<\/p>\n<p><a href=\"https:\/\/cosmos.azure.com\/try\/\" target=\"_blank\" rel=\"noopener\">Try Azure Cosmos DB for free here.<\/a> To stay in the loop on Azure Cosmos DB updates, follow us on <a href=\"https:\/\/twitter.com\/AzureCosmosDB\" target=\"_blank\" rel=\"noopener\">X<\/a>, <a href=\"https:\/\/aka.ms\/AzureCosmosDBYouTube\" target=\"_blank\" rel=\"noopener\">YouTube<\/a>, and <a href=\"https:\/\/www.linkedin.com\/company\/azure-cosmos-db\/\" target=\"_blank\" rel=\"noopener\">LinkedIn<\/a>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Azure Cosmos DB for MongoDB provides robust support through its Request Units (RU) model and vCore-based architecture, enabling flexible and scalable options for various workloads. We are now on a mission to deliver the ultimate developer experience. To achieve this, we have integrated Azure Cosmos DB for MongoDB support into the Azure Databases VS [&hellip;]<\/p>\n","protected":false},"author":181541,"featured_media":9531,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[14],"tags":[1768,1246,1870,498],"class_list":["post-9442","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-core-sql-api","tag-azure-cosmos-db-api-for-mongodb","tag-mongodb","tag-vcore","tag-visual-studio-code"],"acf":[],"blog_post_summary":"<p>Introduction Azure Cosmos DB for MongoDB provides robust support through its Request Units (RU) model and vCore-based architecture, enabling flexible and scalable options for various workloads. We are now on a mission to deliver the ultimate developer experience. To achieve this, we have integrated Azure Cosmos DB for MongoDB support into the Azure Databases VS [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/9442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/users\/181541"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/comments?post=9442"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/9442\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media\/9531"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media?parent=9442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/categories?post=9442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/tags?post=9442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}