Your Supabase project URL from the project settings.

The anon/public key from your Supabase project API settings.

Your Anthropic API key for generating new suggestions. Get one at console.anthropic.com

Removes all pending suggestions from the queue. Use if you're seeing repeats.

Run this SQL in your Supabase SQL editor to create the required tables:

-- Pending suggestions table
CREATE TABLE IF NOT EXISTS lyric_suggestions (
    id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
    lyric TEXT NOT NULL,
    section TEXT DEFAULT 'verse',
    context TEXT,
    status TEXT DEFAULT 'pending',
    rejection_reason TEXT,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Approved lyrics table  
CREATE TABLE IF NOT EXISTS approved_lyrics (
    id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
    original_lyric TEXT NOT NULL,
    final_lyric TEXT NOT NULL,
    section TEXT DEFAULT 'verse',
    was_edited BOOLEAN DEFAULT FALSE,
    word_changes TEXT,
    approved_at TIMESTAMPTZ DEFAULT NOW()
);

-- Enable RLS
ALTER TABLE lyric_suggestions ENABLE ROW LEVEL SECURITY;
ALTER TABLE approved_lyrics ENABLE ROW LEVEL SECURITY;

-- Banned words table
CREATE TABLE IF NOT EXISTS banned_words (
    word TEXT PRIMARY KEY,
    banned_at TIMESTAMPTZ DEFAULT NOW()
);

ALTER TABLE banned_words ENABLE ROW LEVEL SECURITY;

-- Policies (adjust as needed)
CREATE POLICY "Allow all" ON lyric_suggestions FOR ALL USING (true);
CREATE POLICY "Allow all" ON approved_lyrics FOR ALL USING (true);
CREATE POLICY "Allow all" ON banned_words FOR ALL USING (true);