Real-time monitoring for Liquibase database changes is here!

Liquibase relies on the community to ensure broad database support. The table below lists the databases that have been reported to work for users out-of-the-box. If you’re looking for guaranteed or certified support for a particular database, go to Liquibase.com for information. 

Additional databases, as well as enhancements for the below databases, are available through Liquibase extensions.

Check out our specific database tutorials for how Liquibase works with all of the databases below.

Database Type Name Notes
MySQL mysql No Issues
MariaDB mariadb MariaDB is 100% compatible with MySQL per MariaDB developers
PostgreSQL postgresql 8.2+ is required to use the “drop all database objects” functionality.
Oracle oracle 11g driver is required when using the diff tool on databases running with AL32UTF8 or AL16UTF16
SQL Server mssql No Issues
Azure SQL mssql No Issues
Sybase_Enterprise sybase ASE 12.0+ required. “select into” database option needs to be set. Best driver is JTDS. Sybase does not support transactions for DDL so rollbacks will not work on failures. Foreign keys can not be dropped which can break the rollback or dropAll functionality.
Sybase_Anywhere asany Since 1.9
DB2 db2 No Issues. Will auto-call REORG when necessary.
Apache Derby derby No Issues
HSQL hsqldb No Issues
H2 h2 No Issues
Informix informix No Issues
Firebird firebird No Issues
SQLite sqlite No Issues
Vertica vertica Needs to be used with our extension (https://github.com/liquibase/liquibase-vertica/releases). The extension supports deploying formatted sql changesets.
SAP MaxDB maxdb Needs to be used with our extension (https://github.com/liquibase/liquibase-maxdb/releases). The extension supports deploying formatted sql changesets.
Snowflake snowflake Needs to be used with our extension (https://github.com/liquibase/liquibase-snowflake/releases). The extension supports deploying formatted sql changesets.
CockroachDB postgresql 8.2+ is required to use the “drop all database objects” functionality.
Amazon RDS mariadb, mysql, mssql, oracle, postgresql Amazon Relational Database Service instances should be indistinguishable from other database instances of the same type.
Amazon Aurora mysql, postgresql Amazon Aurora operates in PostgreSQL and MySQL compatibility modes. The type name should match the compatibility mode when working with Amazon Aurora.

As of Liquibase v3.1, support for some less common databases has been moved out of Liquibase core and into extensions.

To re-enable support for these databases, install the corresponding extension:

Using other databases

Since Liquibase is built on top of standard JDBC, the only ties it has to the underlying database is through the SQL that can vary from DBMS to DBMS. If you attempt to use Liquibase with an unsupported database, it will try to run and will most likely succeed. The only problem you are likely to run into is the current date/time function name. If Liquibase is unable to determine the correct date/time function, you can pass it in via the “command line” and documentation/Ant).

You may also run into a problem with the SQL generated by the change/refactoring tags on unsupported databases. The best way to deal with this problem is to first try the standard change/refactoring tags. If it generates an error, you can fall back to the sql change to code whatever change you need to make in a way that your database understands.

If for some reason the DatabaseChangeLog table cannot be created on your database, the base creation SQL that you can modify to suit your needs is:

CREATE TABLE DATABASECHANGELOG (id varchar(150) not null, 
author varchar(150) not null,
filename varchar(255) not null,
dateExecuted datetime not null, 
md5sum varchar(32),
description varchar(255),
comments varchar(255),
tag varchar(255), 
liquibase varchar(10), 
primary key(id, author, filename))

Reasons for creating the DatabaseChangeLog table yourself include a database that requires null fields to be specified as such and index limitations that don’t allow primary keys on fields as long. You can change the data types and or data type lengths all you want.