Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hey there, I have an open source project running on Supabase.

And, I want people to be able to self host it too, So How do I export the SQL for my DB so, others can easily apply and use it too?

You can make a direct connection to the db and use `pg_dump`

Generating the SQL for a table in a function looks like a lot of work otherwise, specially if you consider dependencies such as foreign key references.

There's also a backups page(that already contains pg_dump dumps). Hm, maybe you can request making that accessible through an HTTP endpoint?