Skip to main content
backgroundImage
Azure-Samples/rag-postgres-openai-python
RAG chat on PostgreSQL
azd init -t rag-postgres-openai-python
Use the Azure Developer CLI (azd) to deploy this template. Learn more about azd open
About this templateCreates a chat frontend with an API backend using OpenAI chat models to answer questions about rows in a PostgreSQL database.
app screenshot
Prerequisites
New to Azure?Get $200 in credits when you sign up for an Azure free account. Credits can be used on most Azure services, including for AI app templates. Try Azure for free open
checkMarkSign up for an Azure account.
checkMarkRequest access to Azure OpenAI Service.
checkMarkHave the Azure permissions required to deploy.
checkMarkAzure Developer CLI (azd)
checkMarkDocker
checkMarkGit
checkMarkNode.js 18+
checkMarkPython 3.10+
checkMarkPostgreSQL 14+
checkMarkpgvector
Architecture
architecture diagram
Resources includedThis template deploys the following resources.
Resource
Description
Category
Azure Database for PostgreSQL
Azure Database for PostgreSQLAzure
Fully managed, intelligent, and scalable PostgreSQL.Databases
Azure Container Apps
Azure Container AppsAzure
Build and deploy modern apps and microservices using serverless containers.Compute
Azure OpenAI Service
Azure OpenAI ServiceAzure
Apply advanced coding and language models to a variety of use cases.AI + Machine Learning
Azure Monitor
Azure MonitorAzure
Full observability into your applications, infrastructure, and network.DevOps
Summary
PersonCreated by
Azure Content Team
CalendarLast updated
CodeLanguages
Python, TypeScript
CubeModels
GPT-4 Omni mini, Code Llama
TagTags
Guided Search
Azure Monitor
Azure Container Apps
Azure OpenAI Service
Azure Database for PostgreSQL
GPT-4 Omni mini
Code Llama
Calculator
Pricing calculatoropen
You're only charged when you deploy to Azure. You can try this template locally or in VS Code for the Web at no cost.