Setup & System Status

All checks below must be Complete before ingestion will work. Fix each Required item in order.

✓ All 6 checks passing — system is readyBack to Dashboard →

Setup Checklist

Items are checked live on each page load. Refresh after making changes.

Environment variables

SUPABASE_URL, SUPABASE_SERVICE_ROLE_KEY, and OPENAI_API_KEY are all set.

Complete

Supabase connected

Connected successfully.

Complete

Database schema (migration 001)

All tables present: niches, playbooks, source_signals, intent_scores, lead_candidates, outreach_drafts.

Complete

Database schema (migration 002)

ingestion_runs table is present.

Complete

OpenAI API key

Key is set. Use the "Test OpenAI" button below to confirm it is valid.

Complete

Reddit RSS feeds

Public feeds — no credentials required. Use the "Test RSS" button below to verify network access.

Complete

Live Service Tests

Click to run a real test call. OpenAI uses a tiny request (a few tokens). RSS fetches one public subreddit.

Environment Variables

Create a file called .env.local in the project root (same folder as package.json) and add the values below.

SUPABASE_URLSet ✓
SUPABASE_SERVICE_ROLE_KEYSet ✓
OPENAI_API_KEYSet ✓
REDDIT_USER_AGENToptionalSet ✓

How to apply .env.local changes

  1. Edit .env.local in the project root (copy from .env.local.example if starting fresh)
  2. Fill in each value using the instructions in the section above
  3. Stop the dev server (Ctrl+C) and run npm run dev again
  4. Refresh this page — completed items turn green immediately

Running database migrations

Two SQL files must be run in order in the Supabase SQL Editor. Run each one only once.

Migration 001 — base schema ✓

File: supabase/migrations/001_initial_schema.sql

Migration 002 — RSS cleanup ✓

File: supabase/migrations/002_rss_cleanup.sql