SchemaHero
schemahero.io
- Free plan
- Windows
- macOS
- Linux
- Web
- Self-hosted
What SchemaHero is
SchemaHero is a free, open-source database schema migration tool that turns declared schema definitions into migration SQL. Its CLI compares a database with YAML definitions during plan, showing the SQL without changing the database; apply executes those changes. Because SQL is calculated from the current and desired schemas, numbered migration files are not required. SchemaHero supports PostgreSQL, MySQL, CockroachDB, TimescaleDB, Cassandra, SQLite, and RQLite. Table definitions can include columns, primary keys, indexes, foreign keys, defaults, and constraints. The project is available as binaries for macOS, Linux, and Windows, as a Docker image, and as an optional Kubernetes Operator. The CLI works without Kubernetes. Documentation covers GitHub Actions, GitLab CI, Argo CD, and Flux. Policies can detect destructive changes and fail CI checks.
Who it suits
It suits developers and platform teams managing declarative database changes across supported engines. Teams can use the standalone CLI, Docker, CI workflows, or optional Kubernetes deployment.
Good to know, and what to watch
- Free and open-source under Apache-2.0
- Plans and applies generated SQL changes
- No numbered migration files required
- Supports seven listed database engines
- Destructive changes can fail CI checks
- Kubernetes Operator is optional, not required
- Database support is limited to listed engines
The verdict
SchemaHero provides a declarative plan-and-apply workflow without numbered migration files. Its broad deployment options and CI integrations fit teams that want schema changes represented as YAML and generated SQL.
What the maker publishes
- CI/CD
- SchemaHero documents GitHub Actions and GitLab CI workflows for planning and applying schema changes. source
- CI integrations
- SchemaHero documents GitHub Actions and GitLab CI workflows for planning and applying schema changes. source
- Cloud database connections
- Connection guidance covers AWS RDS, AWS SSM, Google Cloud SQL and HashiCorp Vault. source
- Cloud integrations
- Database connection documentation includes AWS RDS, AWS SSM, Google Cloud SQL, and HashiCorp Vault. source
- Community support
- The project directs users to the Replicated Community forum and the #schemahero channel in Kubernetes Slack. source
- Database support
- Supported database engines listed by SchemaHero are PostgreSQL, MySQL, CockroachDB, TimescaleDB, Cassandra, SQLite and RQLite. source
- Declarative workflow
- It compares a desired YAML schema with the current database schema and generates the SQL needed to synchronize them. source
- Deployment modes
- SchemaHero is provided as a CLI utility and a Kubernetes Operator. source
- Docker
- The schemahero/schemahero Docker image contains the CLI and can run in any CI system that supports Docker. source
- GitOps integrations
- SchemaHero documents GitOps integration with Argo CD and Flux. source
- Installation
- SchemaHero is distributed as a single binary for macOS, Linux and Windows, and is also available as a Docker image. source
- Install platforms
- The project provides installation instructions for macOS, Linux, Windows, Docker, and optional Kubernetes deployment. source
- Interfaces
- SchemaHero is provided as a CLI utility and a Kubernetes Operator. source
- Kubernetes approvals
- The Kubernetes Operator can create Migration resources, wait for approval, and support approve or reject workflows. source
- Kubernetes requirement
- The CLI works standalone without Kubernetes, and the operator is optional. source
- License
- The GitHub repository is licensed under Apache-2.0. source
- Migration files
- SchemaHero does not require numbered migration files because it calculates the SQL needed to move the database from its current state to the declared schema. source
- Migration safety
- Migration policies can detect destructive changes such as dropping columns or tables and fail CI checks. source
- Origin
- Replicated introduced SchemaHero as an open-source project on August 24, 2019. source
- Plan and apply
- The plan phase reads the database and outputs SQL without changing the database, while apply executes the generated SQL. source
- Plan/apply workflow
- The plan command compares the current database schema with YAML definitions and outputs SQL, while apply executes that SQL. source
- Purpose
- SchemaHero is an open-source database schema migration tool that converts schema definitions into migration scripts. source
- Schema capabilities
- Table definitions can specify columns, primary keys, indexes, foreign keys, defaults, and constraints. source
- Security controls
- Database connections support SSL modes including require and verify-full, and Kubernetes credentials can be stored in Secrets. source
Checked against the maker's pages on 1 Oct 2026.