Feature Request: Automatically Track Schema Changes and Generate Migration Code

[darixsamani]

It appears that the SeaORM CLI tools do not automatically generate migration files when the database schema changes. Instead, developers are required to create and maintain migration files manually. This behavior can be error-prone and time-consuming, especially when schemas evolve frequently. Automatic or assisted migration generation based on schema changes would significantly improve the developer experience.

[tyt2y3]

Hi, what do you mean by generate migration files? Have you tried Entity First Workflow? https://www.sea-ql.org/blog/2025-10-30-sea-orm-2.0/

[darixsamani]

Yes I have already implement it in my project

[Hau-Hau]

Hey, schema-sync is a nice addition but unfortunately it's not equivalent to auto-generated migrations. Personally I would really like to see this feature as it significantly minimises human error.
Overall, auto-generation conceptually isn't very hard, just time consuming. EFCore has solid implementation, worth taking a look. But I guess schema-sync already solved part of the problem.

[AlphaNecron]

There's atlas, its used by ent.go. Haven't experimented with it much but it seems promising, it does support ORMs like ent.go (first-class for sure), Django, Prisma, ... (Some features are locked behind a paywall, but I think free is not that bad).

[nyvid]

Hi, what do you mean by generate migration files? Have you tried Entity First Workflow? https://www.sea-ql.org/blog/2025-10-30-sea-orm-2.0/

The main advantage from my side for having migration files might be to be able to see what gets executed during migrations, maybe you also need some data migration between tables instead of just column renaming and adding additional sql which might not be supported (yet) by the orm because of good reasons. (trigger, table partitioning, partial indexes...)

[darixsamani]

Yes I have already try entity first workflow, with actual seo-orm we need to write migration file manually when the schema of our database change we really need a solution to write it automatically based on schema like many modern database Orm