OrgSmart
Multi-tenant organisational management platform
Overview
OrgSmart is a multi-tenant SaaS platform that helps organisations manage their structure, processes, people, and performance in one place. It's built for organisations that need role-based access control, real-time collaboration, and process management without the complexity of traditional ERP systems.
The platform supports multiple organisations on a single deployment with per-tenant database routing. Each organisation gets its own isolated database while sharing a single application instance, so data stays separate and secure without duplicating infrastructure.
Key features include role-based access control across four levels, real-time chat, process management, activity tracking, division and workgroup management, invitation-based membership with ID number auto-linking, SnapScan payment integration, and PDF report generation.
The Challenge
The client needed a system to manage multiple organisations with different structures, roles, and processes. Existing solutions were either too rigid, forcing every organisation into the same org chart, or too generic, offering no real process management. Multi-tenancy was a hard requirement, not a nice-to-have, since each organisation's data had to be completely isolated from every other tenant on the platform.
The Solution
Next.js App Router
Server components for SEO and performance, with a custom GraphQL layer replacing PostGraphile for a type-safe API.
Per-Tenant Database Routing
Dynamic PostgreSQL connection pooling routes each request to the correct tenant database, keeping data fully isolated.
Redis Caching
TTL-based cache invalidation keeps frequently accessed data fast without stale reads.
Four-Level Access Control
OrgSmart Administrator, Super User, Administrator, and User roles with granular permissions at each level.
Real-Time Chat
Redis Pub/Sub with Server-Sent Events for instant messaging across organisation members.
Invitation-Based Membership
ID number auto-linking matches invitations to existing users, so joining an organisation takes one click.