sqldef
sqldef.github.io
- Windows
- macOS
- Linux
- Web
- Self-hosted
7.1 Club score Visit sqldef.github.io
What the maker publishes
- Audience
- The README describes a workflow for database schema changes that uses a single SQL file containing the complete schema. source
- Browser demo
- The online demo uses a WebAssembly build to diff two SQL schemas and generate DDLs. source
- Distribution
- The project provides pre-built single-binary executables and Docker images. source
- Idempotency
- The README says sqldef operations are idempotent and safe to run multiple times. source
- Idempotent operations
- The project says its operations are safe to run multiple times. source
- Integration
- A GitHub Action is available to preview database schema changes. source
- Integrations
- The README links to a GitHub Action that previews database schema changes. source
- License
- The sqldef source files are distributed under the MIT License, while the parser is distributed under Apache License 2.0. source
- Linux limitation
- The project says Debian packages are not currently available and recommends pre-built binaries or Docker images instead. source
- Linux package limitation
- The README says Debian packages are not currently available and directs Linux users to pre-built binaries or Docker images. source
- Migration preview
- The --dry-run option shows migrations without executing them. source
- Offline mode
- It can compare two SQL files without connecting to a database, including for CI/CD, schema validation, and migration script generation. source
- Online demo
- The official site says its online demo uses a WebAssembly build of sqldef to diff schemas and generate DDLs. source
- Platforms
- The releases page lists downloadable binaries for Windows, macOS (Darwin), and Linux. source
- Preview and offline modes
- sqldef can preview migrations without executing them and compare SQL files without connecting to a database. source
- Purpose
- sqldef is a CLI tool for diffing SQL schemas and managing RDBMS migrations with regular SQL DDLs. source
- Rename support
- The README says the @renamed annotation supports renaming tables, columns, indexes, and ENUM values. source
- Schema workflow
- Users define a desired schema in SQL, and sqldef generates and applies migrations to bring the database to that state. source
- 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. source
- Support
- The project invites feature requests through pull requests or GitHub Discussions. source
- Supported databases
- The site lists MySQL, MariaDB, TiDB, PostgreSQL, SQL Server, and SQLite3 as supported databases. source
- Workflow
- It compares a desired schema with the current schema and generates and applies DDLs to update the database. source
Checked against the maker's pages on 4 Oct 2026.