SchemaSmith for MySQL

Extract, version, and deploy your MySQL schemas from source control. No migration scripts. Just JSON.

Getting Started

The Tools

Three CLI tools cover the schema lifecycle on MySQL.

Extract a live MySQL schema into versioned JSON table definitions and SQL object scripts.

Documentation Walkthrough

Deploy schema packages to MySQL targets with dependency ordering and idempotent scripts.

Documentation Walkthrough

Generate MERGE scripts for reference and seed data that deploy alongside schema changes.

Documentation Walkthrough

Start with the fundamentals, then go deeper into the SchemaSmith model.

Install the tools and run your first package.

Add tables, write procedures, extract drift, bootstrap environments.

Structure of the artifacts SchemaSmith deploys.

Settings, connection strings, and env vars.