SkyNest - Hotel Management System
A multi-branch hotel operations platform with role-based dashboards and a real relational backend.
SkyNest is a React-based hotel operations platform built as a Database Lab project, handling guests, reservations, rooms and billing across three branches (Colombo, Kandy, Galle).
It pairs a React 18 frontend with a PostgreSQL backend and a JWT-secured REST API, with role-based dashboards for different staff levels.
Highlights
- Role-based access control and per-role dashboards.
- Reservations with check-in/check-out workflows and multi-branch support.
- Real-time operational statistics and reporting.
A real schema, not a toy
Because it's a database course project, the emphasis is on the relational model behind it - the backend uses PLpgSQL and a proper PostgreSQL schema rather than an ORM hiding everything, with the API enforcing role boundaries on top.
Stack
Frontend
- React 18
- Bootstrap 5
- Axios
Backend
- PostgreSQL
- PLpgSQL
- JWT