iScuela ERP
Enterprise School ERP & AI Orchestration Platform
01 / OVERVIEW
Project Brief
iScuela is a unified, multi-board School ERP system designed to centralize fragmented administration, academic scheduling, fee processing, and internal communication workflows. It integrates advanced constraint-satisfaction heuristic engines and conversational LLM queries.
Operational Fragmentation
Educational institutions across CBSE and UK boards struggle with operational fragmentation. Staff spend hours compiling reports manually from disparate databases, schedule timetables with frequent teacher conflicts, and struggle to manage board-specific terminologies (e.g. Grade/Year, Section/Form) under single-tenant database designs.
Unified Full-Stack Console
We engineered a hybrid Next.js 14 / NestJS system integrating PostgreSQL relational schemas with Firebase Realtime listeners. Crucially, we implemented: 1. Conversational report generation using Google Gemini AI, translating NLP questions into secure read-replica SQL queries on the fly. 2. A five-step conflict-free Timetable Scheduler. 3. Board-specific routing middleware.
Ask Me Anything (NLP Reports)
Intelligent database querying assistant allowing school directors to ask for statistics in natural language.
- Orchestrates Google Gemini API using strict structured JSON schemas.
- Translates conversational prompts into database queries, eliminating manual reporting overhead.
- Generates dynamic visual representations like pie charts, bars, and lists in React.
AI Timetable Generator
Heuristic scheduling solver resolving complex constraints across classes, subject periods, and teachers.
- 5-step setup checking teacher max periods/day and classroom availability.
- Detects and highlights scheduling overlaps before final compilation.
- Prerenders conflict-free timetable matrix panels for every class section.
Real-time Messaging Hub
Real-time chat infrastructure built for principal-teacher-parent communications.
- Synchronized using Firebase Realtime Database for zero-latency chats.
- Features unread counters, DM channels, and media asset exchanges.
- Optimistic UI updates ensure messaging transitions feel instant.
Installment Fee Registry
Transaction processing engine tracking structured student payments.
- Handles dynamic billing installment matrix schedules securely.
- Includes audit trails, invoice generation, and ledger updates.
- Asynchronously compiles downloadable payment receipts via html2pdf.js.
Frontend
- Next.js 14 (App Router)
- TypeScript
- Tailwind CSS
- Radix UI
- ApexCharts
Backend
- Next.js API Routes
- Server Actions
- Firebase Admin SDK
Database
- PostgreSQL
- Prisma ORM
- Firestore
- Firebase Realtime DB
Infrastructure
- Google Gemini AI
- JWT / RBAC Middleware
- SWR Caching
- html2pdf.js
04 / ARCHITECTURE
Design Decisions
Dynamic Route Mappings
Utilized Next.js App Router dynamic route groups like (boards)/[board]/[module] to implement CBSE/UK localization terminology seamlessly.
Relational-Realtime Hybrid DB
Integrated PostgreSQL for relational consistency (fees, student records) and Firebase for live states (real-time chat, indicators).
Role-Based Access Control (RBAC)
Secured API endpoints and layout renders across 7 distinct user scopes (Super-Admin, Principal, Teacher, Student, Parent, Staff, Management).
05 / RETROSPECTIVE
Key Learnings
- Multi-tenancy in App Router requires careful middleware-level board detection and localized cookie configurations.
- Caching static master data (subjects, classes) via SWR prevents redundant database loads on client transitions.
- LLM structured output routing must execute on a read-replica server scope to avoid query injection risks.