Prerequisites

• Ensure Python version is 3.13
• Install all packages in requirements.txt
  • pip install -r requirements.txt
• You need an Azure account with:
  • Azure OpenAI Service
    • Deploy a GPT-4 model
    • Deploy an embedding_ada002 model
  • Azure AI Search (Free tier is enough)
  • Azure SQL database

Initialization

One time set-up

1. Populate the .env file with your credentials connecting to Azure OpenAI models, Azure AI Search and Azure SQL db
2. Create and seed tables (one time only): python init_sql_table.py
3. connect AI search to sql db: python azure_ai_search_connect.py
4. Initialize index, define skillset, run indexer: python setup_azure_ai_search.py

Ask questions about the data

• python concierge_app.py

Example: Recommend some waterproof shoes for hiking