Skip to content
SPECIFICTION
Get listed

sqldef

sqldef.github.io

WebWindowsmacOSLinuxSelf-hosted
Visit sqldef.github.io
Spec score 7.2 #26 of 32 in Database Migration Tools

Spec sheet

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

Where Specifiction places it

Alternatives to sqldefAll alternatives →