https://sqldef.github.io/

sqldef

sqldef is a CLI tool for diffing two SQL schemas. You can use it to
manage the migration of RDBMSs using regular SQL DDLs.

Supported databases: MySQL, MariaDB, TiDB, PostgreSQL, SQL Server,
and SQLite3.

Online Demo

[MySQL     ] [ ] Enable DROP

Current schema

[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]

Desired schema

[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]
Up (current - desired)

 

Down (desired - current)

 

How It Works

The online demo uses the WebAssembly build of sqldef to diff two SQL
schemas and generate DDLs.

 

https://github.com/sqldef/sqldef