It's not single binary, you need to spin up a dozen or so containers and have a full DevOps team on standby if self hosting.
Yes, OP wants to hand the database to their team.
Well yeah, that's the nature of using something like Supabase it is designed to scale and be flexible to develop on top of.
Yes, OP wants to hand the database to their team.