Shikshya
School management REST APIs with Prisma, PostgreSQL, multi-tenant architecture work, and an LLM chat assistant.
Read as MarkdownArchitecture
Node.js / Express REST API → Prisma → PostgreSQL; school information → LLM chat assistant
Platform scope
Shikshya is a school management system. The backend uses Node.js and Express, with Prisma and PostgreSQL for data access. The recorded work also includes code review, multi-tenant architecture improvements, and CI/CD changes.
Assistant use case
An LLM-based chat assistant helps teachers, parents, and students find homework, notices, and program-related information through natural-language queries. The public work summary does not specify the model, retrieval architecture, or evaluation metrics.
Data and tenant boundaries
Prisma provides typed data access to PostgreSQL. Type safety does not by itself enforce school-level isolation: tenant scope and user permissions remain application concerns. That distinction is central when a system serves multiple schools and user roles.
Delivery ownership
The work included REST API development, Prisma-backed data management, architecture review, and improvements to the deployment pipeline. There is no measured deployment-time reduction in the available record.
Validation priorities
Review should cover access between schools, teacher/parent/student permissions, assistant responses that lack supporting school data, and changes to schemas used by deployed clients. These are areas to validate, not a claim of a published test or security audit.