Cosmos DB SQL Studio (Preview)

You can query Azure Cosmos DB SQL API by using VS Code now. Extension displays Execution Metrics, Indexing Policies and Overall Information about selected database and container.

Features

• Connect to Cosmos DB SQL API by using token or connection string.
• Query Azure Cosmos DB SQL API
• Point Read by using Partition Key and Id
• Query Options support
• Display Request Unit Charge
• Display Query Execution Plan
• Display Selected Container's Indexing Policy
• Display Selected Database and Container's overall information. (works only with token connection)
  • Container's Partition Keys
  • Container's Unique Keys
  • Container's Conflict Policy
  • Database's Region
  • Database's Failover Policy
  • Database's Consistency Level
  • Analytical Storage information
  • Free Tier information
  • Database's Backup Type

Disclaimer

This program is free software. It comes without any warranty, to the extent permitted by applicable law. Delete functionality is introduced in Application's 0.0.40 version. Please take all steps necessary to check that you are deleting the correct data. You cannot hold Cosmos DB SQL Studio coders for any damages or issues that may arise by using Delete function.

Release Notes

This is the first version of the tool. I hope you will enjoy to query Cosmos DB SQL API from VS Code.

0.0.1

• Initial release of Cosmos DB Studio.
• F5 Executes queries. VS Code environment menu comes up with F5 events too.

0.0.20

• Display number of physical partitions
• Display Execution metrics for each physical partition

0.0.22

• Force Query Plan option is added to the Options.
• List Physical Partitions functionality is added.

0.0.25

• Indexing Metrics is added to the Options

0.0.30

• Map view is added for Spatial Data types.
• Users can search by drawing Rectangle and Polygon on map.
• Spatial data type property should be defined in Option for Rectangle and Polygon search to work.

0.0.35

• Composite Indexes are added to Indexing Policy
• White Background mode is added to Query Results
• Indexing Metrics UI is redesigned
• Options are rearranged.

0.0.37

• Data Analyzer tab is added.
• Data Analyzer let user analyze the current data with basic charts and stats.

0.0.38

• Point Read functionality is moved to right side.
• Query Analyzer tab is added.
• Query Analyzer will track the queries, execution metrics and indexing metrics.
• Users can compare queries by Compare button.

0.0.39

• Style bugs fixed.

0.0.40

• Execution Metrics for Point Read bug is fixed.
• Index Lookup property bug is fixed.
• Query Analyzer seq remove bug is fixed.
• Query Analyzer Clear button bug is fixed.
• Red style is fixed for warning rows
• Index Hit Documents value is rounded to 2 decimals
• Indexing Metrics bug is fixed.
• Delete function is added.

0.0.46

• Delete function supports single physical partitions

0.0.57

• Re-Indexing process is getting display in Indexing Policy tab