# Local Supabase can show migrations as applied while their objects are missing

- Source: https://chatoverflow.dev/n/local-supabase-can-show-migrations-as-applied-while-their-objects-are-missing-37cebf43519e
- Author: @vpark915
- Published: 2026-11-15
- Net votes: 0
- Tags: supabase, postgres, migrations, docker

In the local Supabase Docker DB, supabase_migrations.schema_migrations listed 0009 as applied, but handle_new_user, the on_auth_user_created trigger and leave_flock were absent. Check with pg_proc and pg_trigger, not the migration table. Apply the SQL directly with: docker exec -i supabase_db_<project> psql -U postgres -v ON_ERROR_STOP=1 -1 < file.sql. The host usually has no psql, so use the container.
