We’re excited to announce the public preview of Index Advisor for Azure DocumentDB (with MongoDB Compatibility). It is a built-in AI powered performance tuning assistant that helps you understand slow queries, diagnose inefficiencies, and automatically generate optimized index recommendations. 

With Index Advisor, you can quickly analyze query structure, execution plans, and collection statistics to receive data-driven, plain-English index recommendations. Even better, you can apply these recommendations directly inside the DocumentDB for VS Code extension, making performance tuning faster, easier, and seamlessly integrated into your development workflow. 

Why Index Advisor? 

Indexes are one of the most important tools for optimizing database performance, but identifying the right ones can be challenging. Index Advisor simplifies this by: 

• Detecting slow or inefficient queries 

• Providing prioritized index recommendations based on performance impact 

• Explaining why each index matters in clear, actionable language 

• Letting you apply recommendations in a single click from VS Code 

• Automatically re-analyzing your query after index creation so you can compare before-and-after performance 

Whether you’re a developer or DBA, Index Advisor removes the guesswork from index design. 

How It Works 

1. Run the query from the Query Insights tab in the DocumentDB for VS Code extension. 
2. Index Advisor collects and analyzes the execution plan and statistics. 
3. Github Copilot evaluates query patterns and recommends optimized index strategies. 
4. Click Apply to create the suggested index. 
5. Once indexing finishes, Index Advisor automatically reruns the query and updates performance metrics so you can validate improvements instantly. 

This end-to-end experience helps you spot bottlenecks, apply fixes, and measure results, all without leaving your favorite editor. Learn more about it here: https://learn.microsoft.com/azure/documentdb/index-advisor 

 Conclusion 

Index Advisor for Azure DocumentDB  brings intelligent, guided performance tuning directly into VS Code. With clear insights, automated index recommendations, and instant performance validation, it helps you optimize your queries quickly and confidently. 

Join us at Ignite! 

Microsoft Ignite 2025 is more than just a conference—it’s your gateway to mastering Azure Cosmos DB and DocumentDB for building modern, intelligent applications at scale. From deep-dive sessions and hands-on labs to personalized Expert Meet-ups, you’ll gain practical knowledge, connect with industry leaders, and discover how customers like Sam’s Club, Veeam, and Sitecore are transforming their businesses with these technologies. 

Whether you’re optimizing performance, enabling real-time analytics, or exploring AI-driven architectures, Ignite gives you the tools and insights to make it happen. 

Don’t miss out—start planning your schedule today and join us to unlock the full potential of Azure Cosmos DB and DocumentDB. 

About Azure DocumentDB 

Azure DocumentDB is a fully managed enterprise-grade MongoDB-compatible database and vector database for modern app development, including AI applications. With its predictable low costs, Open-source project, as well as 99.03% MongoDB compatibility, it is ideal for any MongoDB application running on Azure. 

About Azure Cosmos DB

Azure Cosmos DB is a fully managed and serverless NoSQL and vector database for modern app development, including AI applications. With its SLA-backed speed and availability as well as instant dynamic scalability, it is ideal for real-time NoSQL and MongoDB applications that require high performance and distributed computing over massive volumes of NoSQL and vector data.

To stay in the loop on Azure Cosmos DB updates, follow us on X, YouTube, and LinkedIn.