Supabase Automation Process

I'm working on a project that automates the process of Database creation and uploading schema. Now I can create the database and retrieve the env variables using OAuth. But I can't figure out how I can dump the schema onto it. Is there any way to do this?

I know loveable already does this.

Note: This isn't for local development this will be a production website.