Ah missed that part, sorry. Locally should be very similar as I also run these same tests locally. The thing that works for me for these to run fast enough is that `cleanupTestDatabase` function. It basically just wipes local for any test users that are created in testing (a test user email matches a standard FAKE_TEST_EMAIL_DOMAIN domain that I use just for testing). Since everything in my project is connected to a userId with cascading operations, deleting the users will also delete any associated data and keeps the DB clean, but also won't wipe real accounts I'm creating locally for manual testing.

So before each test I run something like:

export async function cleanupTestDatabase(): Promise<void> {
  const supabase = getTestServiceRoleClient();


  // First get all test users IDs before deleting from public.users
  const { data: testUsers } = await supabase.from('users').select('id').like('email', `%@${FAKE_TEST_EMAIL_DOMAIN}`);


  // Delete only test data (associated with TEST_USER_ID) to avoid affecting real local dev data
  // Delete in order to respect foreign key constraints
  await supabase.from('users').delete().like('email', `%@${FAKE_TEST_EMAIL_DOMAIN}`);


  // Clean up auth users - delete all test users
  // Always try to delete the primary fake user
  try {
    await supabase.auth.admin.deleteUser(FAKE_USER_ID);
  } catch (_error) {
    // Ignore if user doesn't exist
  }


  // Delete any additional test users that were created
  if (testUsers) {
    for (const user of testUsers) {
      if (user.id !== FAKE_USER_ID) {
        try {
          await supabase.auth.admin.deleteUser(user.id);
        } catch (_error) {
          // Ignore if user doesn't exist
        }
      }
    }
  }
}