Back to Portfolio
SaaS
● Live in productionEsparks Edu — School Management ERP
Multi-tenant school management, from admissions to payroll
Visit Live Site60 data models
6 DB schemas
~27 web modules
21+ mobile screens
Overview
Esparks Edu is a SaaS school management ERP built to unify academics, finance, HR, and daily operations in one platform. eSparks IT Solutions developed it with Next.js 16, React 19, PostgreSQL, Prisma, NextAuth.js v5, Redis, and a companion React Native app. The system supports subdomain-based multi-tenancy with row-level tenant isolation, along with RBAC across 9 roles and 4 subscription tiers (Free, Starter, Professional, Enterprise) billed through Razorpay. Its scope covers admissions, attendance, fees, exams, payroll, timetable, transport, library and report cards, helping schools manage core processes in a single system. The platform spans 60 data models across 6 logical database schemas, around 27 web modules, and 21+ mobile screens, with Firebase push notifications extending the experience to parents and students.
Running a school on spreadsheets and five different logins doesn't scale.
Fees, attendance and exams live in different tools.
Parents chase paper fee receipts, teachers mark attendance on paper registers, and report cards get typed up by hand every term — with no single record of a student's actual progress.
Parents find out too late.
A missed fee deadline or a dropping attendance streak often reaches a parent only at the next meeting, not when it happens.
Every school year starts from scratch.
New academic year, new timetable, new fee structure, re-enrolling returning students — most of it re-typed by hand into a dozen registers and spreadsheets.
A school doesn't need ten tools. It needs one system that already knows who's enrolled, who's paid, who's present, and who needs help.
Why it matters
The outcomes that actually move the needle
One login, the whole school.
Academics, attendance, fees, exams, payroll and transport in a single platform — role-based dashboards for admins, teachers, accountants, parents and students.
Parents see problems the day they happen.
Attendance, fees due, and exam results sync straight to the parent app — a missed class or an unpaid invoice shows up as a push notification, not a surprise later.
Fee collection that reconciles itself.
Razorpay-backed online payments, on the web and in the app, post straight to the ledger — accountants stop chasing receipts and start reading reports.
A new academic year in minutes, not weeks.
Classes, sections, timetables and fee structures roll forward from last year's setup instead of being rebuilt from scratch.
Every school gets its own site.
A subdomain, a public marketing page, and an online admissions form — families can apply before a human ever touches a spreadsheet.
Data your school actually controls.
Built-in tools to export or erase a student's data on request — not a compliance afterthought bolted on later.
Key Capabilities
What we designed, built and shipped
Subdomain-based multi-tenancy with row-level tenant isolation
RBAC across 9 roles + 4 subscription tiers (Razorpay billing)
Academics, attendance, fees, exams, payroll, timetable, transport & library
Companion React Native app (21+ screens) with Firebase push notifications
Technology Stack
Every choice made for a reason — not just what's trendy
| Layer | Technology | Why |
|---|---|---|
| Web framework | Next.js 16, React 19 | Server components, one deployable app |
| Database | PostgreSQL — 6 logical schemas | Domain-separated schemas keep a 60-model system navigable |
| ORM | Prisma 5 | Type-safe queries across 60 models and 29 enums |
| Auth | NextAuth.js v5 (Auth.js, beta) | Session-based access control across 9 roles |
| Cache | Redis (ioredis + Upstash) | Fast tenant resolution and API rate limiting |
| Payments | Razorpay (web + mobile) | Webhook-verified fee collection and billing |
| Mobile | React Native (bare, not Expo) | Native performance across 21+ screens |
| Push notifications | Firebase Cloud Messaging | Real-time alerts to parents and students |
| Storage | AWS S3 | Durable storage for report cards, ID cards and uploads |
| Notifications | SMS + WhatsApp (per-tenant) | Reaches parents who don't open the app |
| Observability | Sentry + PostHog | Error tracking and usage analytics in production |
Architecture
How each school stays isolated
One platform, one database — every school's data is scoped by tenant, never mixed.
A school's subdomain resolves to its tenant in Redis-cached lookups, then every query is scoped by that tenant's ID across a single PostgreSQL database split into six logical schemas. Fee payments, push notifications, file storage and parent alerts all run through real, verified integrations — Razorpay, Firebase, AWS S3, and SMS/WhatsApp.
How it works
From sign-up to running the school day
1
Sign up
A school registers and gets its own subdomain in minutes — no procurement call required.
2
Set up the year
Classes, sections, subjects, timetable and fee structure are configured once, then roll forward each year.
3
Onboard everyone
Teachers, accountants and front-office staff get role-based logins; parents and students get the mobile app.
4
Run the school day
Attendance, fees, exams, homework and timetable changes flow through one system — straight to the parent app.
5
Review and improve
Analytics and at-risk alerts surface patterns — like an attendance dip — before they become a bigger problem.
Deployment
Deploy it your way
Fully managed (recommended).
We host and run the platform on your subdomain; you just onboard your school. Four real environments — dev, QA, UAT and production — back every release.
Self-hosted.
Next.js and PostgreSQL deploy behind PM2 and Nginx on your own infrastructure, with the same CI/CD pipeline we use ourselves.
Bring your own providers.
Configure your own Razorpay, SMS and WhatsApp credentials per school — fees and alerts still flow through the same platform, on your account.
Integrations
- Razorpay — online fee payments, web and native mobile checkout
- Firebase Cloud Messaging — push notifications to the parent/student app
- AWS S3 — file storage for report cards, ID cards and uploads
- SMS & WhatsApp — per-tenant configurable parent notifications
- Transactional email for account and billing notices
- A versioned REST API (/api/v1) with a published OpenAPI spec
See it running for a real school.
We'll walk you through a live tenant — academics, fees, attendance and the parent app — on a call. No commitment, no sales script.
Complete feature guide
Everything the platform does
Esparks Edu is a multi-tenant school management platform — every school gets its own subdomain, role-based dashboards for staff and families, and a companion mobile app. Here is everything the platform does.
Web platform
The school management dashboard
27 modules covering academics, finance, operations and communication — role-based, so every user sees only what their job needs.
Academics & admissions
- Classes, sections & subjects. Set up the academic structure once and roll it forward each year.
- Online admissions. A public admissions form and status tracker — families can apply before a human touches a spreadsheet.
- Grading & report cards. Exam results roll up into PDF report cards, generated automatically.
- Homework. Assignments, submissions and tracking in one place.
Attendance & timetable
- Daily attendance. Marked per class, synced instantly to the parent app.
- Timetable management. Class schedules and staff assignments, kept in sync across the school.
- At-risk alerts. Analytics flag attendance or performance drops before they become a bigger problem.
- Calendar & events. School-wide events and announcements in one shared calendar.
Fees & payroll
- Online fee collection. Razorpay-backed payments, web and in-app, post straight to the ledger.
- Fee structures per class. Configure once per academic year; parents pay against the real structure.
- Staff payroll. Salary processing for every role on staff, inside the same system.
- Financial reporting. Fee collection and payroll roll up into a single reporting view.
Transport, library & records
- Transport management. Track routes and vehicles assigned to students.
- Library. Catalogue and circulation for the school library.
- ID cards. Generate staff and student ID cards from the same records.
- Alumni. Keep a record of the school community after graduation.
Communication
- Announcements. School-wide or class-specific notices.
- Multi-channel notifications. Push, SMS and WhatsApp — configurable per school, so parents are reached the way they actually check.
- Direct messaging. Staff and families can message directly inside the platform.
Every school gets its own site
- Public marketing page. About, events and gallery pages, generated per school.
- Online admissions form. Prospective families can apply and check status without an account.
- Custom subdomain. Each school gets its own address on the platform.
Data & access control
- Data export & erasure tools. Built-in tools to export or erase a student's data on request.
- Audit log. Every administrative action is recorded.
- Role-based access. 9 distinct roles, from super admin to student, each scoped to what they need.
Mobile app
The parent & student companion app
Built with React Native, not a wrapped website — role-based navigation for admins, staff, parents and students, with real-time push notifications.
Built for every role
- Role-based navigation. Admins and staff get a full 5-tab dashboard; parents and students get a focused 2-tab experience.
- 21+ screens. Dashboard, students, staff, attendance, fees, exams, payroll, timetable, homework and more.
- Native performance. React Native, not a wrapped website — fast on real school Android and iOS devices.
Stay current without opening a laptop
- Push notifications. Firebase-powered alerts for attendance, fees due, exam results and announcements.
- Leave applications. Staff apply for leave directly from the app.
- Announcements. School-wide notices delivered to every parent and student, on their phone.
Pay fees without leaving the app
- In-app fee payment. Razorpay-powered checkout, natively in the mobile app.
- Payment history. Parents see exactly what's been paid and what's due.
Parent & student portals
- Parent home. A single view of a child's attendance, fees, homework and results.
- Student home. Timetable, homework and exam results, built for the student using it.
Security & privacy
- Role-based access control across 9 distinct roles — super admin, school admin, principal, teacher, accountant, front office, librarian, parent and student.
- Two-factor authentication (TOTP) available for staff accounts.
- Passwords hashed with bcrypt; input sanitized against XSS with DOMPurify.
- Every fee-payment webhook is signature-verified before it touches the ledger.
- Built-in data export and erasure tools for handling a family's data request.
- Error tracking in production, so issues are caught before they compound.
- Immutable audit log of administrative actions.
Reliability
- Automated test suite (unit + end-to-end) runs on every change before it ships.
- Four real environments — dev, QA, UAT and production — behind a CI/CD pipeline.
- Redis-backed caching keeps tenant resolution fast even under load.
- Subdomain routing with row-level tenant isolation — one school's data never crosses into another's.
Simple, per-school pricing
Every tier includes the full platform — academics, attendance, fees, exams, payroll, timetable and the parent/student app. Higher tiers raise the student and staff limits.
Free
₹0/ month
Up to 100 students · 10 staff logins
Starter
₹999/ month
Up to 500 students · 25 staff logins
Professional
₹2,499/ month
Up to 2,000 students · 75 staff logins
Enterprise
₹9,999/ month
Unlimited students & staff logins
See it in action
This product is live in production — explore it for yourself.
Visit Esparks Edu — School Management ERPReady to Start Your Project?
Let's discuss how we can help you achieve similar results for your business
More Success Stories
Explore our other saas projects
SaaS
Sparks Business — Inventory, Sales & GST Invoicing Platform
Sparks Business is a multi-tenant platform built by eSparks IT Solutions to run inventory, purchases, sales and GST invoicing from one system. It pairs a NestJS 11 API with an installable Next.js 15 PWA, backed by PostgreSQL 17 through Prisma 6 across 49 data models. Every query is scoped to its tenant through an AsyncLocalStorage-driven Prisma client extension, and an append-only audit table is enforced at the database level — even a direct update or delete against it is rejected by a trigger. GST math (CGST/SGST/IGST splitting, GSTIN validation) runs on decimal.js for exact, rounding-free results, and a real Tally XML importer lets a business bring in existing ledgers, vouchers and stock items instead of starting over. Redis and BullMQ handle background email and document generation, S3-compatible object storage holds product images, invoice PDFs and backups, and Microsoft Graph sends transactional email. Deploys are health-gated, so a broken build never reaches production.
Read Full Case Study
SaaS
Retro — Sprint Retrospectives
Retro — Sprint Retrospectives is a SaaS platform for running real-time sprint retrospectives for every team. Built with Next.js 15, React 19, PostgreSQL, Drizzle, Redis, Docker, and Socket.IO, it supports live cards, votes, presence, and a timer through Socket.IO with a Redis adapter. The product includes no-signup anonymous join with server-side device tokens, along with drag-and-drop columns, voting, board lock, and CSV/PDF export. It also features a 15-language localized UI, dark mode, and a pnpm monorepo structure. Architected as 2 apps plus 2 shared packages, the solution is designed for multi-instance realtime usage and includes Caddy auto-HTTPS for deployment-ready operation.
Read Full Case Study
DevOps & Infrastructure
ThinClient OS + Fleet Manager
A production-grade Linux appliance that boots straight into a full-screen Windows RDP session — no desktop, no shell, no login prompt — backed by a self-healing watchdog and an infinite reconnect loop. On machines with Secure Boot and a TPM 2.0 chip the whole disk is encrypted (LUKS2, AES-256) with the key sealed in the machine's own TPM, and the encrypted install has been attack-tested against disk theft and boot tampering. Lost or stolen machines are wiped remotely, crypto-erasing the disk on encrypted installs. Optional per-account policy adds lock-screen password rules with a three-strike lockout, Windows-server certificate pinning, USB-storage and clipboard blocking, and memory hardening. New machines can be required to wait for administrator approval (on by default for new accounts), operating-system security patches can roll out through canary machines, and signed kernel updates roll back on their own if they fail to start. It ships as a reproducible ISO with a graphical installer and pairs with a Next.js fleet manager that provisions, monitors, secures and remotely controls the machines and the AWS, Azure and VPS Windows servers they connect to.
Read Full Case Study