SchemaHero

Spec sheet

What it does

SchemaHero is an open-source database schema migration tool that converts schema definitions into migration scripts usable in any environment.Read 1 Oct 2026 · schemahero.io

Purpose

SchemaHero is an open-source database schema migration tool that converts schema definitions into migration scripts.Read 1 Oct 2026 · schemahero.io

Support

The project directs users to a Replicated Community forum and the #schemahero channel in Kubernetes Slack.Read 1 Oct 2026 · github.com

License

The GitHub repository is licensed under Apache-2.0.Read 1 Oct 2026 · github.com

CI integrations

SchemaHero documents GitHub Actions and GitLab CI workflows for planning and applying schema changes.Read 1 Oct 2026 · schemahero.io

CI/CD

SchemaHero documents GitHub Actions and GitLab CI workflows for planning and applying schema changes.Read 1 Oct 2026 · schemahero.io

Cloud database connections

Connection guidance covers AWS RDS, AWS SSM, Google Cloud SQL and HashiCorp Vault.Read 1 Oct 2026 · schemahero.io

Cloud integrations

Database connection documentation includes AWS RDS, AWS SSM, Google Cloud SQL, and HashiCorp Vault.Read 1 Oct 2026 · schemahero.io

Community support

The project directs users to the Replicated Community forum and the #schemahero channel in Kubernetes Slack.Read 1 Oct 2026 · github.com

Database support

Supported database engines listed by SchemaHero are PostgreSQL, MySQL, CockroachDB, TimescaleDB, Cassandra, SQLite and RQLite.Read 1 Oct 2026 · schemahero.io

Declarative workflow

It compares a desired YAML schema with the current database schema and generates the SQL needed to synchronize them.Read 1 Oct 2026 · schemahero.io

Deployment modes

SchemaHero is provided as a CLI utility and a Kubernetes Operator.Read 1 Oct 2026 · schemahero.io

Docker

The schemahero/schemahero Docker image contains the CLI and can run in any CI system that supports Docker.Read 1 Oct 2026 · schemahero.io

GitOps integrations

SchemaHero documents GitOps integration with Argo CD and Flux.Read 1 Oct 2026 · schemahero.io

Install platforms

The project provides installation instructions for macOS, Linux, Windows, Docker, and optional Kubernetes deployment.Read 1 Oct 2026 · schemahero.io

Installation

SchemaHero is distributed as a single binary for macOS, Linux and Windows, and is also available as a Docker image.Read 1 Oct 2026 · schemahero.io

Interfaces

SchemaHero is provided as a CLI utility and a Kubernetes Operator.Read 1 Oct 2026 · schemahero.io

Kubernetes approvals

The Kubernetes Operator can create Migration resources, wait for approval, and support approve or reject workflows.Read 1 Oct 2026 · schemahero.io

Kubernetes requirement

The CLI works standalone without Kubernetes, and the operator is optional.Read 1 Oct 2026 · schemahero.io

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.Read 1 Oct 2026 · schemahero.io

Migration safety

Migration policies can detect destructive changes such as dropping columns or tables and fail CI checks.Read 1 Oct 2026 · schemahero.io

Origin

Replicated introduced SchemaHero as an open-source project on August 24, 2019.Read 1 Oct 2026 · replicated.com

Plan and apply

The plan phase reads the database and outputs SQL without changing the database, while apply executes the generated SQL.Read 1 Oct 2026 · schemahero.io

Plan/apply workflow

The plan command compares the current database schema with YAML definitions and outputs SQL, while apply executes that SQL.Read 1 Oct 2026 · schemahero.io

Schema capabilities

Table definitions can specify columns, primary keys, indexes, foreign keys, defaults, and constraints.Read 1 Oct 2026 · schemahero.io

Security controls

Database connections support SSL modes including require and verify-full, and Kubernetes credentials can be stored in Secrets.Read 1 Oct 2026 · schemahero.io

Supported databases

Supported database engines are PostgreSQL, MySQL, CockroachDB, TimescaleDB, Cassandra, SQLite, and RQLite.Read 1 Oct 2026 · schemahero.io

TLS options

PostgreSQL connections support sslmode disable, require, and verify-full options.Read 1 Oct 2026 · schemahero.io

Where Specifiction places it

• Database Migration Tools#24 of 327.4