supabase-offline-sync

What problem does it solve?

This Skill provides a robust offline-first data synchronization workflow between a local Expo SQLite database and a remote Supabase PostgreSQL backend, enabling apps to operate offline and seamlessly reconcile changes when online.

Core Features & Use Cases

• Queue-based syncing: enqueues local changes and processes them in order with retry support.
• Conflict resolution: applies last-write-wins based on updated_at timestamps to ensure data consistency.
• Background synchronization: supports Expo background tasks and periodic processing to keep local and cloud data in sync.
• Use Case: Build an offline-capable mobile app (e.g., journaling, step-tracking) that can reconcile entries and user configuration when connectivity returns.

Quick Start

Install the required dependencies, initialize the local SQLite database, and start the sync queue processor to begin syncing with Supabase.