← All work
B2B SaaS2025
Multi-Tenant Inventory Management
A production multi-tenant SaaS where every factory gets its own isolated MySQL database — real-time stock, invoicing, BOM formulas, audit trails, and automated backups.
View live ↗
Role
Full-Stack Engineer
Timeline
2025
Year
2025
Category
B2B SaaS
1:1
DB per tenant
4h
automated backups
Overview
A production-ready inventory platform where each factory gets a fully isolated MySQL database — true tenant isolation, not just a tenant_id column. It includes self-serve onboarding, per-tenant connection pooling, a full inventory suite with multi-level BOM, invoicing, audit logging, and automated backups.
Highlights
- ◆One database per tenant with self-serve onboarding that provisions schema and admin automatically.
- ◆Full inventory suite — multi-location stock, BOM formulas, invoicing, and audit trails.
- ◆React Native client with barcode scanning, role-based access, and offline-safe operations.
Node.jsTypeScriptReact NativeMySQL