relation "public.x" does not exist / Could not find the table in the schema cache

What it means

The code is asking for a database table that doesn't exist. Often the AI wrote code for a table but the step that creates it (the migration) never ran on your actual database.

How to fix it: paste this prompt into your AI builder

My app says a table does not exist. Check which tables the code uses versus the tables that actually exist in my Supabase project. Write a single SQL migration that creates any missing table with the columns the code expects, enables RLS, and adds appropriate policies. Don't rename existing tables or change code that already works. Tell me exactly where to run the SQL if it can't be applied automatically.

If the AI can't fix it: manual steps

1. Supabase dashboard, Table Editor: check the table name and spelling (and that it's in the 'public' schema).
2. Paste the migration SQL into the Supabase SQL Editor and run it.

Where this happens

Seen in these AI app builders and editors:

Sources

• https://supabase.com/docs/guides/troubleshooting/postgrest-not-recognizing-new-columns-or-functions-bd75f5
• https://www.postgresql.org/docs/current/errcodes-appendix.html

Related database errors

• new row violates row-level security policy for table#2 · database
• Failed to send a request to the Edge Function / non-2xx status code#10 · database
• permission denied for table (Supabase 42501, missing GRANT)#11 · database
• Query returns empty [] with no error (but the table has data)#17 · database
• Could not find the 'x' column in the schema cache (PGRST204) / column does not exist#25 · database
• infinite recursion detected in policy for relation#28 · database