We explore LlamaIndex’s SQLAutoVectorQueryEngine in this repo. We introduce a national park travel plan use case, where we need to do structured analysis through SQL database, semantic search through three YouTube videos, and the combination of queries over structured and unstructured data.
Please refer to my Medium article Querying Both Structured and Unstructured Data with LlamaIndex and OpenAI for details.
python -m venv venv
.\venv\Scripts\activate
pip install -r requirements.txt
Add .env file at the project root and replace placeholder with your OpenAI API key:
OPENAI_API_KEY=<YOUR-API-KEY>
Run the app by kicking off this command:
python .\national-parks.py