Prisma Migrate uses the Prisma schema to determine what features to create in the database. However, some database features cannot be represented in the Prisma schema , including but not limited to:
- Stored procedures
- Partial indexes
To add an unsupported feature to your database, you must customize a migration to include that feature before you apply it.
To customize a migration to include an unsupported feature:
--create-onlyflag to generate a new migration without applying it:$npx prisma migrate dev --create-only
Open the generated
migration.sqlfile and add the unsupported feature - for example, a partial index:CREATE UNIQUE INDEX tests_success_constraintON posts (subject, target)WHERE success;
Apply the migration:$npx prisma migrate dev
Commit the modified migration to source control.