In the rapidly evolving landscape of software development, the integration of artificial intelligence has become a pivotal factor in shaping how developers approach their work. As AI transitions from a futuristic concept to a fundamental component of modern technology, the tools and methodologies employed by developers have also undergone significant transformation. Today, the expectation is clear: every developer must harness AI capabilities, and every system must be equipped to support this shift.
The database reimagined
As new AI applications emerge, the demand for databases that are not only reliable and secure but also AI-ready has intensified. A remarkable trend has surfaced: over 80% of developers now incorporate AI tools into their workflows, resulting in enhanced productivity and elevated expectations for the developer experience.
Among the various database options available, PostgreSQL has distinguished itself as a preferred choice for developers, particularly those engaged in AI and real-time applications. Its reliability, extensibility, and commitment to rapid innovation have made it the go-to solution for 78.6% of developers embarking on new projects.
PostgreSQL on Azure meets the moment
Choosing the right ecosystem is essential for realizing AI ambitions, and Microsoft has made significant advancements in enhancing its PostgreSQL managed services to cater to contemporary developer needs. Embracing PostgreSQL as both a product and a community, Microsoft proudly stands as a leading contributor to the open-source project, with over 500 commits in the latest release. The goal is clear: to position PostgreSQL as the premier database for intelligent applications and Azure as the optimal environment for their deployment.
The existing Azure Database for PostgreSQL continues to support both lift-and-shift and new open-source workloads, offering improved performance and user experience. Meanwhile, the newly introduced Azure HorizonDB, unveiled at Ignite, is designed for the future, providing a PostgreSQL-compatible cloud service optimized for scale-out and ultra-low latency. Together, these offerings empower developers to create a wide array of applications, from small-scale projects to mission-critical AI systems.
A frictionless and intelligent developer experience
The process of building intelligent applications should be seamless and approachable. The Microsoft team has dedicated efforts to ensure that Azure Database for PostgreSQL delivers a frictionless experience, particularly for those focused on AI applications. From initial provisioning to AI integration and scaling, every aspect of the developer journey has been reimagined to minimize obstacles.
Start in the IDE you love
The development journey begins in Visual Studio Code, the leading integrated development environment (IDE) among developers. With the PostgreSQL extension for Visual Studio Code, developers can provision secure, fully managed PostgreSQL instances on Azure directly from the IDE—eliminating the need for portal navigation or manual configurations. In just a few clicks, the database is ready, complete with built-in support for Entra ID authentication and Azure Monitor.
Once the database is set up, GitHub Copilot steps in as an intelligent assistant. By understanding the PostgreSQL schema, it aids developers in writing, optimizing, and debugging SQL queries using natural language. Whether it involves joining tables, creating indexes, or troubleshooting performance issues, Copilot provides expert guidance to enhance efficiency and effectiveness.
Access in-database intelligence for smarter, faster apps
Once the database is operational, integrating AI into applications becomes a straightforward task. Azure Database for PostgreSQL now facilitates seamless integration with Microsoft Foundry, allowing developers to invoke pre-provisioned large language models (LLMs) directly within SQL. This capability enables tasks such as generating embeddings, classifying text, and conducting semantic searches without leaving the database environment.
For applications that prioritize relevance and speed, the introduction of DiskANN vector indexing offers high-performance similarity search. When combined with semantic ranking, queries yield more accurate results at a faster pace, making it ideal for powering intelligent agents, recommendations, and natural language interfaces.
Build intelligent agents with Microsoft Foundry
For developers ready to create AI agents, Microsoft Foundry’s native PostgreSQL integration simplifies the process. Utilizing the new Model Context Protocol (MCP) server for PostgreSQL, developers can connect PostgreSQL directly to Foundry’s agent framework with minimal effort. This integration empowers agents to reason over data, invoke LLMs, and act on insights, all while benefiting from Azure’s robust security and governance features.
This powerful synergy—combining PostgreSQL’s structured data, Foundry’s orchestration capabilities, and Azure’s AI models—facilitates the development of intelligent, context-aware applications.
To ensure that intelligent applications thrive on real-time insights, Azure Database for PostgreSQL allows users to mirror operational data into Microsoft Fabric for analytics without compromising performance. Additionally, support for Parquet via the Azure Storage Extension enables customers to read from and write to Parquet files stored in Azure Storage using SQL commands.
Performance and scale that grows with you
All these advancements in intelligence are rendered ineffective without a secure and high-performing database. Microsoft continues to innovate, unlocking enhanced performance and scalability to accommodate the most demanding AI workloads. With PostgreSQL 18 now generally available on Azure, users can expect faster I/O, improved vacuuming, and smarter query planning. The introduction of new V6 compute SKUs provides higher throughput and lower latency, while Elastic Clusters facilitate horizontal scaling for multi-tenant and high-volume applications.
Whether developing a startup MVP or scaling a global AI platform, Azure Database for PostgreSQL is equipped to grow alongside its users. Organizations across various industries, from pharmaceuticals to finance, have already leveraged these new capabilities to gain a competitive edge.
Real-world AI on Azure: How Nasdaq reinvented governance with PostgreSQL
Nasdaq, known for its fast-paced trading floors and financial data, also oversees board governance for thousands of organizations, including nearly half of the Fortune 500. At Ignite, Nasdaq showcased how they modernized their Boardvantage platform using Azure Database for PostgreSQL and Microsoft Foundry. Their objective was to integrate AI to assist directors in navigating extensive board packets and extracting insights while maintaining security and compliance. The outcome was a governance platform that utilizes AI to summarize meeting minutes, flag anomalies, and highlight relevant decisions, all while ensuring data isolation and protection for each customer.
Looking ahead: Azure HorizonDB and the future of intelligent apps
At Ignite, Microsoft also unveiled Azure HorizonDB, a fully managed PostgreSQL-compatible service designed for AI-native workloads. With capabilities for scale-out compute, sub-millisecond latency, and built-in AI features, Azure HorizonDB signifies the future of cloud databases. Although currently in private preview, it offers a promising glimpse into what lies ahead.
The future is open, intelligent, and built on Azure
Microsoft’s mission is to provide customers with databases that are prepared for next-generation development, whether they are SQL, NoSQL, relational, or open source. As PostgreSQL continues to shine as a platform for innovation, it is now primed for intelligent applications and agents, thanks to Microsoft’s ongoing support and enhancements. Whether you are a startup launching your first AI feature or an enterprise modernizing critical systems, Azure equips you with the tools necessary to accelerate progress, enhance intelligence, and scale with confidence.
Start today
1Most developers—more than 80%—now use AI tools in their workflow.
2PostgreSQL is chosen by 78.6% of developers that are building AI and real-time applications.
