Browse, manage, and query your Azure Cosmos DB databases both locally and in the cloud with support for Azure Cosmos DB for NoSQL.
Sign up today for your free Azure account and receive 12 months of free popular services, $200 free credit and 25+ always free services 👉 Start Free.
The Azure Cosmos DB Explorer helps you find, view, and manage your Azure CosmosDB databases.
-
Discover Database Accounts: scan your Azure subscription for available database accounts and get a structured list of your resources.
-
Open in Azure Portal: Access database servers directly in the Azure portal.
-
Manage Databases: View, create, and delete databases, collections, stored procedures, and documents.
-
Edit Documents and Queries: Open documents, stored procedures, and queries in the editor.
-
Save Changes: Make updates and persist them to the cloud.
-
Workspace Support: Attach database accounts to your workspace using connection strings. This is especially useful for teams working with shared resources from various subscriptions.
The Query Editor allows you to write and execute queries across your databases.
-
Rich Syntax Highlighting: Highlights query syntax to make it more readable and help prevent errors.
-
Query History: Automatically saves previously executed queries, allowing you to open and reuse them later.
-
Run Queries: Execute queries and view results in Table, JSON, or Tree view.
-
Export Results: Provides options to copy query results as JSON or CSV or to save them to a file for later use.
-
Pagination: Adjust how many results are displayed at a time when working with large datasets.
-
Query Insights and Index Advisor: Displays key details such as execution time, resource consumption, and indexing recommendations.
-
Edit Documents: Open, update, and save individual documents.
-
Create New Documents: Write and validate documents with syntax highlighting.
The Azure Cosmos DB extension supports various keyboard shortcuts to improve your productivity when working with queries and documents.
For a complete list of keyboard shortcuts, see Keyboard Shortcuts.
The extension allows you to import documents into CosmosDB.
-
Workspace Integration: Use the context menu of a collection or document file (JSON) to initiate import.
Attach the Azure Cosmos DB Emulator to work with a local instance of Azure Cosmos DB for development and testing purposes.
-
Emulator Installation: Install and run the Azure Cosmos DB Emulator on your local machine.
-
New Emulator Connection: Expand 'CosmosDB Accounts', next expand 'Local Emulators', and select 'New Emulator Connection' to link the emulator to your workspace.
Warning
Support for previously included features such as Universal MongoDB and PostgreSQL has been moved to separate extensions. You can find the DocumentDB Extension for VS Code and the PostgreSQL Extension for VS Code.
Here are some known issues and limitations to be aware of when using the Azure Cosmos DB extension:
-
Table Viewing/Editing: Viewing and editing tables is not currently supported by the extension.
-
Escaped Characters in Scrapbooks: Scrapbook support for escaped characters is preliminary. Use double escaping for newlines (
\\ninstead of\n). If you find issues, report them to #937.
This project welcomes contributions and suggestions. To contribute, see these documents:
VS Code collects usage data and sends it to Microsoft to help improve our products and services. Read our privacy statement to learn more. If you don’t wish to send usage data to Microsoft, you can set the telemetry.enableTelemetry setting to false. Learn more in our FAQ.
Data Collection. The software may collect information about you and your use of the software and send it to Microsoft. Microsoft may use this information to provide services and improve our products and services. You may turn off the telemetry as described in the repository. There are also some features in the software that may enable you and Microsoft to collect data from users of your applications. If you use these features, you must comply with applicable law, including providing appropriate notices to users of your applications together with a copy of Microsoft’s privacy statement. Our privacy statement is located at https://go.microsoft.com/fwlink/?LinkID=824704. You can learn more about data collection and use in the help documentation and our privacy statement. Your use of the software operates as your consent to these practices.