What support does Liquibase have for MySQL?

Last updated: July 14, 2025

MySQL is a fast, multi-user SQL database service. MySQL Server is intended for mission-critical, heavy-load production systems and embedding into mass-deployed software. For more information, see the MySQL documentation page.

Verified database versions

MySQL Server

AWS Aurora – MySQL

AWS RDS – MySQL

Azure Database for MySQL

Google Cloud SQL – MySQL

When you run a command like generate-changelog or snapshot-reference, Liquibase maps data from your database onto the Liquibase output, like the data type of a column.

By default, Boolean types in MySQL map to TINYINT(1):

In Liquibase 4.23.2 and earlier, Liquibase maps Boolean types to BIT by default.
In Liquibase 4.24.0 and 4.25.0, Liquibase maps Boolean types to TINYINT(1) by default.
In Liquibase 4.25.1, Liquibase maps Boolean types to TINYINT (without length) by default.
In Liquibase 4.26.0 and later, Liquibase maps Boolean types to TINYINT(1) by default.

For more information, see Liquibase Data Type Handling.

Supported Change Types

Change Type	Supported
addAutoIncrement	Supported
addCheckConstraint	Not Supported
addColumn	Supported
addDefaultValue	Supported
addForeignKeyConstraint	Supported
addLookupTable	Supported
addNotNullConstraint	Supported
addPrimaryKey	Supported
addUniqueConstraint	Supported
alterSequence	Not Supported
createFunction	Supported
createIndex	Supported
createPackage	Supported
createPackageBody	Supported
createProcedure	Supported
createSequence	Not Supported
createSynonym	Not Supported
createTable	Supported
createTrigger	Supported
createView	Supported
customChange	Supported
delete	Supported
disableCheckConstraint	Not Supported
disableTrigger	Not Supported
dropAllForeignKeyConstraints	Supported
dropCheckConstraint	Not Supported
dropColumn	Supported
dropDefaultValue	Supported
dropForeignKeyConstraint	Supported
dropFunction	Supported
dropIndex	Supported
dropNotNullConstraint	Supported
dropPackage	Supported
dropPackageBody	Supported
dropPrimaryKey	Supported
dropProcedure	Supported
dropSequence	Not Supported
dropSynonym	Not Supported
dropTable	Supported
dropTrigger	Supported
dropUniqueConstraint	Supported
dropView	Supported
enableCheckConstraint	Not Supported
enableTrigger	Not Supported
executeCommand	Supported
insert	Supported
loadData	Supported
loadUpdateData	Supported
markUnused	Not Supported
mergeColumns	Supported
modifyDataType	Supported
output	Supported
renameColumn	Supported
renameSequence	Not Supported
renameTable	Supported
renameTrigger	Not Supported
renameView	Supported
setColumnRemarks	Supported
setTableRemarks	Supported
sql	Supported
sqlFile	Supported
stop	Supported
tagDatabase	Supported
update	Supported

Supported commands

Command	Supported
calculate-checksum	Supported
changelog-sync	Supported
changelog-sync-sql	Supported
changelog-sync-to-tag	Supported
changelog-sync-to-tag-sql	Supported
clear-checksums	Supported
db-doc	Supported
diff	Supported
diff JSON	Supported
diff-changelog	Supported
drop-all	Supported
future-rollback-count-sql	Supported
future-rollback-from-tag-sql	Supported
future-rollback-sql	Supported
generate-changelog	Supported
help	Supported
history	Supported
list-locks	Supported
mark-next-changeset-ran	Supported
mark-next-changeset-ran-sql	Supported
release-locks	Supported
rollback	Supported
rollback-count	Supported
rollback-count-sql	Supported
rollback-one-changeset	Supported
rollback-one-changeset-sql	Supported
rollback-one-update	Supported
rollback-one-update-sql	Supported
rollback-sql	Supported
rollback-to-date	Supported
rollback-to-date-sql	Supported
snapshot	Supported
snapshot-reference	Supported
status	Supported
tag	Supported
tag-exists	Supported
unexpected-changesets	Supported
update	Supported
update-sql	Supported
update-count	Supported
update-count-sql	Supported
update-testing-rollback	Supported
update-to-tag	Supported
update-to-tag-sql	Supported
validate	Supported