- Home
- Database Migration Tools
- sqldef
On the recordRead 4 Oct 202622 facts
sqldef
On the record
- Audience
- The README describes a workflow for database schema changes that uses a single SQL file containing the complete schema.github.com · read 4 Oct 2026
- Browser demo
- The online demo uses a WebAssembly build to diff two SQL schemas and generate DDLs.sqldef.github.io · read 4 Oct 2026
- Distribution
- The project provides pre-built single-binary executables and Docker images.github.com · read 4 Oct 2026
- Idempotency
- The README says sqldef operations are idempotent and safe to run multiple times.github.com · read 4 Oct 2026
- Idempotent operations
- The project says its operations are safe to run multiple times.github.com · read 4 Oct 2026
- Integration
- A GitHub Action is available to preview database schema changes.github.com · read 4 Oct 2026
- Integrations
- The README links to a GitHub Action that previews database schema changes.github.com · read 4 Oct 2026
- License
- The sqldef source files are distributed under the MIT License, while the parser is distributed under Apache License 2.0.github.com · read 4 Oct 2026
- Linux limitation
- The project says Debian packages are not currently available and recommends pre-built binaries or Docker images instead.github.com · read 4 Oct 2026
- Linux package limitation
- The README says Debian packages are not currently available and directs Linux users to pre-built binaries or Docker images.github.com · read 4 Oct 2026
- Migration preview
- The --dry-run option shows migrations without executing them.github.com · read 4 Oct 2026
- Offline mode
- It can compare two SQL files without connecting to a database, including for CI/CD, schema validation, and migration script generation.github.com · read 4 Oct 2026
- Online demo
- The official site says its online demo uses a WebAssembly build of sqldef to diff schemas and generate DDLs.sqldef.github.io · read 4 Oct 2026
- Preview and offline modes
- sqldef can preview migrations without executing them and compare SQL files without connecting to a database.github.com · read 4 Oct 2026
- Purpose
- sqldef is a CLI tool for diffing SQL schemas and managing RDBMS migrations with regular SQL DDLs.sqldef.github.io · read 4 Oct 2026
- Rename support
- The README says the @renamed annotation supports renaming tables, columns, indexes, and ENUM values.github.com · read 4 Oct 2026
- Schema workflow
- Users define a desired schema in SQL, and sqldef generates and applies migrations to bring the database to that state.github.com · read 4 Oct 2026
- Security and licensing
- The README states that sqldef source files are distributed under the MIT License, except the parser, which is under Apache License 2.0.github.com · read 4 Oct 2026
