AI-Powered SQL Prep Plan 🚀

An AI-powered platform built with MERN stack + Gemini API to help users prepare for SQL interviews at big tech companies. The platform asks targeted questions and generates a structured SQL preparation plan based on user responses.

Features ✨

• AI-Generated SQL Study Plan: Uses Gemini API to create a personalized preparation strategy.
• MERN Stack: Built with MongoDB, Express.js, React.js, and Node.js.
• JWT Authentication: Ensures secure user authentication.
• Interactive Questions: Asks relevant SQL-related questions to tailor the study plan.

Tech Stack 🛠️

• Frontend: React.js, Tailwind CSS
• Backend: Node.js, Express.js
• Database: MongoDB
• Authentication: JWT (JSON Web Token)
• AI Integration: Gemini API

Installation & Setup ⚙️

1. Clone the Repository

git clone https://github.com/SARVESHYOGI/AI-Powered_SQL_Prep.git
cd AI-Powered_SQL_Prep

2. Install Dependencies

Backend

cd server
npm install

Frontend

cd client
npm install

3. Set Up Environment Variables

Create a .env file in the server directory and add:

PORT=5000
MONGO_URI=your_mongodb_connection_string
JWT_SECRET=your_jwt_secret_key
GOOGLE_API_KEY=your_gemini_api_key

4. Run the Application

Start Backend Server

cd server
npm start

Start Frontend

cd client
npm start

Usage 🚀

1. Sign up/Login using JWT authentication.
2. Answer SQL-related questions.
3. Get an AI-generated SQL preparation plan.
4. Follow the plan to prepare for big tech interviews!

Preview 🖼️

Home Page Login Page Register Page Question Form Generated Form For Submitted Questions Generated 4 week Plan Generated 8 week Plan Dashboard Before Saving Information Dashboard after Saving Information (Plan 3 added) Sidebar

Future Enhancements 🚀

• 📌 Progress Tracking for users.
• 📌 More AI-Generated Insights for SQL concepts.
• 📌 Mock Interview Mode with AI feedback.

Contributing 🤝

Feel free to fork the repository and submit pull requests. Contributions are welcome!

License 📝

This project is licensed under the MIT License.

---

💡 Let's Ace SQL Interviews Together!