Frontend
React 19
Vite
Tailwind CSS v4
React Router v7
TanStack Query
React Hook Form
Zod
Axios
Selected Work
Overview
This is a comprehensive, full-stack educational administration platform designed to streamline the operations of schools and educational institutions. It solves the critical problem of fragmented school management by unifying student enrollments, staff administration, real-time attendance tracking, and financial operations (fee collections) into a single, cohesive dashboard with multi-branch support.
Main Mockup
Dashboard Preview
Placeholder
Tech Stack
Built With a Robust Stack
Backend
Python
FastAPI
Uvicorn
Pydantic
JWT
Argon2
ReportLab
OpenPyXL
Database
PostgreSQL
SQLAlchemy
Alembic
Key Features
Key Features & Core Functionalities
Student & Staff Administration
Complete system for managing student admissions, demographics, grade levels, and staff records.
Financial & Payment Processing
Robust fee structure management and payment processing that automatically generates unique receipt numbers, tracks statuses, and issues digital receipts.
Multi-Branch Data Isolation
A hierarchical structure supporting multiple school branches. Admin users view all data, while branch staff view/modify strictly within their assigned branch.
Automated Reporting
On-demand generation of stylized, downloadable PDF and Excel reports for financial income summaries, payment histories, and student registries.
Attendance & RBAC
Dedicated workflows for logging daily attendance and secure authentication ensuring specific endpoints are protected by administrative roles.
AI Tools Integration
An integrated suite of AI tools built into the frontend interface to assist with automated administrative tasks or data insights.
Architecture & Challenges
Technical Architecture & Complexities
Engineering Complexities
Multi-Tenant Branch Architecture
Handling data isolation across different branches securely. The system dynamically intercepts the JWT token via FastAPI dependency injection, automatically appending branch-specific SQLAlchemy filters to all queries.
Dynamic Report Generation & Streaming
Using ReportLab and OpenPyXL to aggregate multi-table database queries and stream resulting binary buffers directly to the client via StreamingResponse, optimizing memory usage and performance.
Synchronized Type Safety
Zod + React Hook Form maps exactly to FastAPI Pydantic models. This end-to-end type-safe pipeline prevents malformed database entries and provides instant, localized feedback.