Seed Process

We use a custom JavaScript script (scripts/seed-with-users.js) instead of a traditional seed.sql file for the following reasons:

• Authentication Integration: Creates test users with proper Supabase Auth integration
• Cross-Schema Data: Populates data across multiple schemas (public, content)
• Realistic Relationships: Creates sample searches and links them to entities
• Environment Flexibility: Uses environment variables for different deployment contexts

Usage:

npm run db:reset  # Runs migrations + seed script

What it creates:

• Test users: test1@example.com, test2@example.com
• Sample entities in the content schema
• Sample search with linked entities for testing the full workflow