AI_Data_Analyst

🧠 AI_Data_Analyst

AI_Data_Analyst is a powerful full-stack web application that empowers users to connect to their MySQL database and interact with it using natural language. Backed by DeepSeek LLM, this tool translates plain English questions into SQL queries and delivers insights, sample data, statistics, and visualizations—all with a user-friendly interface.

---

🚀 Features

• 🔌 Database Connectivity: Securely connect to any MySQL database.
• 🗣️ Natural Language to SQL: Ask questions like “Show me top 5 selling products” and get instant SQL answers.
• 📊 Automatic Visualizations: Generate bar charts, pie charts, and line graphs based on your data.
• 🧾 Descriptive Statistics: Get statistical summaries using Pandas.
• 🔍 Schema & Foreign Keys Viewer: Understand your database structure easily.
• 📄 HTML Report Generator: Export full analysis of your database in beautiful HTML format.
• 🔐 Multi-User Support: Each user accesses only their own schema and data securely.

---

🛠️ Tech Stack

• Backend: Python (Flask)
• Frontend: HTML, CSS, JavaScript
• Database: MySQL
• AI Model: DeepSeek API for LLM
• Data Analysis: Pandas, Matplotlib
• Visualization: Chart.js (or Matplotlib via rendered images)

---

⚙️ Setup Instructions

1. Clone the Repository

git clone https://github.com/ahmedashrafk13/AI_Data_Analyst.git
cd AI_Data_Analyst

2. Install Dependencies

Make sure you have Python 3.8+ installed.

pip install -r requirements.txt

3. Configure Environment

Edit the config.py file and add your DeepSeek API key and base URL:

DEEPSEEK_API_KEY = "your-api-key"
DEEPSEEK_API_URL = "https://api.novita.ai/v3/openai"
DEEPSEEK_MODEL = "meta-llama/llama-3.1-8b-instruct"

4. Run the App

python app.py

Visit http://localhost:5000 in your browser.

---

📬 Contact

Created by Ahmed Ashraf 📧 Email: ahmedashrafk12@gmail.com(mailto:your-email@example.com) 🧠 Project: InsightForge Series

---

📝 License

This project is licensed under the MIT License.

```