LLM Application that returns SQL data from english prompts

Python 3.11 based LLM app that creates a SQL lite database, stores records into it.

Uses Google Gemini API to retrieve data from the database using english prompts from the user.

The app displays the sql data to users on a streamlit UI.

Installation

Use the package manager pip to install the packages. Run the setup file setup.sh to create .env file.

The setup file also installs the requirements from requirements.txt file.

sh setup.sh

Environmental Variables

Below environment variables need to be saved in a .env file

GOOGLE_API_KEY="your key here"

Deploy

python3 sqlLite.py
streamlit gemini.py

Thanks

Free Code Camp

Google Gemini

Streamlit