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

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

Atlas Kubernetes Operator

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

Azimutt

Azimutt

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

Bytebase

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

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

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

DbSchema

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

drawDB

drawDB

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

Flyway

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

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

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

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

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)

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

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

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

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

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

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

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

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

SQL Formatter

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

SQLE

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

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.

sqruff

sqruff

A fast SQL linter and formatter written in Rust, with a MySQL dialect.

StackRender

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.

Yearning

Yearning

A self-hosted SQL audit platform for MySQL with ticket-based approval workflows, automated syntax checks, rollback statement generation, and query auditing.