msalemor/adventureworks-viewer-ai

A demo application to showcase adding intelligence to an application with different levels of complexity.

Adventureworks-AI-Viewer

Overview

A demo application to showcase adding intelligence to an application at different levels of complexity.

Architecture

graph LR;
  A((User))<-->F(Frontend)
  F<-->B(Backend)
  B<--GptBot-->O(GPTBot)
  B<--SQLBot-->SQL(Sqbot)
  B<-->RAG
  B<--Assistants API Bot-->Asst(Assistants API Bot)
  B<--MultiagentBot-->M(Multiagent Bot<br/>Proxy Agent<br/>Semantic Processing)
  M<--Other or<br/>Unknown<br/>Intent-->O
  M<--SQL Scripts<br/>Intent-->SQL
  M<--Charts<br/>Intent-->Asst
  M<--RAG<br/>Intent-->RAG

Loading

Application Options

Selection	Description
No AI	A user can click on the icons to show the data on the table on the grid in the UI.
Chatbot	A user can ask questions related to top customers and products.
RAG	A user can ask questions about product information.
Sqlbot	A user can ask the system to generate SQL statement. The SQL statements are then executed and presented on the grid in the UI.
Assistants API Bot	A user can ask the system to perform complex data analysis related to top customers and top products and generate bars and charts.
Multiagent Bot	This Bot will decide which agent to call (Chatbot, SQLbot or Assistant Bot based on the user's intent and will respond accordingly.

Requirements

Database

This app leverages the SQL Adventurework database data. However, additional views need to be deployed. You will need to:

• Deploy Azure SQL Database with AdventuresWorks to Azure

• Execute the scripts at: src/database/views_script.sql to add the supporting views

Backend - Python

• Python 3.11
• openai==1.16.1
• fastapi==0.110.1
• uvicorn[standard]==0.29.0
• pymssql==2.2.11
• pillow==10.3.0

Backend - C#

• .NET 8
• Packages:
  • Azure OpenAI
  • Azure Assistants API
  • Dotnet.Env

Frontend - React

• React
• Tailwind CSS
• react-data-grid
• react-icons
• react-loader-spinner
• react-markdown

Debugging - Python

• Install the frontend dependencies: cd src/frontend && npm install
• Install the backend dependencies: cd src/backend && pip install -r requirements.txt
• Create or update the environment variable files at: src/backend/.env

DB_HOST=<NAME>.database.windows.net
DB_PORT=1433
DB_USER=<ADMIN_USER>
DB_PASSWORD=<ADMIN_PASSWORD>
DB_DATABASE=<DB_NAME>

OPENAI_FULL_URI=https://<NAME>.openai.azure.com/openai/deployments/gpt4-1106-preview/chat/completions?api-version=2024-02-15-preview
OPENAI_URI=https://<NAME>.openai.azure.com/
OPENAI_KEY=<API_KEY>
OPENAI_GPT_DEPLOYMENT=gpt4-1106-preview
OPENAI_VERSION=2024-02-15-preview
OPENAPI_URL=/openapi.json

• Start the backend: cd src/backend && sh run.sh or cd src/backend && uvicorn main:app --reload
• Start the frontend: cd src/frontend && npm run dev

Debugging - C#

• Install the frontend dependencies: cd src/frontend && npm install
• Install the backend dependencies: cd src/csbackend && dotnet restore
• Create or update the environment variable files at: src/csbackend/.env

DB_HOST=<NAME>.database.windows.net
DB_PORT=1433
DB_USER=<ADMIN_USER>
DB_PASSWORD=<ADMIN_PASSWORD>
DB_DATABASE=<DB_NAME>

OPENAI_FULL_URI=https://<NAME>.openai.azure.com/openai/deployments/gpt4-1106-preview/chat/completions?api-version=2024-02-15-preview
OPENAI_URI=https://<NAME>.openai.azure.com/
OPENAI_KEY=<API_KEY>
OPENAI_GPT_DEPLOYMENT=gpt4-1106-preview
OPENAI_VERSION=2024-02-15-preview
OPENAPI_URL=/openapi.json

• Start the backend: cd src/csbackend or cd src/csbackend && dotnet watch run
• Start the frontend: cd src/frontend && npm run dev

adventureworks-viewer-ai's Issues

AI Search semantic config for RAG option

Using the RAG option, code relies on AISEARCH_SEMANTIC_CONFIG env variable. Is there guidance on how to configure the semantic configuration to add on which index?