whats the best way to delete all rows from all tables?

With the JavaScript SDK you can do

js
const { data, error } = await supabase
  .from('table_name')
  .delete()

Or you can use the sql editor in the dashboard and do

sql
TRUNCATE TABLE table_name;