iSMS - AI-Powered Operating System for Early Childhood Education

iSMS is the AI operating system for an early childhood education organisation, built to move educators away from paperwork and back into the classroom. It replaces manual report writing, approval chains, consent forms, and rostering with an automated, role-scoped platform running across multiple centres and HQ.

Frontend: React, TypeScript, Tailwind, shadcn/ui, TanStack Query

Backend: Node.js, Express, Drizzle ORM, PostgreSQL (Neon)

AI/ML: Claude API, OpenAI API, RAG pipeline, Cohere rerank

Infrastructure: Replit Autoscale, Google Cloud Storage, Microsoft Graph API

Staff & Student Databases Configurable data grids with bulk CSV/XLSX import and full audit logging on every change.

Forms & Surveys Drag-and-drop form builder with public shareable links, email distribution, and payment verification.

Survey Analysis Engine Automated dashboards for parent and staff satisfaction with one-click PDF report export.

Event Management Registration, QR-code check-in/check-out, live attendance tracking, and post-event analytics.

Report Hub Multi-step approval chains, versioned reports, reminder scheduling, and calendar integration, cutting weekly report cycles from days of back-and-forth to a single review pass.

SOP & Knowledge Hub (AI/RAG) Retrieval-augmented AI assistant that answers staff questions from the organisation's own SOPs, so institutional knowledge is instant instead of tribal.

Facility Tickets, Email Campaigns, Phishing Simulation, Staff Rostering Ticketing, campaign builder with Outlook-compatible emails, phishing awareness tracking, and rostering.

Schema-First Design: Single Drizzle schema types the database, API, and frontend, turning column renames into compile-time errors

Repository Pattern: Routes never touch the database directly, keeping all query logic behind one interface

Production Safety: Destructive operations blocked by default, rate-limited auth endpoints, ACL-gated file access

Microsoft 365 Integration: OAuth sign-in, SharePoint/OneDrive ingestion, and transactional email via Graph API

Server-Side PDF Generation: Puppeteer renders Outlook-compatible PDFs and emails inside a containerised environment

Weekly report writing cut from 5 to 6 hours down to 1 to 2 hours, giving teachers that time back for teaching

Three centres plus HQ unified on one platform, with one login for every workflow

Manual approval chains, consent forms, and compliance tracking replaced with automated, auditable workflows

Platform used daily in production, evolving on a weekly release cycle rather than a one-off delivery