Skip to content

Supabase API errorSupabase “Could not find the table … in the schema cache” (PGRST205)

The app asks Supabase for a table, and the API answers 404 with PGRST205: Could not find the table in the schema cache. It often shows up after an AI builder said it created the table, or when the app points at a different project or branch. Here are the causes in Supabase’s words, and the fix, or hand it over at a fixed price.

Short answer

Supabase’s API can’t see a table with that name. First check the table exists in the project your app’s URL points at, since a migration that never ran, or a staging project, would leave it missing. If it exists, reload the schema cache with NOTIFY pgrst, 'reload schema'; in the SQL Editor. If it lives outside the public schema, expose that schema or name it in the query.

Why the API can’t see the table, and the fix

  1. 01

    The table isn’t in this database

    “Caused when the table specified in the URI is not found.” Supabase, PostgREST error codes

    We also check the obvious first: open the Table Editor of the project your app’s Supabase URL points at, not the one you think it uses. If the table is missing, the migration that creates it didn’t run there. Run it against that project, and check the staging project as well.

  2. 02

    The schema cache hasn’t caught up

    “To refresh your PostgREST schema, go to your project Dashboard, and open the SQL Editor.” Supabase, Reload/refresh postgrest schema

    The API keeps a cache of your tables. If the table exists but the API still can’t see it, reload the cache from the SQL Editor:

    NOTIFY pgrst, 'reload schema';
  3. 03

    The table is in another schema

    “When multiple schemas are exposed, the first entry in the list is treated as the default, so PostgREST resolves unqualified object names only against that schema.” Supabase, PostgREST not recognizing objects in schema

    Only the public schema is exposed by default. A custom schema has to be added to Exposed schemas in the API settings and granted to the API roles. With several exposed schemas, a table outside the default one needs .schema('your_schema') in the query, or the client created with that schema.

Checked against the vendor’s docs on : Supabase docs: PostgREST error codes; Supabase troubleshooting: Reload the PostgREST schema; Supabase troubleshooting: Objects in an exposed schema; Supabase docs: Using custom schemas.

Rather hand it over?

Fixed scope, fixed price, paid upfront. The work happens in writing; no call needed.

Related: Supabase migration failed (db push) · Supabase staging environment · Supabase project paused · Supabase public storage bucket

Questions

More on this error

Does this mean my data was deleted?

Not by itself. Supabase describes PGRST205 as the table in the request not being found, so first check you’re looking at the same project and branch as the app before assuming anything is gone.

Is a missing column the same error?

No. Supabase lists a missing column as PGRST204. Both can come from a migration that didn’t run, so the same first check applies.

Can you fix it for me?

If one bug is the whole problem, the App Fix Ticket covers it: a written diagnosis first, then the fix. If the app has more going on, the Launch Check is a written check of the whole app. Each issue found is rated critical, high, medium or low, with where it is and how it was confirmed. No issues worth fixing, no charge. If the Launch Check finds nothing rated medium or higher, Simon refunds the full $450. You keep the report either way.

A different error?

Describe it and get a written quote

Send the error and what you were doing. You get a written scope, a fixed price and a timeline; we reply by email, usually within one business day.