Schema Management & Migration
40 resources — subcategories Schema Management & Migration
Alembic
A database migrations tool for SQLAlchemy, from the author of SQLAlchemy, with a MySQL dialect implementation.
Archery
A self-hosted SQL review and query platform for MySQL and MariaDB — workflow-gated DDL/DML review and execution, slow-log analysis, backup, and account/parameter management, with partial support for several other databases.

Atlas
A schema-as-code tool for inspecting, diffing, and migrating database schemas — MySQL, MariaDB, and TiDB included — with a declarative, Terraform-style planning workflow.

Atlas Kubernetes Operator
A Kubernetes operator that manages database schemas declaratively with Atlas, supporting MySQL, MariaDB, and other databases.

Azimutt
A database exploration tool with ERDs built for large, messy schemas, plus data navigation, documentation, and database analysis.

Bytebase
A database change-management platform with a GUI/GitOps workflow for reviewing, approving, and rolling out schema migrations, plus SQL linting and access control.

ChartDB
An open source, web-based database diagram editor that reverse-engineers a schema from a single query and can export AI-generated DDL scripts for migrating between MySQL, MariaDB, PostgreSQL, SQL Server, and other dialects.

check_unused_indexes
A Percona Lab tool that flags an index as unused only when every node in a MySQL replication topology agrees, including Aurora readers.
dbmate
A lightweight, framework-agnostic database migration tool with a standalone CLI, plain SQL migration files, and explicit MySQL and MariaDB support alongside PostgreSQL, SQLite, and ClickHouse.
dbsafe
A read-only command-line tool that performs pre-execution safety analysis on MySQL DDL and DML statements, classifying each as Safe, Caution, or Dangerous before you run it in production.

DbSchema
A database design and documentation tool that turns more than 100 SQL and NoSQL databases, including MySQL and MariaDB, into ER diagrams.

drawDB
A free, browser-based database diagram editor and SQL generator with MySQL and MariaDB among its supported databases.

Flyway
Version-controlled database migrations — Flyway applies versioned, repeatable SQL or Java scripts and tracks what's been applied in a metadata table, so every environment's schema stays in sync.

GFS
Git For database Systems — an open-source CLI that brings Git-style commit, branch, checkout, and diff operations to MySQL, PostgreSQL, and SQLite databases, with an MCP server for AI coding agents.

gh-ost
A triggerless online schema migration tool for MySQL, built by GitHub, that produces a lightweight replication-based workload instead of relying on triggers.
golang-migrate
A Go database-migration tool and library — run versioned migrations from the CLI or embed them directly in a Go application, with drivers for MySQL, MariaDB, PostgreSQL, SQLite, and over twenty other databases.

goose
A Go database migration tool — manage schema changes as ordered SQL scripts or Go functions, run from the command line or embedded directly in a Go application as a library.
Large Hadron Migrator
Shopify's fork of SoundCloud's LHM, a Ruby library for online MySQL schema migrations in Rails-style workflows.

Liquibase
An open-core database schema change management tool that tracks, versions, and automates schema deployments and rollbacks, with built-in support for MySQL and MariaDB.

mysqldef (sqldef)
An idempotent schema management tool for MySQL, MariaDB, and TiDB — describe the desired schema as plain SQL and sqldef diffs it against the live database, generating and applying only the DDL needed to converge.

Percona Toolkit
A collection of advanced open source command-line tools, developed and supported by Percona, for MySQL tasks that are too difficult or complex to perform manually.
pgloader
A data loading tool for PostgreSQL that can migrate a full MySQL database, including schema and data, in a single command.

Phinx
A PHP database migrations tool from the CakePHP project, with MySQL among its supported adapters.
redactsql
A local SQL schema anonymizer for MySQL/MariaDB and PostgreSQL — replaces table, column, index, and constraint names with neutral placeholders while preserving structure, so dumps can be shared safely for debugging or bug reports.
schema
A Rust/WebAssembly CLI and viewer that draws interactive ER diagrams and visual git diffs straight from a MySQL dump, Postgres structure.sql, SQLite schema, or Rails schema.rb — no live database connection needed.

SchemaBot
A GitOps schema-migration tool from Block — SQL files in your repo are the source of truth, and SchemaBot plans and applies the diff against MySQL, Vitess on PlanetScale, or (early alpha) PostgreSQL through pull requests or a CLI.

SchemaHero
A Kubernetes Operator for declarative database schema management — define MySQL table schemas as Kubernetes custom resources and let the operator compute and apply the ALTER TABLE statements needed to reconcile the live schema.

SchemaSpy
A standalone, no-GUI Java tool that reads a live database's metadata and generates a browsable HTML report with entity-relationship diagrams — for documenting a MySQL schema without drawing it by hand.

Scythe
A SQL-first code generator that compiles annotated .sql files into type-safe database access code for MySQL, MariaDB, and other engines without needing a live database connection, with built-in formatting, linting, security auditing, and schema-drift detection.
Skeema
A declarative schema management system created specifically for the MySQL ecosystem, with configurable linter and online schema change tool support.
Spirit
A multi-threaded online schema-change and data-migration tool for MySQL 8.0+, built by Block (Cash App) as a faster reimplementation of gh-ost's approach.

Sqitch
A database change management tool that works with native SQL scripts, with support for MySQL 5.1+, MariaDB 10.0+, PostgreSQL, SQLite, and others.

SQL Formatter
A JavaScript library and CLI for pretty-printing SQL, with dedicated MySQL, MariaDB, and TiDB dialects.

SQLE
An SQL quality management and audit platform from ActionTech, with a native audit plugin for MySQL and further plugins for PostgreSQL, Oracle, SQL Server, and DB2.

SQLGlot
A no-dependency Python SQL parser, transpiler, optimizer, and query-building engine that converts SQL between 30+ dialects — including an officially maintained MySQL dialect — and can parse, format, analyze, and programmatically build SQL.
sqlparser-rs
An extensible SQL lexer and parser for Rust, part of the Apache DataFusion project, with a MySQL dialect.

StackRender
A visual database schema design tool with a drag-and-drop diagram UI that exports to MySQL, MariaDB, and other SQL dialects.
tbls
A CI-friendly, single-binary tool that documents a database automatically in GitHub Flavored Markdown and many other output formats.

