From GitHub Copilot AI help to built-in mannequin administration, Azure helps devs and enterprises unlock the total potential of PostgreSQL.
We’re virtually a century faraway from when a gaggle of pc scientists at Dartmouth Faculty coined the time period “Synthetic Intelligence.” Within the 75-year span, AI has change into frequent vernacular, making inroads from imagined to mainstream. Right this moment, we see complete industries being disrupted and full ecosystems revolutionized by AI. To maintain up, the best way builders work and the instruments they use have needed to evolve. Each developer now must be an AI developer, and each system—from compute and storage to the information layer—now must be AI prepared.
The database reimagined
New AI purposes require databases that aren’t solely dependable, extensible, and safe, but additionally AI-ready. In parallel, the best way builders construct software program is being reshaped by AI. 1Most builders—greater than 80%—now use AI instruments of their workflow. This has led to notable productiveness beneficial properties and it’s altering expectations for developer expertise.
PostgreSQL has emerged as a best choice amongst builders and is turning into the default place to begin for a lot of new purposes and initiatives. Favored by builders for its reliability, extensibility, and fast innovation, 2PostgreSQL is chosen by 78.6% of builders which might be constructing AI and real-time purposes.
PostgreSQL on Azure meets the second
Deciding on the suitable ecosystem is vital to help your AI and agentic aspirations, and we’ve made nice strides in bolstering our PostgreSQL managed companies to satisfy the wants of right this moment’s developer. At Microsoft, we’ve embraced PostgreSQL not simply as a product, however as a group. We’re proud to be one of many prime contributors to the PostgreSQL open-source venture, with greater than 500 commits within the newest launch. We’re constantly innovating to make PostgreSQL one of the best database for constructing clever purposes, and Azure one of the best place to run them.
The prevailing Azure Database for PostgreSQL continues to cater to lift-and-shift and new open-source workloads with improved efficiency and expertise, whereas the brand new Azure HorizonDB, launched at Ignite, targets the long run by providing a PostgreSQL-compatible cloud service constructed for scale-out and ultra-low latency. Collectively, they place Azure to help builders constructing every thing from small apps and brokers to AI-powered, mission-critical techniques, and something in between.
A frictionless and clever developer expertise
Constructing clever purposes ought to really feel intuitive, not intimidating. The Microsoft staff has invested in making Azure Database for PostgreSQL a frictionless expertise, particularly for these constructing AI apps and brokers. From provisioning to AI integration and scale, we’ve reimagined the developer expertise to take away friction at each step.
Begin within the IDE you’re keen on
The journey begins in Visible Studio Code—the chief in built-in improvement environments (IDEs) amongst builders—by a mile. With our PostgreSQL extension for Visible Studio Code, builders can now provision safe, totally managed PostgreSQL cases on Azure instantly from the IDE. No portal hopping or guide setup. Just some clicks, and your database is able to go together with built-in help for Entra ID authentication and Azure Monitor.
From there, GitHub Copilot turns into your clever assistant. It understands your PostgreSQL schema and helps you write, optimize, and debug SQL queries utilizing pure language. Whether or not you’re becoming a member of tables, creating indexes, or exploring efficiency points, Copilot is correct there with you providing expert-level steerage to avoid wasting time and enhance efficiency.
Entry in-database intelligence for smarter, quicker apps
As soon as your database is stay, you’re only a question away from infusing AI into your utility. Azure Database for PostgreSQL now helps seamless integration with Microsoft Foundry, enabling builders to invoke pre-provisioned giant language fashions (LLMs) in SQL. You possibly can generate embeddings, classify textual content, or carry out semantic search with out leaving the database.
For purposes that depend on relevance and velocity, our DiskANN vector indexing delivers high-performance similarity search. Mixed with semantic rating, your queries return extra correct outcomes, quicker. That is ultimate for powering clever brokers, suggestions, and pure language interfaces.
Construct clever brokers with Microsoft Foundry
Once you’re able to construct AI brokers, Microsoft Foundry’s native PostgreSQL integration makes it straightforward. Utilizing the brand new Mannequin Context Protocol (MCP) server for PostgreSQL, builders can join PostgreSQL on to Foundry’s agent framework with a number of clicks and permissions. This enables brokers to motive over your knowledge, invoke LLMs, and act on insights. And, in fact, that is all backed by Azure’s enterprise-grade safety and governance.
It’s a robust mixture: PostgreSQL’s structured knowledge, Foundry’s orchestration, and Azure’s AI fashions working collectively to ship clever, context-aware purposes.
Clever purposes thrive on contemporary insights. With Azure Database for PostgreSQL, you may mirror your operational knowledge into Microsoft Cloth for real-time analytics with out impacting efficiency. Alternatively, we’ve additionally enabled help for Parquet by way of the Azure Storage Extension, letting prospects instantly learn from and write to Parquet recordsdata saved in Azure Storage from their Postgres databases, utilizing SQL instructions.
This implies quicker time to perception, fewer shifting components, and extra time spent constructing.
Efficiency and scale that grows with you
All this intelligence is meaningless if the database isn’t safe and performant. As such, we’ve continued to innovate to unlock higher efficiency and scale to satisfy the wants of even essentially the most demanding, hypergrowth AI workloads. With PostgreSQL 18 now usually accessible on Azure, you get quicker I/O, improved vacuuming, and smarter question planning. Our new V6 compute SKUs ship larger throughput and decrease latency, whereas Elastic Clusters allow horizontal scaling for multi-tenant and high-volume workloads.
Whether or not you’re constructing a startup MVP or scaling a world AI platform, Azure Database for PostgreSQL is able to develop with you. Our prospects have already been using these new capabilities to construct aggressive benefit in industries from pharma to finance.
Actual-world AI on Azure: How Nasdaq reinvented governance with PostgreSQL
When folks consider Nasdaq, they image buying and selling flooring and monetary knowledge shifting at lightning velocity. However behind the scenes, Nasdaq additionally manages board governance for 1000’s of organizations, together with practically half of the Fortune 500. At Ignite, Nasdaq shared how they modernized their Boardvantage platform utilizing Azure Database for PostgreSQL and Microsoft Foundry.
Their purpose: introduce AI to assist administrators navigate 500-page board packets and extract insights, with out compromising safety or compliance.
The end result? A governance platform that makes use of AI to summarize assembly minutes, flag anomalies, and floor related choices whereas preserving every buyer’s knowledge remoted and guarded.
Wanting forward: Azure HorizonDB and the way forward for clever apps
At Ignite, we additionally launched Azure HorizonDB, a brand new, totally managed PostgreSQL-compatible service constructed for AI-native workloads. With scale-out compute, sub-millisecond latency, and built-in AI options, Azure HorizonDB represents the way forward for cloud databases. Whereas the service is at the moment in personal preview, it’s a glimpse of what’s coming.
The longer term is open, clever, and constructed on Azure
At Microsoft, our mission is to supply prospects databases geared up for next-generation improvement, whether or not they be SQL, NoSQL, relational, or open supply. As PostgreSQL continues to face out as a platform for innovation, it’s now primed for clever purposes and brokers as a consequence of Microsoft’s continued help and repair enhancements. Whether or not you’re a startup constructing your first AI characteristic or an enterprise modernizing mission-critical techniques, Azure provides you the instruments to maneuver quicker, construct smarter, and scale confidently.
The way forward for clever purposes will likely be written in Postgres, and we’re thrilled to construct it along with you on Azure.
Begin right this moment
1Most builders—greater than 80%—now use AI instruments of their workflow.
2PostgreSQL is chosen by 78.6% of builders which might be constructing AI and real-time purposes.