We are thrilled to announce the general availability of the azure_ai extension on Azure Database for PostgreSQL. The azure_ai extension allows developers to seamlessly integrate Azure AI services from within their database using SQL queries. In conjunction with vector data this simplifies building Gen AI applications on Azure Database for PostgreSQL.
Features and Capabilities
With the azure_ai extension, you can now access Azure OpenAI, Azure AI Language services, Azure Translation and Azure Machine learning services with simple function calls from within SQL.
The azure_ai extension enables
- Generation of embeddings with embedding models of creating embeddings with dimensions ranging from 384 to 3072. Embeddings can be generated as a scalar single embedding or as a batch for a set of them. Along with native vector data type using vector extension, embeddings can be generated as data is inserted or updated.
- Calling into Azure AI Language services to perform summarization, sentiment analysis , Key phrase extraction or PII detection on your data.
- Real-time text translation within your database with Azure AI translator simplifies building multi-lingual applications.
- Real-time predictions enable many scenarios such as fraud detection, product recommendations, predictive maintenance or predictive healthcare. You can invoke custom trained models or pre-trained models from Azure Machine learning catalog that are hosted on online endpoints. Online inferencing endpoints are a highly scalable way to operationalize models for real-time low latency requests with features such as auto-scale and rich monitoring and debugging support.
Upgrade the Azure AI extension
If you have installed the azure_ai extension a while ago, you can compare the currently installed version to the newest version allowed by using the SQL command and upgrade it to the latest version
--check the currently installed and the latest version
SELECT * FROM pg_available_extensions
WHERE name = 'azure_ai'
-- Issue an update if the installed version isn't the latest version
ALTER EXTENSION azure_ai UPDATE;Getting Started
To learn more about the azure_ai extension, and how it simplifies building GenAI applications on, visit our documentation below:
- 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.