From GitHub Copilot AI help to built-in mannequin administration, Azure helps devs and enterprises unlock the total potential of PostgreSQL.
We’re nearly a century faraway from when a bunch of pc scientists at Dartmouth School coined the time period “Synthetic Intelligence.” Within the 75-year span, AI has develop into frequent vernacular, making inroads from imagined to mainstream. At present, 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 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 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 positive factors and it’s altering expectations for developer expertise.
PostgreSQL has emerged as a best choice amongst builders and is turning into the default start line for a lot of new purposes and tasks. Favored by builders for its reliability, extensibility, and fast innovation, 2PostgreSQL is chosen by 78.6% of builders which are constructing AI and real-time purposes.
PostgreSQL on Azure meets the second
Deciding on the suitable ecosystem is important to help your AI and agentic aspirations, and we’ve made nice strides in bolstering our PostgreSQL managed companies to fulfill the wants of right now’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 venture, with greater than 500 commits within the newest launch. We’re constantly innovating to make PostgreSQL the perfect database for constructing clever purposes, and Azure the perfect 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 the whole lot from small apps and brokers to AI-powered, mission-critical methods, and something in between.
A frictionless and clever developer expertise
Constructing clever purposes ought to really feel intuitive, not intimidating. The Microsoft crew 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, absolutely managed PostgreSQL cases on Azure immediately from the IDE. No portal hopping or guide setup. Only a few 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 steering to save lots of time and enhance efficiency.
Entry in-database intelligence for smarter, sooner apps
As soon as your database is stay, 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 purposes that depend on relevance and pace, our DiskANN vector indexing delivers high-performance similarity search. Mixed with semantic rating, your queries return extra correct outcomes, sooner. That is preferrred for powering clever brokers, suggestions, and pure language interfaces.
Construct clever brokers with Microsoft Foundry
Whenever 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 enables brokers to motive over your knowledge, invoke LLMs, and act on insights. And, after all, that is all backed by Azure’s enterprise-grade safety and governance.
It’s a strong 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’ll be able to 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 immediately learn from and write to Parquet recordsdata saved in Azure Storage from their Postgres databases, utilizing SQL instructions.
This implies sooner 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 fulfill the wants of even essentially the most demanding, hypergrowth AI workloads. With PostgreSQL 18 now usually accessible 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 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 individuals consider Nasdaq, they image buying and selling flooring and monetary knowledge shifting at lightning pace. However behind the scenes, Nasdaq additionally manages board governance for hundreds 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 aim: introduce AI to assist administrators navigate 500-page board packets and extract insights, with out compromising safety or compliance.
The consequence? A governance platform that makes use of AI to summarize assembly minutes, flag anomalies, and floor related choices whereas retaining every buyer’s knowledge remoted and guarded.
Trying forward: Azure HorizonDB and the way forward for clever apps
At Ignite, we additionally launched Azure HorizonDB, a brand new, absolutely 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 prospects 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 purposes and brokers as a result of Microsoft’s continued help and repair enhancements. Whether or not you’re a startup constructing your first AI function or an enterprise modernizing mission-critical methods, Azure offers you the instruments to maneuver sooner, construct smarter, and scale confidently.
The way forward for clever purposes shall be written in Postgres, and we’re thrilled to construct it along with you on Azure.
Begin right now
1Most builders—greater than 80%—now use AI instruments of their workflow.
2PostgreSQL is chosen by 78.6% of builders which are constructing AI and real-time purposes.