Best SQl Schema and Migration Tool

I was looking for a tool kind of between a state-based migration tool and diff based tool.
IE I would like a tool where I define all the tables in schema ie create table this, and it would look at the current database and then use that to autocreate migration files. IF another develop like removes a field from the create table or whatever, it would generate a migration file to drop a column. Please let me know if there is a solution like this. Database Deployments: State or Database Migration? | Liquibase.

2 Likes

I was also wondering if anything like flyway is included in neon database versions.
We need to version the Schema with each change and put it in Git.

This isn’t exactly what you’re looking for, but in my opinion the best migration tools right now are Atlas and Prisma Migrate.