🚀 Chat with Your MySQL Database Like a Pro! 🗂️💬

Welcome to the Streamlit Database Querying Tool, a powerful AI-driven application that allows you to interact with your database using natural language! Built with Python and Streamlit, this tool leverages the Mistral AI model to generate SQL queries, display results in tables, and visualize data with interactive Bar and Pie charts.

🔎 Ask a question → Get SQL → See instant results!

Overview

This project enables users to upload SQLite databases or run the app locally with MySQL support. Ask questions in plain English (e.g., "What’s the total spending by customer?"), and the app will handle the rest—generating SQL, showing tables, and creating visualizations.

✨ Features

🔥 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.

📊 Interactive Visualizations - Supports Bar and Pie charts to explore your data.

🔗 Flexible Database Support:

• Online Use: Upload SQLite files directly.
• Local MySQL: Fork and run locally for MySQL connectivity.

---

📥 Installation & Setup

🚀 Prerequisites

✔ Python 3.8+ installed
✔ MySQL Database with connection credentials
✔ Mistral API Key for AI-powered magic

⚙️ Setup Instructions

1️⃣ Clone this repo

git clone https://github.com/omkarjavali/Chat_with_Database.git
cd Chat_with_Database

2️⃣ Install dependencies

pip install -r requirements.txt

3️⃣ Run the app! 🚀

python -m streamlit run app.py

🛠️ How It Works

1️⃣ Connect to your MySQL database 🔗

2️⃣ Enter your Mistral API key 🔑

• use the following link to generate your api key: https://console.mistral.ai/api-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! 📊

🧪 Live Demo

👉 https://chatwithdatabase-1.streamlit.app/

💡 Why Use This?

✅ 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.

🏆 Tech Stack

• Streamlit – Fast, interactive UI
• LangChain – AI-driven SQL generation
• Mistral API – Natural language processing
• MySQL – The powerhouse database
• Python – Because Python rocks! 🐍
• Plotly - For Generating Visualizations

📜 License

This project is licensed under the MIT License.

🚀 Ready to supercharge your database queries? Give it a try now! 🔥