AquaTrack — Water Purifier Service Management SaaS
Architected a vertical SaaS system for water purifier service businesses with Next.js, Drizzle, PostgreSQL, and automated WhatsApp service reminders.
Overview
AquaTrack is a service management platform designed to automate operational workflows for water purifier service companies. Features customer management, service history, warranty tracking, PDF receipts, and automated WhatsApp maintenance alerts.
Problem
Water purifier service companies lose customer retention due to missed periodic filter replacements, untracked warranties, and manual paper billing.
Constraints
- Automated scheduled notifications without human intervention
- Type-safe database ORM and fast serverless deployment
- QR-based WhatsApp pairing for business phone numbers
Approach
Architected a full-stack Next.js App Router application powered by Express APIs, BetterAuth authentication, Drizzle ORM, PostgreSQL, and Evolution API for cron-driven WhatsApp notifications.
Key Decisions
Use Drizzle ORM + PostgreSQL over Prisma
Drizzle provides lightweight, SQL-like type safety with lower cold-start latency for serverless API routes.
Implement Cron-based WhatsApp Dispatcher
Automatically queries upcoming filter replacement dates daily and dispatches personalized WhatsApp reminders to customers.
Tech Stack
- TypeScript
- Next.js
- Express
- BetterAuth
- Drizzle ORM
- PostgreSQL
- Evolution API
- WhatsApp API
Result & Impact
- Next.js + Drizzle + PostgresArchitecture
- Cron WhatsApp RemindersAutomation
- Vertical Service SaaSFocus Area
Designed an end-to-end operational software product solving customer retention and maintenance scheduling for local service businesses.
Learnings
- Traditional service businesses operate on recurring workflows — automating periodic reminders drives massive retention value.
Workflow Automation Architecture
AquaTrack addresses the core business challenge of water purification services: preventing lost recurring revenue from missed filter maintenance cycles.