A repository that showcases the Native Vector Support in Azure SQL Database to perform embeddings and RAG with Azure OpenAI.
Important
Usage of this application requires the Vector Support feature in Azure SQL Database, currently in EAP. See this blog post for more details.
The application is a Minimal API that exposes endpoints to load documents, generate embeddings and save them into the database as Vectors, and perform searches using Vector Search and RAG. Currently, only PDF files are supported. Vectors are saved with Entity Framework Core using the EFCore.SqlServer.VectorSearch library. Embedding and Chat Completion are integrated with Semantic Kernel.
- Create an Azure SQL Database on a server that has the Vector Support feature enabled.
- Execute the Scripts.sql file to create the tables needed by the application.
- Open the appsettings.json file and set the connection string to the database and the other settings required by Azure OpenAI.
- Run the application and start importing your PDF documents.