Total posts in Supabase
—
From
public.postsMissing featured image
—
Need backfill
Found on WordPress
—
Have a featured image
Will backfill
—
Ready to write
1 Scan Supabase for posts missing featured images
Reads
public.posts and counts every row where featured_image_url IS NULL. No writes.2 Pull featured images from WordPress
For each missing post, hits
theforceforhealth.com/wp-json/wp/v2/posts with _embed=wp:featuredmedia in batches of 50. No writes.3 Apply backfill to Supabase
Runs
UPDATE posts SET featured_image_url = ?, cover_image_url = ? WHERE wordpress_id = ? for each match. Posts with no featured image on WP are skipped.