bratoz

I’m currently building an internal tool for automated migration from Supabase Cloud to a self-hosted setup. I originally built it purely for myself because I needed to migrate \~50 cloud projects to self-hosted infrastructure, and I couldn’t find any reliable or complete solutions online. The process is fully automated and handles end-to-end project migration. All I need to do is provide SSH access to my VPS, and the system takes care of provisioning the environment and transferring everything — including database schema, data (via pg\_dump/pg\_restore), RLS policies, auth configuration, and storage buckets. Along the way, I ran into quite a few edge cases, so it’s reassuring to see others dealing with similar issues. I also implemented a proper workflow for Edge Functions. That part was significantly more complex than the database migration itself, mainly because self-hosted Supabase doesn’t provide a native API for deploying functions — so I had to handle deployment directly on the server level. Maybe once I finish testing the service, I’ll let others try it—if it’s still relevant by then.