PostgreSQL on Azure supercharged for AI

From GitHub Copilot AI assistance to built-in exemplary management, Azure is helping devs and enterprises unlock the afloat imaginable of PostgreSQL.

We are astir a period removed from erstwhile a radical of machine scientists astatine Dartmouth College coined the word “Artificial Intelligence.” In the 75-year span, AI has go communal vernacular, making inroads from imagined to mainstream. Today, we spot full industries being disrupted and full ecosystems revolutionized by AI. To support up, the mode developers enactment and the tools they usage person had to evolve. Every developer present needs to beryllium an AI developer, and each system—from compute and retention to the information layer—now needs to beryllium AI ready.

The database reimagined

New AI applications necessitate databases that are not lone reliable, extensible, and secure, but besides AI-ready. In parallel, the mode developers physique bundle is being reshaped by AI. ¹Most developers—more than 80%—now usage AI tools successful their workflow. This has led to notable productivity gains and it’s changing expectations for developer experience.

PostgreSQL has emerged arsenic a apical prime among developers and is becoming the default starting constituent for galore caller applications and projects. Favored by developers for its reliability, extensibility, and accelerated innovation, ²PostgreSQL is chosen by 78.6% of developers that are gathering AI and real-time applications.

PostgreSQL connected Azure meets the moment

Selecting the close ecosystem is captious to enactment your AI and agentic aspirations, and we’ve made large strides successful bolstering our PostgreSQL managed services to conscionable the needs of today’s developer. At Microsoft, we’ve embraced PostgreSQL not conscionable arsenic a product, but arsenic a community. We’re arrogant to beryllium 1 of the apical contributors to the PostgreSQL open-source project, with much than 500 commits successful the latest release. We are continuously innovating to marque PostgreSQL the champion database for gathering intelligent applications, and Azure the champion spot to tally them.

The existing Azure Database for PostgreSQL continues to cater to lift-and-shift and caller open-source workloads with improved show and experience, portion the new Azure HorizonDB, introduced astatine Ignite, targets the aboriginal by offering a PostgreSQL-compatible cloud work built for scale-out and ultra-low latency. Together, they presumption Azure to enactment developers gathering everything from tiny apps and agents to AI-powered, mission-critical systems, and thing successful between.

A frictionless and intelligent developer experience

Building intelligent applications should consciousness intuitive, not intimidating. The Microsoft squad has invested successful making Azure Database for PostgreSQL a frictionless experience, particularly for those gathering AI apps and agents. From provisioning to AI integration and scale, we’ve reimagined the developer acquisition to region friction astatine each step.

Start successful the IDE you love

The travel begins successful Visual Studio Code—the person successful integrated improvement environments (IDEs) among developers—by a mile. With our PostgreSQL hold for Visual Studio Code, developers tin present proviso secure, afloat managed PostgreSQL instances connected Azure straight from the IDE. No portal hopping oregon manual setup. Just a fewer clicks, and your database is acceptable to spell with built-in enactment for Entra ID authentication and Azure Monitor.

From there, GitHub Copilot becomes your intelligent assistant. It understands your PostgreSQL schema and helps you write, optimize, and debug SQL queries utilizing earthy language. Whether you’re joining tables, creating indexes, oregon exploring show issues, Copilot is close determination with you offering expert-level guidance to prevention clip and amended performance.

Access in-database quality for smarter, faster apps

Once your database is live, you’re conscionable a query distant from infusing AI into your application. Azure Database for PostgreSQL present supports seamless integration with Microsoft Foundry, enabling developers to invoke pre-provisioned ample connection models (LLMs) successful SQL. You tin make embeddings, classify text, oregon execute semantic hunt without leaving the database.

For applications that trust connected relevance and speed, our DiskANN vector indexing delivers high-performance similarity search. Combined with semantic ranking, your queries instrumentality much close results, faster. This is perfect for powering intelligent agents, recommendations, and earthy connection interfaces.

Build intelligent agents with Microsoft Foundry

When you’re acceptable to physique AI agents, Microsoft Foundry’s autochthonal PostgreSQL integration makes it easy. Using the caller Model Context Protocol (MCP) server for PostgreSQL, developers tin link PostgreSQL straight to Foundry’s cause model with a fewer clicks and permissions. This allows agents to crushed implicit your data, invoke LLMs, and enactment connected insights. And, of course, this is each backed by Azure’s enterprise-grade information and governance.

It’s a almighty combination: PostgreSQL’s structured data, Foundry’s orchestration, and Azure’s AI models moving unneurotic to present intelligent, context-aware applications.

Intelligent applications thrive connected caller insights. With Azure Database for PostgreSQL, you tin reflector your operational information into Microsoft Fabric for real-time analytics without impacting performance. Alternatively, we’ve besides enabled enactment for Parquet via the Azure Storage Extension, letting customers straight work from and constitute to Parquet files stored successful Azure Storage from their Postgres databases, utilizing SQL commands.

This means faster clip to insight, less moving parts, and much clip spent building.

Performance and standard that grows with you

All this quality is meaningless if the database isn’t unafraid and performant. As such, we’ve continued to innovate to unlock amended show and standard to conscionable the needs of adjacent the astir demanding, hypergrowth AI workloads. With PostgreSQL 18 present mostly disposable connected Azure, you get faster I/O, improved vacuuming, and smarter query planning. Our caller V6 compute SKUs present higher throughput and little latency, portion Elastic Clusters alteration horizontal scaling for multi-tenant and high-volume workloads.

Whether you’re gathering a startup MVP oregon scaling a planetary AI platform, Azure Database for PostgreSQL is acceptable to turn with you. Our customers person already been utilizing these caller capabilities to physique competitory vantage successful industries from pharma to finance.

Real-world AI connected Azure: How Nasdaq reinvented governance with PostgreSQL

Looking ahead: Azure HorizonDB and the aboriginal of intelligent apps

At Ignite, we besides introduced Azure HorizonDB, a new, afloat managed PostgreSQL-compatible work built for AI-native workloads. With scale-out compute, sub-millisecond latency, and built-in AI features, Azure HorizonDB represents the aboriginal of unreality databases. While the work is presently successful backstage preview, it’s a glimpse of what’s coming.

The aboriginal is open, intelligent, and built connected Azure

At Microsoft, our ngo is to connection customers databases equipped for next-generation development, whether they beryllium SQL, NoSQL, relational, oregon unfastened source. As PostgreSQL continues to basal retired arsenic a level for innovation, it’s present primed for intelligent applications and agents owed to Microsoft’s continued enactment and work enhancements. Whether you’re a startup gathering your archetypal AI diagnostic oregon an endeavor modernizing mission-critical systems, Azure gives you the tools to determination faster, physique smarter, and standard confidently.

The aboriginal of intelligent applications volition beryllium written successful Postgres, and we’re thrilled to physique it unneurotic with you connected Azure.

Start today

• Try the PostgreSQL hold for VS Code
• Learn however to physique AI agents with Azure Database for PostgreSQL

---

¹Most developers—more than 80%—now usage AI tools successful their workflow.

²PostgreSQL is chosen by 78.6% of developers that are gathering AI and real-time applications.