When a local service business owner complained about scheduling chaos — lost paper schedules, no-shows, and manual routing — I saw an opportunity. Six months later, ClearCrew App was handling 500+ workers with an unexpected addition: an AI-powered compliance assistant.

The Problem

Running a service business sounds simple until you think about logistics:

• 50+ employees with different skills, availability, and locations
• 100+ jobs per week scattered across a county
• Constant changes — cancellations, add-ons, rainouts
• Regulatory compliance that required hours of research

The owner was spending 20+ hours weekly just on scheduling and compliance questions.

Building the Solution

I approached this as a mobile-first problem. Field workers needed information on the go.

Tech Stack

• Next.js + TypeScript for the frontend and API
• Supabase for database, authentication, and real-time updates
• Tailwind CSS for clean, responsive styling
• OpenAI API for AI-powered compliance Q&A

Key Features

1. Smart Scheduling — Drag-and-drop interface that respects worker skills and location
2. Route Optimization — Minimize drive time between jobs
3. Offline Mode — Critical for areas with poor cell service
4. AI Compliance Assistant — Ask compliance questions, get answers backed by regulations

Technical Approach

Supabase for the Win

Using Supabase meant I didn’t need to build:

• A separate auth system (Supabase Auth)
• File storage (Supabase Storage)
• Real-time subscriptions (Supabase Realtime)
• Backend API from scratch (Next.js API Routes)

RAG Architecture for Compliance AI

I built a RAG (Retrieval-Augmented Generation) system for compliance:

1. Ingest regulatory documents into Supabase with vector embeddings
2. When users ask questions, find relevant passages using pgvector
3. Generate answers backed by official regulations

This kept AI responses grounded in source material.

Offline-First Architecture

Field workers can’t rely on constant connectivity. I used Next.js offline capabilities with local data caching.

Results

• 40% reduction in scheduling time
• 60% reduction in compliance research time
• 60% fewer no-shows
• 500+ active users

ClearCrew proved that combining practical workforce management with AI assistance transforms small business operations.

What I Learned

1. Supabase + Next.js is a powerful combo — fast development, reliable infrastructure
2. AI needs guardrails — confidence thresholds prevent confidently wrong answers
3. Offline-first matters — field workers can’t always rely on connectivity

Sometimes the best solution combines the familiar (Next.js) with the modern (AI).