Hey engineers
Schema evolution is still one of the most painful parts of backend / database development.
I tried multiple tools and workflows (ORM auto-migrations, schema diff tools, etc.), but most of them either add complexity, or hit limitations where you eventually end up writing migrations manually anyway , especially when you care about safe production changes.
So I started building a tool around a simple idea:
Design your database as an ER diagram, track diagram changes over time, and automatically generate production-ready migrations from the diff.
I like to call this approach visual-first database migrations.
<h2>1 . How it works</h2>
<ul>
<li>You start with an empty diagram (or import an existing database).</li>
<li>StackRender generates the base migration for you, deploy it and you’re done.</li>
<li>Later, whenever you want to update your database, you go back to the diagram and edit it (add tables, edit columns, rename fields, add FK constraints, etc).</li>
<li>StackRender automatically generates a new migration containing only the schema changes you made. Deploy it and keep moving.</li>
</ul>
<h2>2 . Migrations include UP + DOWN scripts</h2>
Each generated migration contains two scripts:
<ul>
<li>UP → applies the changes and moves your database forward</li>
<li>DOWN → rolls back your database to the previous version</li>
</ul>
Migration up script :
<img src="https://media.daily.dev/image/fetch/s--lpDjXjjS--/f_auto,q_auto/https://media2.dev.to/dynamic/image/width%3D800%252Cheight%3D%252Cfit%3Dscale-down%252Cgravity%3Dauto%252Cformat%3Dauto/https%253A%252F%252Fdev-to-uploads.s3.amazonaws.com%252Fuploads%252Farticles%252Fmkthf0hk12kacjomrpbn.png?_a=BAMAMiiu0" alt="StackRender database migration up-script">
Migration rollback script :
<img src="https://media.daily.dev/image/fetch/s--crS0zG43--/f_auto,q_auto/https://media2.dev.to/dynamic/image/width%3D800%252Cheight%3D%252Cfit%3Dscale-down%252Cgravity%3Dauto%252Cformat%3Dauto/https%253A%252F%252Fdev-to-uploads.s3.amazonaws.com%252Fuploads%252Farticles%252Fdtipil1i9vac1anoeyq3.png?_a=BAMAMiiu0" alt="StackRender database migration down-script">
<h2>3 . Visual-first vs Code-first database migrations</h2>
Most code-first migration tools (like Node.js ORMs such as Prisma, Sequelize, Drizzle, etc.) infer schema changes from code.
That approach works well up to a point, but it can struggle with more complex schema changes. For example:
<ul>
<li>❌ Some tools may not reliably detect column renames (often turning them into drop + recreate)</li>
<li>❌ Some struggle with Postgres-specific operations like ENUM modifications, etc.</li>
</ul>
StackRender’s visual-first approach uses a state-diff engine to detect schema changes accurately at the moment you make them in the diagram, and generates the correct migration steps.
<h2>4 . What can it handle?</h2>
✅ Table changes
<ul>
<li>Create / drop</li>
<li>Rename (proper rename not drop + recreate)</li>
</ul>
✅ Column changes
<ul>
<li>Create / drop</li>
<li>Data type changes</li>
<li>Alter: nullability, uniqueness, PK constraints, length, scale, precision, charset, collation, etc.</li>
<li>Rename (proper rename not drop + recreate)</li>
</ul>
✅ Relationship changes
<ul>
<li>Create / drop</li>
<li>FK action changes (ON DELETE / ON UPDATE)</li>
<li>Renaming</li>
</ul>
✅ Index changes
<ul>
<li>Create / drop</li>
<li>Rename (when supported by the database)</li>
<li>Add/remove indexed columns</li>
</ul>
✅ Postgres types (ENUMs)
<ul>
<li>Create / drop</li>
<li>Rename</li>
<li>Add/remove enum values</li>
</ul>
If you’re working with Postgres or MySQL, I’d love for you to try it out.
And if you have any feedback , I’m all ears 🙏
Try it free online:
<a href="http://stackrender.io" target="_blank" rel="noopener nofollow">stackrender.io</a>
GitHub:
<a href="https://github.com/stackrender/stackrender" target="_blank" rel="noopener nofollow">github.com/stackrender/stackrender</a>
Schema change complete guide for developers :
<a href="https://stackrender.io/guides/schema-change-guide" target="_blank" rel="noopener nofollow">Guide</a>
Much love ❤️ , Thank you!

A dedicated squad for devtools: discussions, recommendations and questions. 

Dev Tools

StackRender V1.1.0 introduces a visual-first approach to database migrations by generating production-ready migration scripts from ER diagram changes. The tool tracks diagram modifications over time and automatically creates UP/DOWN migration scripts, handling complex operations like proper column renames, ENUM modifications, and relationship changes. It supports PostgreSQL and MySQL, addressing limitations in traditional ORM-based migration tools that struggle with detecting certain schema changes accurately.

StackRender V1.1.0 : Generate Database Migrations from ER Diagram Changes