sqldef
Idempotent schema management tool for MySQL, PostgreSQL, SQLite, and SQL Server using plain SQL DDLs.
What is sqldef?
sqldef is a command-line tool for idempotent database schema management across multiple database systems including MySQL, PostgreSQL, SQLite, and SQL Server. It allows developers to define their desired database schema in plain SQL DDLs, and automatically generates and applies the necessary migration scripts to achieve that state from any current schema. The tool ensures operations are safe to run multiple times and eliminates the need to manually write ALTER TABLE statements.
Database administrators, backend engineers, and DevOps practitioners who need to manage and version database schemas across development, staging, and production environments, especially in teams using multiple database technologies.
Developers choose sqldef because it uses plain SQL—a familiar language—instead of a custom DSL, supports multiple major databases with consistent workflows, provides idempotent operations for safety, and offers a simple single-binary distribution with no dependencies.
Overview
Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server
Use Cases
Best For
- Managing schema migrations across MySQL, PostgreSQL, SQLite, and SQL Server with a single tool
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
