PulsePilot — Data Import to Supabase

One-shot migration of 6 properties + 5,063 reviews from JSON to Supabase

1Add temporary INSERT policies

RLS blocks anonymous writes on properties + reviews. Run this in your Supabase SQL Editor first to allow this one-shot import. We'll remove it in Step 3.

-- Temporary: allow anonymous inserts during one-time migration
DROP POLICY IF EXISTS "Tmp insert properties" ON properties;
CREATE POLICY "Tmp insert properties" ON properties FOR INSERT WITH CHECK (true);

DROP POLICY IF EXISTS "Tmp insert reviews" ON reviews;
CREATE POLICY "Tmp insert reviews" ON reviews FOR INSERT WITH CHECK (true);
↗ Open SQL Editor

2Run the import

After running the SQL above, paste your Supabase credentials and click Import. The page reads ./data/properties.json and ./data/reviews.json from the same folder.

~30 seconds for 5,063 reviews
Propertiespending
Reviewspending

3Remove the temporary policies

After import succeeds, run this in SQL Editor to revoke anonymous write access. (We'll add real auth + scoped policies in the next session.)

-- Remove temporary policies after migration is complete
DROP POLICY IF EXISTS "Tmp insert properties" ON properties;
DROP POLICY IF EXISTS "Tmp insert reviews" ON reviews;
↗ Open SQL Editor
⚠ Don't skip this step Leaving those policies in place lets anyone with the anon key (which is public) insert rows into your database. Five seconds to remove.