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 bunch of pc scientists at Dartmouth Faculty coined the time period “Synthetic Intelligence.” Within the 75-year span, AI has grow to be widespread vernacular, making inroads from imagined to mainstream. In the present day, we see whole industries being disrupted and whole ecosystems revolutionized by AI. To maintain up, the way in which 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 info layer—now must be AI prepared.
The database reimagined
New AI functions require databases that aren’t solely dependable, extensible, and safe, but additionally AI-ready. In parallel, the way in which 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 good points and it’s altering expectations for developer expertise.
PostgreSQL has emerged as a best choice amongst builders and is changing into the default place to begin for a lot of new functions 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 functions.
PostgreSQL on Azure meets the second
Deciding on the proper ecosystem is important to help your AI and agentic aspirations, and we’ve made nice strides in bolstering our PostgreSQL managed providers to fulfill the wants of at this time’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 high contributors to the PostgreSQL open-source undertaking, with greater than 500 commits within the newest launch. We’re repeatedly innovating to make PostgreSQL the most effective database for constructing clever functions, and Azure the most effective place to run them.
The present 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 longer term by providing a PostgreSQL-compatible cloud service constructed for scale-out and ultra-low latency. Collectively, they place Azure to help builders constructing every part from small apps and brokers to AI-powered, mission-critical methods, and something in between.
A frictionless and clever developer expertise
Constructing clever functions ought to really feel intuitive, not intimidating. The Microsoft workforce 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 like
The journey begins in Visible Studio Code—the chief in built-in growth 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 along 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 save lots of time and enhance efficiency.
Entry in-database intelligence for smarter, sooner apps
As soon as your database is dwell, you’re only a question away from infusing AI into your software. Azure Database for PostgreSQL now helps seamless integration with Microsoft Foundry, enabling builders to invoke pre-provisioned giant language fashions (LLMs) in SQL. You may generate embeddings, classify textual content, or carry out semantic search with out leaving the database.
For functions 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, sooner. That is best for powering clever brokers, suggestions, and pure language interfaces.
Construct clever brokers with Microsoft Foundry
While 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 just a few clicks and permissions. This permits brokers to cause over your information, 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 information, Foundry’s orchestration, and Azure’s AI fashions working collectively to ship clever, context-aware functions.
Clever functions thrive on contemporary insights. With Azure Database for PostgreSQL, you’ll be able to mirror your operational information into Microsoft Material for real-time analytics with out impacting efficiency. Alternatively, we’ve additionally enabled help for Parquet by way of the Azure Storage Extension, letting clients instantly learn from and write to Parquet information saved in Azure Storage from their Postgres databases, utilizing SQL instructions.
This implies sooner time to perception, fewer shifting elements, 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 fulfill the wants of even probably the most demanding, hypergrowth AI workloads. With PostgreSQL 18 now typically obtainable on Azure, you get sooner I/O, improved vacuuming, and smarter question planning. Our new V6 compute SKUs ship greater 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 clients 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 individuals consider Nasdaq, they image buying and selling flooring and monetary information shifting at lightning velocity. However behind the scenes, Nasdaq additionally manages board governance for 1000’s of organizations, together with almost 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 selections whereas retaining every buyer’s information 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 present in non-public 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 clients databases outfitted for next-generation growth, 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 functions and brokers on account 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 methods, Azure provides you the instruments to maneuver sooner, construct smarter, and scale confidently.
The way forward for clever functions will probably be written in Postgres, and we’re thrilled to construct it along with you on Azure.
Begin at this time
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 functions.
