Ever wished you could just ask your database questions in plain English and get results instantly? Well, now you can! Chat with MySQL is an AI-powered Streamlit app that lets you query your database effortlessly—no SQL expertise required!
🔎 Ask a question → Get SQL → See instant results!
🔥 AI-Powered Querying – Just type your question, and our AI will generate SQL for you!
⚡ Real-Time Data Retrieval – Connect to your MySQL database and get live insights!
🎨 Sleek & Modern UI – Enjoy a beautifully designed dark-themed interface.
🧠 Context-Aware Conversations – Chat history keeps track of your queries for smarter responses.
🔐 Secure API Handling – Uses .env for secure key storage.
✔ Python 3.8+ installed
✔ MySQL Database with connection credentials
✔ GROQ API Key for AI-powered magic
1️⃣ Clone this repo
git clone https://github.com/your-repo/chat-with-mysql.git
cd chat-with-mysql2️⃣ Install dependencies
pip install -r requirements.txt3️⃣ Run the app! 🚀
python -m streamlit run app.py1️⃣ Connect to your MySQL database 🔗
2️⃣ Enter your GROQ API key 🔑
- use the following link to generate your api key: https://console.groq.com/keys
3️⃣ Ask questions like:
- "What are the top 5 customers by total orders?"
- "Show me the monthly sales trends."
- "List all products with low inventory."
4️⃣ See the AI-generated SQL & live results! 📊
✅ No SQL? No Problem! – AI converts natural language into SQL instantly.
✅ Save Time & Effort – No more manual query writing.
✅ Powerful Analytics – Turn raw data into actionable insights fast.
- Streamlit – Fast, interactive UI
- LangChain – AI-driven SQL generation
- GROQ AI – Natural language processing
- MySQL – The powerhouse database
- Python – Because Python rocks! 🐍
This project is licensed under the MIT License.
🚀 Ready to supercharge your database queries? Give it a try now! 🔥