Migration Check

Before deploying code that changes database queries, verify the schema exists.

What to check

1. Every .select('...') in Supabase queries — do those columns exist?
2. Every .from('table') — does the table exist?
3. Every join (.select('..., relation:other_table(...)')) — does the FK relationship exist?
4. Any new columns referenced in code — is there a migration for them?

How to check (Supabase)

# List columns in a table
curl -s "${SUPABASE_URL}/rest/v1/dnu_cities?select=*&limit=0" \
  -H "apikey: ${SUPABASE_KEY}" -I | grep -i "content-profile"

# Or query information_schema
# SELECT column_name FROM information_schema.columns WHERE table_name = 'dnu_cities';

Rule

If code references a column that doesn't exist in the database, the deploy MUST include a migration that adds it. No exceptions.