MySQL Database Migrations

State-based deployments for MySQL teams who want schema as code without writing migration scripts

Get Started Purchase License

MySQL support available in Enterprise Edition

Also available for SQL Server (free Community Edition) and PostgreSQL

SchemaSmith Development Cycle

Why State-Based Migrations for MySQL?

Traditional MySQL Migrations

  • Write migration files for every DDL change
  • Track migration history across environments
  • Handle constraint dependencies manually
  • Discover drift only when deployments fail
  • Rollbacks require separate down migrations

State-Based with SchemaSmith

  • Define your desired schema state in JSON
  • Deploy any state to any environment
  • Constraints and dependencies handled
  • Drift detected and corrected automatically
  • Rollback by deploying a prior release

How SchemaSmith Works with MySQL

1. Extract with SchemaTongs

Connect to your MySQL database and extract tables, views, functions, triggers, events, and more into human-readable JSON metadata.

2. Edit with SchemaHammer

Use the visual metadata editor to modify tables, add columns, define indexes. Or edit JSON directly in your IDE.

3. Deploy with SchemaQuench

SchemaQuench compares metadata to your MySQL database and generates the necessary DDL. Idempotent and CI/CD ready.

Built for MySQL

Full Object Support

Tables, views, functions, triggers, events, indexes, constraints, and schemas. SchemaSmith handles the MySQL objects your applications depend on.

Drift Detection

Detect when production doesn't match your source of truth. SchemaQuench identifies differences and brings databases back into compliance.

Multi-Tenant Ready

Deploy the same schema to hundreds of MySQL databases. Define one template, update all instances in parallel.

Works with MySQL 8.0+

Tested and supported on MySQL 8.0 and higher. Full support for InnoDB features, generated columns, and modern MySQL capabilities.

MySQL Support in Enterprise Edition

SchemaSmith for MySQL is available in the Enterprise Edition, which includes:

  • SchemaTongs for MySQL
  • SchemaQuench for MySQL
  • DataTongs for seed data
  • SchemaHammer visual editor
  • SQL Server + PostgreSQL included
  • Unlimited databases
  • Unlimited users
  • $5,000/year flat rate
See All Enterprise Features MySQL Documentation

Compare Migration Approaches

Understand how state-based deployments differ from traditional migration tools:

vs Liquibase
vs Flyway
State-Based vs Script-Based: Which Approach?