Scale TradeClaw with Supabase

-- Core tables (20+ total)
CREATE TABLE signal_history (
  id TEXT PRIMARY KEY,
  pair TEXT NOT NULL,
  direction TEXT CHECK (direction IN ('BUY','SELL')),
  confidence NUMERIC NOT NULL,
  entry_price NUMERIC NOT NULL,
  timestamp BIGINT NOT NULL,
  outcomes JSONB DEFAULT '{}'
);

CREATE TABLE paper_trades (
  id TEXT PRIMARY KEY,
  symbol TEXT NOT NULL,
  direction TEXT NOT NULL,
  entry_price NUMERIC, exit_price NUMERIC,
  pnl NUMERIC, pnl_percent NUMERIC,
  opened_at TIMESTAMPTZ, closed_at TIMESTAMPTZ
);

CREATE TABLE webhooks (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL, url TEXT NOT NULL,
  pairs JSONB DEFAULT '"all"',
  min_confidence INTEGER DEFAULT 0,
  enabled BOOLEAN DEFAULT true
);

-- + api_keys, users, email_subscribers,
--   telegram_subscribers, sms_subscribers,
--   plugins, price_alerts, votes, pledges,
--   push_subscriptions, slack_integrations,
--   app_users, subscriptions, and more...

#!/usr/bin/env node
// Reads data/*.json → upserts into Supabase

node supabase/migrate.js              # migrate all
node supabase/migrate.js --dry-run    # preview only
node supabase/migrate.js --seed       # seed data info