DocumentDB for VS Code v0.6 Released! 🏋️

[tnaum-ms]

DocumentDB for VS Code v0.6 Released! 🏋️

We are excited to announce the release of DocumentDB for VS Code Extension v0.6. This is a landmark update for our DocumentDB and MongoDB GUI, focused on query optimization and developer productivity. It introduces a powerful new Query Insights with Performance Advisor, enhances query authoring capabilities, and improves index management for developers working with DocumentDB and MongoDB API databases.

What's New in v0.6

⭐ Query Insights with Performance Advisor

We are introducing a major new feature: Query Insights with Performance Advisor. This powerful tool helps you understand and optimize your queries directly within VS Code. When you run a find query against your DocumentDB or MongoDB API database, a new "Query Insights" tab appears, providing a three-stage analysis of your query's performance.

• Stage 1: Initial Performance View
  The first stage provides an immediate, low-cost static analysis of your query. It visualizes the query plan, showing how the database intends to execute your query. This helps you understand performance bottlenecks and the query's processing stages without re-running it.

• Stage 2: Detailed Execution Analysis
  For a deeper dive, the second stage runs a detailed execution analysis using executionStats to gather authoritative metrics. You'll see precise counts for documents and keys examined, server-side execution time, and a detailed breakdown of each stage in the execution plan. This provides clear insights into how your query actually performed.

  The complex JSON response from the database is translated into an easy-to-comprehend chart, making it simple to visualize the query's execution flow.

  Additionally, a Query Efficiency Analysis card provides a quick performance assessment. It highlights key aspects of the query's execution, such as the execution strategy, index usage, and whether an in-memory sort occurred. A performance rating (Good, Fair, or Poor) helps you quickly identify an inefficient or slow query.

• Stage 3: AI-Powered Recommendations with GitHub Copilot
  The final stage brings the power of AI to your query optimization workflow. By clicking Get AI Performance Insights, the extension sends the query shape and execution statistics to a service powered by GitHub Copilot. For more details, please see our documentation.

  The AI assistant provides:

  🕵️‍♂️ Analysis

  A summary of the query's performance.

  📈 Actionable Recommendations

  Suggestions for creating, hiding, or unhiding indexes to improve performance, with an option to apply them directly.

  🎓 Detailed Explanations

  A breakdown of the execution plan to help you understand how the query was processed.

The "Query Insights" feature helps solve performance issues and educates users on query best practices for DocumentDB and MongoDB API databases.

⭐ Improved Query Specification

We've enhanced the query authoring experience to support more sophisticated queries. Previously, you could only specify the filter for a find query. Now, you have full control to include projection, sort, skip, and limit parameters directly in the query editor, enabling more complex data retrieval without leaving VS Code.

The projection and sort fields also support the same rich autocompletion that was previously available for the filter field.

⭐ Index Management from the Tree View

Managing your indexes is now easier and more intuitive than ever. You can now drop, hide, and unhide indexes directly from the Connections View. Simply expand a database and collection, then expand the "Indexes" node to see all indexes on that collection.

Hovering over an index will show you its details, and the context menu provides the available management operations. This direct workflow helps you maintain your indexes efficiently right from the explorer.

Key Fixes and Improvements

• Improved UI element visibility
  • Fixed an issue where the autocomplete list in the query area could be hidden behind other UI elements.
  • Corrected a problem where tooltips in the table and tree views were sometimes displayed underneath the selection indicator.

Changelog

See the full changelog entry for this release:
➡️ CHANGELOG.md#060

Get Involved

Your feedback helps us shape the future of the extension. If you have suggestions or encounter any issues, please let us know on our GitHub repository. Thank you for being part of our community!

Your DocumentDB for VS Code Team

[tnaum-ms]

Patch Release v0.6.1

This patch release introduces feedback optimization and fixes a broken link.

What's Changed in v0.6.1

