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

SchemaHero

schemahero.io

  • Free plan
  • Windows
  • macOS
  • Linux
  • Web
  • Self-hosted
8.0 Club score Visit schemahero.io

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.