Technology · Ebook

SchemaHero: Declarative Database Schema Management for Kubernetes

by Shriira Press

SchemaHero is a CNCF sandbox project that reimagines database schema migrations as a declarative, Kubernetes-native problem. Instead of hand-writing ordered migration scripts that must stay compatible across every environment, you describe the table you want — its columns, keys, and indexes — in a custom resource, and SchemaHero's operator diffs that declaration against the live database and generates the exact DDL to close the gap. This book covers the migration problem, the operator and its Database, Table, and Migration resources, modeling real schemas with foreign keys and seed data, the plan-approve-apply review workflow, the engines SchemaHero speaks from Postgres to Cassandra, and how it fits a GitOps practice so your schema lives in version control like the rest of your infrastructure.

Contents

1. 1Preface
2. 2Chapter 1 — The Trouble with Migrations
3. 3Chapter 2 — A Declarative Approach
4. 4Chapter 3 — Architecture and the Operator
5. 5Chapter 4 — Modeling Tables
6. 6Chapter 5 — Plan, Approve, Apply
7. 7Chapter 6 — Databases and Engines
8. 8Chapter 7 — SchemaHero in Practice