How can I get clean solution for migrations in Node.js?

Question

I want simple schema editor, where I can add/change sql schema, preferably simple GUI that generates update/alter/etc commands and it'd generate up/down migrations which then can also be ran then on prod.

manx · Accepted Answer

Have a look at https://prisma.io or https://atlasgo.io

2color · Answer

Check out Prisma Migrate. It's a schema migrations tool that allows you to declare your schema declaratively using the Prisma schema language and generate SQL migrations for that you can edit: https://www.prisma.io/migrate