Back Original

Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite

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

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.