Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

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.