sqldef/sqldef

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

3146 stars · 243 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

sqldef is a single-binary CLI tool for idempotent, declarative database schema management using plain SQL DDL files. It diffs the desired schema against the current database schema and generates the migrations needed to reach the desired state, with per-database commands for MySQL/MariaDB/TiDB, PostgreSQL, SQLite3, and SQL Server.

Use cases

• manage database schema as a single SQL file
• generate migrations from desired schema instead of writing them by hand
• diff two SQL schema files offline in CI
• apply idempotent schema changes safe to run repeatedly
• export current database schema to SQL
• preview DDL changes with a dry run before applying
• validate that database schema matches the schema file in CI/CD

When to choose

• you prefer plain SQL DDL over ORM or DSL-based migration tools
• you want declarative, idempotent schema management across MySQL, PostgreSQL, SQLite, and SQL Server
• you need a dependency-free single binary for schema drift detection in CI pipelines
• you want to generate up (and down) migration DDLs by diffing schema files

When to avoid

• you need versioned, sequential migration files with rollback history
• your workflow depends on ORM-managed migrations (e.g., Rails, Django, Alembic)
• you use a database other than MySQL/MariaDB/TiDB, PostgreSQL, SQLite3, or SQL Server

Facets

cli-tool · maturity active

database developer-tools cli databases developer-tools windows cli wasm schema-migration declarative-migrations idempotent mysql postgresql sqlite sql-server mariadb tidb ddl-diff devops linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="sqldef/sqldef")