Azure AI Extension Now GA for Azure Database for PostgreSQL

Great news for developers! The azure_ai extension is now officially ready for use (generally available) with Azure Database for PostgreSQL. This extension allows you to directly integrate various Azure AI services within your database using standard SQL queries. This simplifies building next-generation AI-powered applications (Generative AI) directly on your PostgreSQL database.

What can the azure_ai extension do?

• Access Multiple Azure AI Services: Leverage Azure OpenAI, Azure AI Language Services, Azure Translation, and even Azure Machine Learning services - all through simple function calls within your SQL code.
• Generate Embeddings: Create vector representations (embeddings) of your data using various embedding models. These embeddings can be single values or batched for multiple data points. The extension works with the native vector data type provided by the vector extension for PostgreSQL. This allows you to generate embeddings as you insert or update data.
• Azure AI Language Services Integration: Perform tasks like text summarization, sentiment analysis, key phrase extraction, and even PII (Personally Identifiable Information) detection directly on your data within the database.
• Real-time Text Translation: Build multilingual applications with ease using real-time translation powered by Azure AI Translator.
• Real-time Predictions: Make real-time predictions for various scenarios like fraud detection, product recommendations, or even predictive maintenance/healthcare. You can leverage pre-trained models or your own custom models hosted on Azure Machine Learning online endpoints. These endpoints offer features like auto-scaling and comprehensive monitoring/debugging support for optimal performance.

How to Upgrade or Get Started?

If you've already installed the azure_ai extension, you can check and upgrade to the latest version using SQL commands.

For getting started or diving deeper, the provided resources offer comprehensive information:

• Azure AI Extension.
• Azure AI Language Services integration
• Azure AI Text Translation
• Azure AI real-time machine learning scoring.
• Vectors on Azure Database for PostgreSQL
• Generative AI Overview
• To learn even more about our Flexible Server managed service, see the Azure Database for PostgreSQL Flexible Server.
• You can always find the latest features added to Flexible server in this release notes page.

This new extension streamlines the development of Generative AI applications on Azure Database for PostgreSQL.