NyansapoSoftwareLIMITED

Case study

Building SchoolHub Ghana: multi-tenant school software that stays isolated

How we designed school_id-scoped Row-Level Security, Ghanaian payments, and an admin experience private schools can actually run.

Problem

Private schools in Ghana were juggling WhatsApp threads, spreadsheets, and fragmented fee collection. Existing tools were either too generic or too expensive, and none respected local payment realities like Mobile Money.

Approach

We scoped a multi-tenant SaaS with one shared codebase and strict per-school data isolation. Discovery sessions with administrators shaped fee workflows, attendance, and parent messaging before we wrote production schema.

Solution

SchoolHub Ghana ships on Next.js, Supabase PostgreSQL with school_id RLS policies, Clerk auth, and Paystack + MoMo. Each school gets a secure workspace; the platform never relies on UI hiding for tenant boundaries.

Outcome

Schools can manage core operations from one place, founders can onboard tenants without custom deploys, and the same architectural pattern now informs NyansapoSoftware's custom client work.

Tech highlights

  • school_id-scoped Row-Level Security for full tenant isolation
  • Paystack and Mobile Money payment flows
  • Clerk-authenticated admin and staff roles