So, I want to have a local copy of all my plpgsql functions, in case they get lost or if I want to re-create the DB locally. Right now I am copying them manually over to supabase, but is there an API to push them to supabase, so I can automate this? Thanks!

You can use any database migration library to do this

Ahh, right because it can connect directly to the postgres instance.. okay, thanks!

Just make sure the credentials aren't available to the frontend app. I'm doing my deployments with GitHub actions on fly.io and I store my database credentials inside of GitHub secrets

@User do you have them in an .sql file and push it with psql then?

Take a look at my waiting list project, the migrations directory. https://github.com/silentworks/waiting-list

that looks pretty sweet, simple. thank you