I am trying to run cypress for e2e tests, but I am struggling with resetting the supabase db. How can I delete all users. Do I have to use the api? The best case scenario would be that I could use db-migrate, write a simple SQL statement "DELETE FROM auth.users", but I get an "not owner of relationship" error, which makes sense since I am using the normal postgress user account. Does anybody knows a way around that?

For this you will need to elevate the

postgres

user to a superuser and then perform this task, but I would be careful deleting anything form

auth.users

that way as there might be other things linked to it. I would use the api to do this instead.