migrate-supabase

What problem does it solve?

This Skill solves the complexity and risk of migrating a Supabase/Lovable application by turning scattered Supabase features (DB schema, Edge Functions, Auth, Storage, RLS) into a clean FastAPI + SQLModel + Alembic backend while adapting the existing React frontend to use REST calls instead of the Supabase client.

Core Features & Use Cases

• Supabase-to-FastAPI mapping report: Analyzes DB schema, Edge Functions, Auth flow, Storage usage, Realtime usage, RLS policies, and cron/scheduled jobs, then proposes exact REST endpoint equivalents.
• Backend foundations & production structure: Generates the target project layout (models, schemas, routers, services, tasks), configures JWT authentication (bcrypt + python-jose), and sets up Alembic for async migrations.
• Frontend migration to REST + JWT: Removes Supabase JS usage, adds a centralized axios API client with JWT handling, rewrites auth hooks, and guides component-level replacements including safe relation-shape mapping (avoids silent runtime breakage from as any).
• Infrastructure + DX: Proposes Docker Compose (db/backend/frontend), environment variable templates, and a Makefile-based workflow with migrations on startup.

Quick Start

Run the migrate-supabase skill and point it to your project path to get a confirmed mapping plan before the migration begins.