Skip to content
| Marketplace
Sign in
Visual Studio Code>Azure>Azure DatabasesNew to Visual Studio Code? Get it now.

Azure Databases

Preview

Microsoft

|
787,890 installs
| (38) | Free
Create, browse, and update globally distributed, multi-model databases in Azure.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

Azure Databases for VS Code (Preview)

Browse and query your Azure databases both locally and in the cloud using scrapbooks with rich Intellisense then connect to Azure to manage your PostgreSQL and Cosmos DB databases with support for MongoDB, Graph (Gremlin), and SQL (previously known as DocumentDB).

Azure Databases Extension

Prerequisites

  • Some less-common commands in the Mongo scrapbook and use of the Mongo shell require installing Mongo DB and Mongo shell.

Features

Azure Databases Explorer

  • Create a database server by clicking the + button in the title
  • View database servers and open directly in the portal
  • View/Create/Delete databases, collections, graphs, stored procedures, documents, and queries
  • Click on a document, stored procedure, or query to open in the editor
  • Click on a graph to visualize data
  • Query graph using Gremlin
  • Edit a document and persist changes to the cloud
  • Attach a Mongo server by clicking the plug icon in the title

Browse PostgreSQL, CosmosDB, and MongoDB databases

Mongo Scrapbooks

Run Mongo Commands with Rich Intellisense

  • View your MongoDB database account by signing in to Azure or using "Attach Database Account" to connect via a connection string
  • Optionally configure the settings mongo.shell.path and mongo.shell.args if your mongo executable is not already on your system's PATH (many of the common commands have built-in support and do not require the Mongo shell to be installed - see Prerequisites)
  • Click on "New Mongo Scrapbook" in the tree title bar
  • Click on "Connect to a database" to indicate which database to run the commands against
  • Enter your commands and/or comments, eg: db.<collectionName>.find()
  • IntelliSense (auto-completions) will be provided
  • Click on "Execute" above a command to execute it, or press CMD+" (Mac) or CTRL+" (Windows and Linux) to execute the line with the cursor
  • To run all commands, click on "Execute All", or press CMD+: or Ctrl+:
  • Save and re-use later Mongo Scrapbook

Import into Cosmos DB

  • You can now import documents from your workspace into CosmosDB. Use the context menu of a collection or a document file (json) to get started! Import documents

Use Gremlin to query graphs

Query Graphs

  • Configure the user setting cosmosDB.graph.viewSettings to customize which properties to display and which colors to use based on vertex label.
    "cosmosDB.graph.viewSettings": [
        {
            "vertexSettings": [
                {
                    // Default settings for all vertices
                    "displayProperty": [
                        // Display name property if exists, otherwise firstName if it exists, otherwise ID
                        "name",
                        "firstName"
                    ],
                    // Auto-choose color by label
                    "color": "auto",
                    // Show label after display property
                    "showLabel": true
                },
                {
                    // These setting apply to vertices with the label 'person'
                    "appliesToLabel": "person",
                    "color": "blue"
                }
            ]
        }
    ]

Create an Azure Databases Server

Create Azure Databases Server

Attach to the Cosmos DB Emulator

  • Install and run the Cosmos DB Emulator on your local machine
  • Right click 'Attached Database Accounts' and select 'Attach Emulator'

Attach Emulator

Managing Azure Subscriptions

If you are not signed in to Azure, you will see a "Sign in to Azure..." link. Alternatively, you can select "View->Command Palette" in the VS Code menu, and search for "Azure: Sign In".

Sign in to Azure

If you don't have an Azure Account, you can sign up for one today for free and receive $200 in credits by selecting "Create a Free Azure Account..." or selecting "View->Command Palette" and searching for "Azure: Create an Account".

You may sign out of Azure by selecting "View->Command Palette" and searching for "Azure: Sign Out".

To select which subscriptions show up in the extension's explorer, click on the "Select Subscriptions..." button on any subscription node (indicated by a "filter" icon when you hover over it), or select "View->Command Palette" and search for "Azure: Select Subscriptions". Note that this selection affects all VS Code extensions that support the Azure Account and Sign-In extension.

Select Azure Subscriptions

Known Issues

  • Azure no longer supports gremlin queries on pre-GA graph accounts. If you see the error "Could not find a valid gremlin endpoint for graph", then choose "Open Portal" on the graph node and check the "Gremlin Endpoint" in the Overview tab. If it does not take the form of '...[graph-name].gremlin.cosmosdb.azure.com...', then you will need to create a new graph account using the Azure portal or the current version of the extension.
  • Graphs are not currently supported with the emulator
  • Viewing/editing tables is not currently supported
  • Support for escapes in the scrapbooks is preliminary. We currently do not support escaped characters as is inside a string - the characters need to be double escaped. For example, newlines in the string should be '\\n' instead of '\n' to be recognized correctly. If you find any issues with how the scrapbook handles escapes, please add to issue #937.

Telemetry

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.

License

MIT

  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2022 Microsoft