Azure

Azure PostgreSQL in VS Code: New Performance Tools

2 min read

Summary

Microsoft has expanded the PostgreSQL extension for Visual Studio Code with new Azure-focused performance and diagnostics features. The update helps developers and DBAs monitor server metrics, review Azure Advisor recommendations, and analyze query plans in one workflow, reducing context switching and speeding up troubleshooting.

Need help with Azure?Talk to an Expert

Introduction

Microsoft is improving how teams manage and tune Azure Database for PostgreSQL by bringing more performance tooling directly into Visual Studio Code. For IT administrators, DBAs, and developers, this matters because database troubleshooting often spans multiple tools, slowing response times and increasing operational risk.

What’s new in the PostgreSQL extension for VS Code

The latest enhancements focus on integrating diagnostics, tuning, and development tasks into a single experience.

Server Metrics Dashboard

  • View CPU, memory, storage, and connection metrics directly in VS Code
  • Access Azure-integrated telemetry and historical insights
  • Reduce the time needed to move from issue detection to investigation

Azure Advisor recommendations in the editor

  • Surface Azure Advisor guidance inside VS Code
  • Get recommendations for configuration, indexing, and resource optimization
  • Align tuning decisions with actual workload telemetry

Query plan visualization and AI assistance

  • Improved query plan visualization makes execution plans easier to interpret
  • New AI-assisted query analysis and optimization helps identify bottlenecks faster
  • Supports teams that need better PostgreSQL performance without requiring every developer to be a database expert

Better SQL authoring and database navigation

  • Schema-aware IntelliSense for more accurate SQL development
  • search_path-aware query authoring for better context in complex environments
  • Improved object explorer reliability for large databases
  • Support for Microsoft Entra ID authentication and Azure resource discovery

Why this matters for IT admins and platform teams

These updates can help standardize PostgreSQL operations across development and production environments. Instead of switching between SQL tools, dashboards, and the Azure portal, teams can investigate performance issues and act on recommendations from within VS Code.

For enterprises running PostgreSQL at scale, that means:

  • Faster troubleshooting
  • Better collaboration between developers and DBAs
  • More consistent tuning practices
  • Lower operational friction and risk

What about Azure HorizonDB?

Microsoft also highlighted Azure HorizonDB, now in public preview, as a PostgreSQL-compatible option for AI-native and cloud-native workloads. However, Azure Database for PostgreSQL remains the recommended platform for most production use cases today.

Next steps

If your organization runs PostgreSQL on Azure, test the updated PostgreSQL extension for Visual Studio Code in a non-production environment first. Review how the metrics dashboard, Advisor recommendations, and query analysis features fit into your existing database operations workflow before broader rollout.

Need help with Azure?

Our experts can help you implement and optimize your Microsoft solutions.

Talk to an Expert

Stay updated on Microsoft technologies

AzurePostgreSQLVisual Studio Codedatabase performanceAzure Database for PostgreSQL

Related Posts

Azure

Microsoft Foundry Adds Continuous Improvement for AI

Microsoft has introduced continuous improvement capabilities in Microsoft Foundry, enabling organizations to build, run, govern, and iteratively optimize AI agents using real-world traces, evaluations, and expert feedback. The update matters because it helps Azure customers improve agent quality, control cost and performance, and maintain governance as AI workloads scale.

Azure

Azure Ignite 2026: AI Infrastructure and Agent Updates

At Microsoft Ignite 2026, Microsoft announced major Azure updates focused on running AI and agents at scale with more control, better performance, and stronger governance. Highlights include Azure Cobalt 200 VMs, Azure Catalyst for agent-led modernization, HorizonDB for PostgreSQL workloads, Fabric apps, and the new Microsoft IQ context platform.

Azure

Azure Catalyst and AI Infrastructure Updates for 2026

Microsoft has announced Azure Catalyst, a new agent-led modernization solution designed to help organizations update applications, data, and infrastructure faster and at lower cost. The company also introduced new Azure AI infrastructure capabilities across AKS, agent security, context management, and hybrid deployment options, giving IT teams more flexibility to run AI workloads at scale.

Azure

Azure Cobalt 200 VMs Now Generally Available

Microsoft has announced the general availability of Azure Cobalt 200 VMs at Ignite 2026, bringing up to 50% better performance than Cobalt 100 for cloud-native, data-intensive, and agentic AI workloads. The new Arm-based VMs are available in 14 regions now, expanding to 23 by the end of 2026, with new VM families and Azure Boost support aimed at improving price-performance and efficiency.

Azure

Microsoft IQ Launches New Enterprise Context Platform

Microsoft has introduced Microsoft IQ, a new enterprise context management platform designed to help organizations bring their business knowledge, data, and processes into AI agents. The announcement matters for IT and development teams because it adds governed context, reusable business plugins, and broad integration across Microsoft Copilot, GitHub Copilot, Azure Foundry, and third-party AI tools.

Azure

Oracle AI Database@Azure Adds Agentic AI Tools

Microsoft and Oracle announced new integrations that bring agentic AI to enterprise workflows by combining Oracle business data with Microsoft Copilot, Work IQ, and Azure services. The update introduces Azure Workload Center for Oracle in limited preview, a new Oracle AI Database plug-in for Excel, and expanded developer tooling to build governed AI agents on trusted Oracle data.