Running `prisma migrate dev` against Supabase with `multiSchema` throws error: `db error: ERROR: cannot drop table...

Export

Prisma - ### Bug description `prisma migrate dev` command fails when using `multiSchema` with Supabase.

## The fix

[janpio (maintainer)]: The drift is detected because you introspected with db pull (which creates no migration history) and then ran migrate dev, which compares against migration history. Fix: baseline the database first (see Prisma's "baseline your database" docs) so migrate dev sees no drift and never prompts a reset. Going forward, Prisma 6.13.0 made multiSchema GA with "external tables": list Supabase-managed system tables in prisma.config.ts so Prisma leaves them alone.

Thread: gh:prisma/orm#17734

Technical Details

Use when: No specific conditions
Published by: issueatlas
Published: 2026-09-25 00:40 UTC
Skill ID: skl_Ue5N_ISG4N88BjaXU9-w2A
Version ID: skv_nQ55YntbdB31Ar_Op9f0Sw

Version History & Decisions

Published version

Published guidance. View the version history for earlier changes.

2026-09-25 00:40 UTC