Feedback Optimization (#392)

Introduces privacy consent and feedback signal controls for the Query Insights feature, primarily to ensure compliance with organizational data protection requirements and user telemetry settings. It also disables survey functionality and refines the feedback dialog UI.

Privacy Policy Link Update (#388)

Updated the outdated privacy policy link in the README to the current Microsoft privacy statement URL.

Changelog

See the full changelog entry for this release:
➡️ CHANGELOG.md#061

[tnaum-ms]

Patch Release v0.6.2

This patch release delivers important fixes for Azure tenant management, service discovery, and accessibility. It also includes a significant set of dependency upgrades to modernize the extension's underlying architecture.

What's Changed in v0.6.2

💠 Improved Azure Tenant and Subscription Filtering in Service Discovery (#391, #415)

We've resolved a key issue that affected users managing numerous Azure tenants. Previously, when a user had access to a large number of tenants, and had selected all of them, the filtering wizard would fail to work correctly when attempting to deselect tenants, making it impossible to refine the resource view.

This update introduces an improved filtering mechanism that ensures a reliable experience, even for users in enterprise environments. The wizard for managing accounts, tenants, and subscriptions is now more resilient, allowing you to precisely control which resources are displayed in the Service Discovery panel.

For a complete guide on the enhanced workflow, please see our updated documentation on Managing Azure Discovery.

💠 Corrected Service Discovery Default Settings (#390, #412)

To provide a cleaner initial experience, the Service Discovery feature no longer starts with any discovery engines enabled by default. In a previous version, the "Azure Cosmos DB for MongoDB (RU)" plugin was pre-selected by mistake, which could cause confusion.

With this fix, you now have full control over which service discovery plugins are active from the start, for a more intentional and direct setup.

💠 Accessibility Fix for Query Insights (#376, #416)

We've addressed an accessibility issue in the "Query Insights" tab where the "AI response may be inaccurate" warning text would overlap with other UI elements when the panel was resized. The layout has been updated to be fully responsive, ensuring all content remains readable and accessible regardless of panel size.

💠 Modernized Architecture with Major Dependency Upgrades (#406, #407, #386)

This release includes a significant overhaul of our dev dependencies, bringing major performance and modernization improvements:

• Upgraded to React 19: We've migrated our webview components to React 19, leveraging the latest features and performance enhancements from the React team.
• Upgraded to SlickGrid 9: The data grids used to display collection data have been updated to SlickGrid 9. This major update improves rendering performance and aligns with modern JavaScript standards.
• Other Key Updates: We've also updated TypeScript, Webpack, the MongoDB driver, and numerous other packages to enhance security, stability, and build performance.

These upgrades ensure the extension remains fast, secure, and aligned with the latest web development best practices.

Changelog

See the full changelog entry for this release:
➡️ CHANGELOG.md#062

[tnaum-ms]

Patch Release v0.6.3

This patch release brings performance improvements to Query Insights, enhances telemetry, and includes important dependency updates to address a security vulnerability.

What's Changed in v0.6.3

💠 Optimized Query Insights AI Recommendations (#404, #423)

We've optimized the AI-powered recommendation engine in Query Insights to improve performance and consistency. Previously, execution statistics were collected twice, leading to minor discrepancies between the data shown in the analysis and the AI-generated recommendations.

This update ensures that the AI assistant reuses the existing executionStats from the detailed analysis stage (Stage 2), avoiding a redundant database query. This not only makes the recommendation process faster but also guarantees that the insights are based on the exact same metrics displayed to the user.

💠 Improved Telemetry for AI Features (#429)

We've improved error handling for AI-driven features, including Query Insights and Copilot services. This update provides more detailed diagnostic information when an operation fails, such as creating an index or getting a response from the AI. These changes allow us to diagnose and resolve issues more effectively, improving the stability of these features.

💠 Security Update for tRPC Dependencies (#430, #431)

We've upgraded our tRPC dependencies (@trpc/client and @trpc/server) to address a high-severity vulnerability related to possible prototype pollution. This update ensures the extension remains secure and incorporates the latest fixes.

Changelog

See the full changelog entry for this release:
➡️ CHANGELOG.md#063