SQL Chatter Project (Azure OpenAI Version)
This project demonstrates how to use OpenAI to interact with a relational SQL database using natural language, eliminating the need for SQL queries by the end user. There is an app connected to an Azure SQL database and Azure OpenAI service, which converts natural language inputs into SQL queries.
This study covers the setup of the database and OpenAI service, the architecture of the app, and the process of configuring the AI model to understand the database schema and generate accurate SQL queries.
✍️ Prerequisites
❗Before beginning this exercise, it is essential to have an active Azure subscription with Azure OpenAI. To gain access to the Azure OpenAI service, you can request access through the following link: Request Access to Azure OpenAI Service.
For the development tools, ensure you have the following installed:
If you do not have an active GitHub Copilot licence, you can sign up for trial here.
For IDE extensions,
-
If you use Visual Studio Code, install Visual Studio Code Copilot Extension.
-
If you use Visual Studio, install Visual Studio Copilot Extension.
🗒️ Guide
You can follow the step by step instructions to complete this excercise:
Please continue to next step: 1. Clone the Repository.
💡 Hint
You can ask questions to Github Copilot about the code snippets in the solution and you can change the source code.