This is an AI chatbot that is able to answer any question about the information stored in a relational database. The chatbot created is plugged into a Postgres database.
- Streamlit: For an interactive, user-friendly web-based interface.
- OpenAI: The power behind the chatbot's intelligent responses.
- Postgres: The database where all the magic data resides.
β .env
β .gitignore
β app.py
β README.md
β requirements.txt
β
ββββassets
β β dark_theme.py
β β light_theme.py
β β made_by_sdw.py
β β
β ββββ__pycache__
β ...
β
ββββconversation_history
β ...
β
ββββutils
β api_functions.py
β chat_functions.py
β config.py
β database_functions.py
β function_calling_spec.py
β helper_functions.py
β system_prompts.py
β
ββββ__pycache__
...
- Clone this repository.
- Navigate to the directory and install the necessary Python packages with
pip install -r requirements.txt
. - Add your database credentials and OpenAI API key in the .env file.
- After setting up, run the command:
streamlit run app.py
- The chatbot UI will open in your default web browser. Engage and enjoy!
- Ask questions - Post questions related to data stored in the database the chatbot is connected to
- Get answers - Enjoy the structured and dynamic answers the chatbot provides
- Save conversations - Preserve conversations into a markdown file for your future use
Feel free to make pull requests and add your unique spin to this - insights, feedback and suggestions are also welcome too!