fix-migrations

To fix corrupted Drizzle migrations on a local PostgreSQL database, stash your current migration files, generate a new migration that includes the vector extension, apply it to the database, and then restore the original migration files to ensure schema consistency.

Drizzle database migrations break locally when a migration fails and leaves the PostgreSQL schema in an inconsistent state compared to the project's schema definition, requiring a full database reset to resolve.

Reset your local database state without losing Drizzle schema files by temporarily stashing the current migration files, applying a clean generated migration, and then restoring the original files to their original location.

Yes, the Drizzle migration fix script explicitly supports the PostgreSQL vector extension by generating a new migration that includes the vector extension before applying it to reset the local database.

Reset your local PostgreSQL database instead of rolling back migrations when the schema is left in an inconsistent state that cannot be resolved by standard rollback procedures, ensuring it matches the current schema definition.