CareerPath

CareerPath is an internship management platform with AI-based recommendations.

It includes:

• Backend API (Node.js + Express + MySQL)
• Frontend web app (React + Vite)
• AI ranking and preview generation through Ollama (qwen2.5-coder:7b)

Tech Stack

• Node.js, Express
• React, Vite
• MySQL
• Ollama

Repository Structure

• backend/ API server
• frontend/ React client
• internship_db.sql database schema/data script
• screenshots/ UI screenshots

Prerequisites

Install before setup:

• Node.js 18+
• npm
• MySQL (running on port 3306)
• Ollama

1) Database Setup

Run these commands from the repository root (careerpath):

mysql -u root -p --port=3306 -e "CREATE DATABASE IF NOT EXISTS internship_db;"
mysql -u root -p --port=3306 internship_db < "internship_db.sql"

2) Ollama Setup

ollama pull qwen2.5-coder:7b
ollama serve

Optional verification:

ollama list

3) Backend Setup

cd backend
npm install
Copy-Item .env.example .env

Update backend/.env with your values (minimum required):

• DB_HOST=localhost
• DB_PORT=3306
• DB_NAME=internship_db
• DB_USER=root
• DB_PASSWORD=...
• JWT_SECRET=...
• LLM_BASE_URL=http://localhost:11434
• LLM_MODEL=qwen2.5-coder:7b

4) Frontend Setup

cd ..\frontend
npm install
"VITE_API_URL=http://localhost:3000/api" | Out-File -Encoding ascii .env

5) Run the Project

Start backend (Terminal 1):

cd backend
npm run dev

Start frontend (Terminal 2):

cd frontend
npm run dev

Access:

• Frontend: http://localhost:5173
• Backend API base: http://localhost:3000/api
• Health check: http://localhost:3000/api/health

Useful Commands

Backend (from backend/):

npm test
npm run migrate
npm run seed
node scripts/createMissingProfiles.js
node scripts/createMissingStudents.js

Frontend (from frontend/):

npm run build
npm run preview
npm run lint

API Modules

Main route groups:

• /api/auth
• /api/students
• /api/companies
• /api/supervisors
• /api/admin
• /api/internships
• /api/applications
• /api/evaluations
• /api/recommendations
• /api/notifications

Screenshots

Student Recommendations

Student Applications

Company Recommendations Overview

Company Candidate Matches