System Setup & API Architecture

Environment configuration, PostgreSQL schema migration, and integration status.

Instant Zero-Config Evaluation Mode Active

ScrapeGuard is built with an intelligent dual-data layer. You can test all features right now with the built-in storage and controlled target store without setting up external accounts. When environment variables are provided in .env.local, ScrapeGuard automatically switches to live Bright Data, Anthropic Claude, and Supabase connections!

Environment Configuration (.env.local)

NEXT_PUBLIC_SUPABASE_URL=https://your-project.supabase.co
NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key
SUPABASE_SERVICE_ROLE_KEY=your-service-role-key
BRIGHTDATA_API_TOKEN=your-brightdata-token
ANTHROPIC_API_KEY=your-anthropic-key
CRON_SECRET=your-cron-secret-key

Supabase PostgreSQL Schema (schema.sql)

-- ScrapeGuard Supabase Schema
create extension if not exists "uuid-ossp";

create table if not exists monitors (
  id uuid primary key default gen_random_uuid(),
  user_id uuid references auth.users(id) on delete set null,
  name text not null,
  url text not null,
  fields text[] not null,
  collector_id text not null,
  schedule_hours int default 6,
  status text default 'healthy',
  target_type text default 'ecommerce',
  last_run timestamptz,
  created_at timestamptz default now()
);

create table if not exists snapshots (
  id uuid primary key default gen_random_uuid(),
  monitor_id uuid references monitors(id) on delete cascade,
  raw_json jsonb not null,
  execution_time_ms int default 450,
  captured_at timestamptz default now()
);

create table if not exists events (
  id uuid primary key default gen_random_uuid(),
  monitor_id uuid references monitors(id) on delete cascade,
  type text not null,
  summary_text text,
  diff_json jsonb,
  created_at timestamptz default now()
);

create index if not exists idx_snapshots_monitor on snapshots(monitor_id, captured_at desc);
create index if not exists idx_events_monitor on events(monitor_id, created_at desc);

Reset Demo Target State

Restores the controlled e-commerce target and seed monitors to default baseline.