A comprehensive AI-powered job application tracking and career management platform built with Next.js, TypeScript, Supabase, and Google Gemini AI.
Note: This application supports both cloud (Supabase) and local (SQLite) storage modes for flexibility and offline usage.
- Job Application Tracking: Manage applications with status tracking, notes, and filters
- Skill Development: Visualize skill gaps with radar charts and AI recommendations
- Smart To-Do Management: Context-aware tasks with priority levels and due dates
- AI Career Assistant: Chat interface powered by Google Gemini for personalized advice
- Email Integration: Import and parse job application emails from Gmail
- Local Storage Mode: SQLite-based local database for offline usage
- Resume enhancement and optimization
- Cover letter writing assistance
- Interview preparation and practice questions
- Job description analysis
- Skill gap identification and parsing from resumes
- Networking message templates
- Salary negotiation guidance
- Application status dashboard with charts
- Skill progression tracking
- Weekly activity monitoring
- Response rate analytics
- Next.js 15 with App Router
- React 18 with TypeScript
- Tailwind CSS for styling
- shadcn/ui component library
- Recharts for data visualization
- Lucide React for icons
- Next.js API Routes for serverless functions
- Supabase for database and authentication (cloud mode)
- SQLite / better-sqlite3 for local storage mode
- PostgreSQL (via Supabase)
- Google Gemini API for natural language processing
- gemini-2.5-flash model for fast and accurate responses
- Context-aware responses
- Personalized career advice
- Node.js 18+ and npm/pnpm
- Supabase project (for cloud mode)
- Google Gemini API key
- Gmail API credentials (for email import feature)
- Clone the repository
git clone <repository-url>
cd ai-job-assistant- Install dependencies
npm install
# or
pnpm install- Set up environment variables
Create a
.env.localfile in the root directory:
# AI Integration
GEMINI_API_KEY="your-google-gemini-api-key"
# Supabase Configuration (cloud mode)
NEXT_PUBLIC_SUPABASE_URL="your-supabase-project-url"
NEXT_PUBLIC_SUPABASE_ANON_KEY="your-supabase-anon-key"
# Gmail API (email import feature)
GOOGLE_CLIENT_ID="your-google-client-id"
GOOGLE_CLIENT_SECRET="your-google-client-secret"
GOOGLE_REDIRECT_URI="http://localhost:3000/api/email/callback"
# Local Mode (optional - uses local.db SQLite file)
# No additional env vars needed- Run the development server
npm run dev
# or
pnpm devOpen http://localhost:3000 to see the application.
ai-job-search-companion/
├── app/ # Next.js App Router
│ ├── api/ # API routes
│ │ ├── applications/ # Job applications CRUD
│ │ ├── skills/ # Skills management
│ │ ├── tasks/ # Task management
│ │ ├── ai/ # AI chat integration
│ │ ├── email/ # Email import & parsing
│ │ └── local/ # Local storage mode APIs
│ ├── dashboard/ # Main application pages
│ │ ├── applications/ # Applications management
│ │ ├── skills/ # Skill visualization
│ │ ├── todos/ # Task management
│ │ ├── ai-assistant/ # AI chat interface
│ │ └── email-import/ # Gmail import page
│ ├── layout.tsx # Root layout
│ └── page.tsx # Landing/login page
├── components/ # Reusable components
│ ├── ui/ # shadcn/ui components
│ ├── app-sidebar.tsx # Navigation sidebar
│ ├── login-form.tsx # Authentication form
│ ├── drag-drop-tasks.tsx # Draggable task list
│ └── auth-provider.tsx # Authentication context
├── lib/ # Utility libraries
│ ├── types.ts # TypeScript interfaces & type guards
│ ├── auth.ts # Authentication utilities
│ ├── gemini.ts # AI integration (Google Gemini)
│ ├── email-parser.ts # Email parsing utilities
│ ├── local-db.ts # SQLite local database layer
│ ├── supabase.ts # Supabase client
│ └── utils.ts # General utility functions
├── tests/ # Test files (*test.ts)
├── local.db # SQLite database (local mode)
├── supabase-schema.sql # Database schema for Supabase
└── package.json # Dependencies & scripts
- Real-time application statistics
- Visual charts for status tracking
- Quick AI assistant access
- Upcoming task reminders
- Full CRUD operations for job applications
- Status filtering and search functionality
- Notes and timeline tracking
- Export capabilities
- Interactive radar charts comparing current vs target skills
- AI-powered skill recommendations
- AI Skill Parsing: Automatically extract skills from resume text
- Learning resource suggestions
- Progress tracking over time
- Context-aware task creation
- Priority-based organization
- Due date tracking and reminders
- AI-suggested tasks based on applications
- Drag-and-drop reordering
- Natural language processing with Google Gemini
- Context-aware responses
- Prompt suggestions for common scenarios
- Conversation history and analytics
- Connect Gmail account via OAuth
- Automatically parse job application emails
- Extract company names, positions, and dates
- Bulk import applications into tracker
- SQLite-based local database (
local.db) - Works offline without Supabase
- Seamless fallback when cloud credentials unavailable
- Same API interface as cloud mode
POST /api/auth/login- User loginPOST /api/auth/register- User registrationPOST /api/auth/logout- User logout
GET /api/applications- Fetch user applicationsPOST /api/applications- Create new applicationPUT /api/applications- Update applicationDELETE /api/applications- Delete application
GET /api/skills- Fetch user skillsPOST /api/skills- Add new skillPUT /api/skills- Update skill proficiencyPOST /api/local/skills/parse- AI-powered skill extraction from text
GET /api/tasks- Fetch user tasksPOST /api/tasks- Create new taskPUT /api/tasks- Update task statusGET /api/local/tasks- Local mode task operations
POST /api/ai/chat- Send message to AI assistantGET /api/ai/suggestions- Get AI-powered suggestions
GET /api/email- Initiate Gmail OAuth flowGET /api/email/callback- OAuth callback handlerGET /api/email/applications- Fetch parsed application emails
The application uses a Supabase (PostgreSQL) database. See supabase-schema.sql for the full schema. Main tables include:
applications- Job application trackingskills- User skills and proficiency levelstasks- To-do items with context and prioritiesnotifications- System notifications
- Uses
local.dbfile in the project root - Same data model as cloud mode
- Automatically created on first run
- No authentication required
- Supabase Auth for user management
- Row Level Security (RLS) policies
- Environment variable protection
- Rate limiting on API endpoints
- OAuth 2.0 for Gmail integration
- JWT token validation for API requests
Run tests with:
npm test
# or
pnpm test- Authentication (
lib/auth.test.ts) - Login, token validation, user management - Components (
components/*test.tsx) - UI component rendering and interactions - Types (
lib/types.test.ts) - Type guards and validation functions - Utils (
lib/utils.test.ts) - Utility function testing - Local DB (
lib/local-db.test.ts) - SQLite database operations
- Server-side rendering with Next.js
- Image optimization
- Code splitting and lazy loading
- Database indexing
- Caching strategies
- Optimized bundle size
- Connect your GitHub repository to Vercel
- Set environment variables in Vercel dashboard
- Deploy automatically on push to main branch
- Build the application:
npm run build - Set up production database
- Configure environment variables
- Deploy to your hosting platform
- Fork the repository
- Create a feature branch:
git checkout -b feature/new-feature - Commit changes:
git commit -am 'Add new feature' - Push to branch:
git push origin feature/new-feature - Submit a pull request
This project is licensed under the MIT License - see the LICENSE file for details.
For support and questions:
- Create an issue on GitHub
- Check the documentation
- Review the FAQ section
- Mobile app development
- Advanced analytics dashboard
- Integration with job boards (LinkedIn, Indeed)
- Team collaboration features
- Advanced AI coaching
- Resume parsing and optimization
- Interview scheduling integration
- Salary benchmarking tools
- AI-powered job recommendations
- v1.0.0 - Initial release with core features
- v1.1.0 - Enhanced AI capabilities
- v1.2.0 - Mobile responsiveness improvements
- v2.0.0 - Advanced analytics and reporting
- v2.1.0 - Email integration and local storage mode
- v2.1.1 - Comprehensive test coverage