# Shikshya

> School management REST APIs with Prisma, PostgreSQL, multi-tenant architecture work, and an LLM chat assistant.

Author: Nirdesh Pokharel

Canonical URL: https://nirdeshpokhrel.com.np/work/shikshya

## Architecture

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.