Cosmos DB Client & Azure Cosmos DB Explorer (CosmosDB NoSQL Query, Emulator)

Cosmos DB Client & Azure Cosmos DB Explorer (CosmosDB NoSQL Query, Emulator), a VS Code extension by Zovo

Free Cosmos DB client for the NoSQL API. Connect with a connection string, an endpoint and key, or the local emulator in one click. No Azure sign-in, no account, no telemetry. The extension talks only to the Cosmos DB endpoints you add (and to Microsoft sign-in, only if you choose Entra ID for a connection).

Install in VS CodeOpen the Marketplace page

Free, MIT license. Needs VS Code 1.90.0 or newer. Extension ID zovo.zovo-cosmos-db-client, version 0.1.2.

Not made by, affiliated with or endorsed by Microsoft. "Azure" and "Cosmos DB" are Microsoft trademarks, used here only to say what this extension connects to.

A Cosmos DB query in VS Code: results in a grid, the request charge and query metrics of every page above it, and the Cosmos DB Explorer on the left

Questions people ask

Is Cosmos DB Client & Azure Cosmos DB Explorer (CosmosDB NoSQL Query, Emulator) free?

Yes. Cosmos DB Client & Azure Cosmos DB Explorer (CosmosDB NoSQL Query, Emulator) is free and MIT licensed.

How do I install Cosmos DB Client & Azure Cosmos DB Explorer (CosmosDB NoSQL Query, Emulator)?

Click "Install in VS Code" above, or search for zovo.zovo-cosmos-db-client in the Extensions view.

What you get, free

Why this one

Measured or linked, so you can check:

Get started

  1. Open the Cosmos DB view in the Activity Bar.
  2. Click Connect to Local Emulator, or Add Connection and paste a connection string (AccountEndpoint=...;AccountKey=...;).
  3. Expand a database and click a container. The results open next to the query.

The local emulator on macOS and Linux runs in Docker:

docker run -d -p 8081:8081 -p 1234:1234 mcr.microsoft.com/cosmosdb/linux/azure-cosmos-emulator:vnext-preview

Query files

-- Parameters: one line per parameter, JSON or plain text
-- @status = "open"
-- @min = 100
SELECT c.id, c.customerId, c.total
FROM c
WHERE c.status = @status AND c.total > @min
ORDER BY c.total DESC

The results toolbar has the page size, the partition key value (empty means all partitions; a JSON array such as ["acme","eu"] for hierarchical keys), Load more, Load all, the grid or JSON view, system properties and Export.

Zovo Pro (optional)

Two tools for people who pay for request units. Each can be tried 3 times for free. Zovo Pro is USD 19 once and adds the Pro tools to every Zovo extension. Everything listed under "What you get, free" stays free.

Buy on GitHub Sponsors ("$19 one time") and choose Unlock with GitHub Sponsors, or pay with PayPal and get a license key. The setting zovoCosmos.showProFeatures hides the Pro tools.

Settings

SettingDefaultWhat it does
zovoCosmos.pageSize100Items per page (max item count)
zovoCosmos.maxLoadedItems50000Items kept in one results view; export streams every item
zovoCosmos.timeoutSeconds30Request timeout, with a clear message instead of a hang; Load all retries a slow page twice
zovoCosmos.emulatorPort8081Port for Connect to Local Emulator
zovoCosmos.exportSystemPropertiesfalseKeep _rid, _etag, _ts and the others in exports
zovoCosmos.costReportMaxPages200Page limit of the Query Cost Report
zovoCosmos.askForRatingtrueOne rating question after real use, never after an error
zovoCosmos.showSupportLinkstrueThe small links under the results
zovoCosmos.showProFeaturestrueShow the Zovo Pro tools

Privacy and network

Limits

Install Cosmos DB Client & Azure Cosmos DB Explorer (CosmosDB NoSQL Query, Emulator)

Click the button to open VS Code and install it, or press Ctrl+P (Cmd+P on macOS) in VS Code and run ext install zovo.zovo-cosmos-db-client.

Free, MIT license. Needs VS Code 1.90.0 or newer. Extension ID zovo.zovo-cosmos-db-client, version 0.1.2.

Source code and issues are on GitHub.

All our VS Code extensions

Zovo Pro and support

Zovo Pro: USD 19 once, every Zovo viewer. It turns on the Pro tools in this extension and in the other Zovo extensions you use. The free features stay free.

After a card payment your license key shows on the next page. Paste it with the command "Zovo Pro: Enter a key".

You can also support the work with no Pro:

Need your format supported?

Open a format request with a sample file, and I reply there whether it can be done. For USD 299 once, through this GitHub Sponsors tier, I add your file format or a missing feature to this extension, with tests, within 7 days.