MySQL Python Chatbot with GPT-4 and Mistral AI

Welcome to the GitHub repository for our tutorial on building a natural language SQL chatbot using GPT-4! In this project, we will guide you through creating a chatbot capable of interpreting and responding to user queries in natural language, generating SQL queries dynamically, and retrieving results from a MySQL database. The project features a user-friendly interface powered by Streamlit, allowing users of all skill levels to engage effortlessly.

Table of Contents

• Features
• How It Works
• Prerequisites
• Installation
• Usage
• License
• Acknowledgments
• Support

Features

• Natural Language Processing (GPT-4)
• SQL Query Generation
• MySQL Database Integration
• User-Friendly Streamlit GUI
• Python-Based Implementation

How It Works

Our chatbot takes a user's natural language query, translates it into a SQL query utilizing GPT-4, performs the query against a MySQL database, and returns the result back to the user in natural language format. Various stages of data handling and interactions with both OpenAI API and MySQL database occur smoothly within a Streamlit application.

Prerequisites

Before getting started, make sure you meet these prerequisites:

• Python Installed

To verify if Python is already installed, open the terminal and type python --version. If not, download and install the latest version of Python from their official website: https://www.python.org/downloads/.

Installation

Ensure you have Python installed on your machine. Then clone this repository:

git clone [repository-link]
cd [repository-directory]

Install the required packages:

pip install -r requirements.txt

Create your own .env file with the necessary variables, including your OpenAI API key:

OPENAI_API_KEY=[your-openai-api-key]

Usage

To launch the Streamlit app and interact with the chatbot:

streamlit run app.py

License

This project is licensed under the MIT License - see the LICENSE file for details.

Note: This project is intended for educational and research purposes. Please ensure compliance with the terms of use and guidelines of any APIs or services used.

If you find this project helpful, please consider giving it a star!

Support

Have questions? Found bugs? Need help troubleshooting? Feel free to contact me at somanathtk198@gmail.com, or submit an issue here on GitHub.

Please remember that this project is meant for educational and research purposes, so kindly comply with the terms of service and guidelines when using any related APIs or services. Happy coding! 🚀👨‍💻🤖