I have created my tables from UI, how to generate the sql query used to generate the table so I can keep them saved in my git repo for when I want to recreated a similar project?

You can use any migration tool you like. Supabase has it's own one in the

supabase

CLI tool, I think this command (after init and login) should take a snapshot of your database: https://supabase.com/docs/reference/cli/supabase-db-commit

(venv) fastapi-supabase-svelte$ supabase db remote commit Error: Failed to connect to Docker daemon. Is Docker running?

I think it tries to start a local supabase development environment? But don't listen to me,

... remote commit

seems to be for applying migrations, not generating them >_>

I did

python
supabase db remote set 'postgresql://postgres:xxxxxxxxxxxxxxxx@db.xxxxxxxxxxxx.supabase.co:5432/postgres'
supabase db remote commit

sorry, I've read the documentation wrong,

... remote commit

seems to be for applying migrations. You'll need pg_dump to make the initial migration, and then use a migration tool while developing your application.