Liquibase Database Tutorials

Learn more about using Liquibase with your favorite databases with our in-depth tutorials. These tutorials explain how to install and configure your database with Liquibase Open Source and Liquibase Pro.

Prerequisites

Before you start setting up your database, make sure you're familiar with how Liquibase works using these pages:

  1. Introduction to Liquibase – Dive into Liquibase concepts.
  2. Install Liquibase – Download Liquibase on your machine.
  3. Get Started with Liquibase – Learn how to use Liquibase with an example database.
  4. Design Your Liquibase Project – Create a new Liquibase project folder and organize your changelogs
  5. How to Apply Your Liquibase Pro License Key – If you use Liquibase Pro, activate your license.

Verification levels

Liquibase works with 50+ databases including relational, NoSQL, and graph databases. A database's verification level refers to the levels of automated and real-world professional testing and certification it has passed. The levels are Advanced (highest verification), Foundational, Contributed, and Research (lowest verification).

  • Advanced: Database has been tested and validated to deliver a minimum set of advanced capabilities around database inspection, support for long-running operations, as well as the Foundational level's basic functionality of change management and change tracking aligned with the database. The advanced database inspection capabilities include the ability to generate changelogs in at least one format and the support of at least two additional state-based commands (snapshots, diffs, etc). The Liquibase customer support team provides how-to/usage support around verified capabilities for commercial customers.
  • Foundational: Database has been tested and validated to deliver the basic functionality of change management and change tracking aligned with the database. Some additional advanced capabilities may be implemented. The Liquibase customer support team provides how-to/usage support around verified capabilities for commercial customers.
  • Contributed: Database has not yet met one or several of the requirements around maintainer contact with Liquibase, documentation, or verified functionality to achieve the Foundational designation. Not supported by the Liquibase support team. Best-effort support is provided through our community forums.
  • Research: Database is being developed by Liquibase and exist in an experimental phase. The Liquibase customer support team provides how-to/usage support around documented capabilities for commercial customers.

For more information, see Database Verification Levels.

Liquibase-maintained databases

Liquibase tests with English language databases only. Other languages with special characters may cause issues.

The following table shows databases whose compatibility with Liquibase is maintained by Liquibase. For databases maintained by the community, see the "Community-maintained databases" section.

Database Verified versions Verification level Shortname Driver Notes
Amazon Redshift
  • Cloud
Foundational redshift File: redshift-jdbc<version>.jar
Class: com.amazon.redshift.jdbc42.Driver
JDBC URL: jdbc:redshift://endpoint:port/dbname
Download: AWS: Download the Amazon Redshift JDBC driver, version 2.1
 
AWS Aurora – MySQL
  • 8.0
  • 5.7
Advanced mysql File: mysql-connector-java-<version>.jar
Class: NA
JDBC URL: jdbc:mysql://<endpoint>:<port>/<dbname>
Download: Amazon Aurora
 
AWS Aurora for PostgreSQL
  • 14
  • 13
  • 12
  • 11
Advanced postgresql File: postgresql-<version>.jar
Class: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<instance_host>:<instance_port>/<dbname>
Download: Amazon Aurora
 
AWS RDS – MariaDB
  • 10.6
  • 10.5
  • 10.4
  • 10.3
  • 10.2
Advanced mariadb File: mariadb-java-client-<version>.jar
Class: org.mariadb.jdbc.Driver
JDBC URL: jdbc:mariadb://<endpoint>:<port>/<dbname>
Download: Amazon RDS for MariaDB
 
AWS RDS – Microsoft SQL Server
  • 2019
  • 2017
  • 2016
  • 2014
Advanced mssql File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<endpoint>:<port>/<dbname>;
Note: Requires semicolon at end.
Download: Amazon RDS for SQL Server
 
AWS RDS – MySQL
  • 8.0
  • 5.7
Advanced mysql File: mysql-connector-java-<version>.jar
Class: NA
JDBC URL: jdbc:mysql://<endpoint>:<port>/<dbname>
Download: Amazon RDS for MySQL
 
AWS RDS – Oracle Database
  • 19c
  • 21c
Advanced oracle File: ojdbc<version>.jar
Class: oracle.jdbc.OracleDriver
JDBC URL: jdbc:oracle:thin:@<endpoint>:<port>:<sid>
Download: Amazon RDS for Oracle
 
AWS RDS – PostgreSQL
  • 15
  • 14
  • 13
  • 12
  • 11
Advanced postgresql File: postgresql-<version>.jar
Class: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<instance_host>:<instance_port>/<dbname>
Download: Amazon RDS for PostgreSQL
 
Azure Database for MySQL
  • 8.0
  • 5.7
Advanced mysql File: mysql-connector-java-<version>.jar
Class: NA
JDBC URL: jdbc:mysql://<endpoint>:<port>/<dbname>
Download: Azure Database for MySQL
 
Azure Database – Postresql – Flexible Server
  • 13
Advanced postgresql File: postgresql-<version>.jar
Class: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<endpoint>:<port>/<dbname>
Download: Azure Database for PostgreSQL – Flexible Server
 
Azure Database – Postresql – Single Server
  • 11
Advanced postgresql File: postgresql-<version>.jar
Class: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<endpoint>:<port>/<dbname>
Download: Azure Database for PostgreSQL – Single Server
 
EnterpriseDB
  • 14
  • 13
  • 12
  • 11
Advanced edb File: edb-jdbc-<version>.jar
Class: com.edb.Driver
JDBC URL: jdbc:edb://<hostname>:5444/<dbname>
Download: EnterpriseDB: Downloads: EDB Connectors
 
Google Cloud SQL – MSSQL
  • 2019
Advanced mssql File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<host>:<port>/<dbname>;
Note: Requires semicolon at end.
Download: SQL Server on Google Cloud
 
Google Cloud SQL – MySQL
  • 8.0
Advanced mysql File: mysql-connector-java-<version>.jar
Class: NA
JDBC URL: jdbc:mysql://<endpoint>:<port>/<dbname>
Download: Google Cloud SQL for MySQL
 
Google Cloud SQL – PostgreSQL
  • 14
  • 13
  • 12
  • 11
Advanced postgresql File: postgresql-<version>.jar
Class: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<instance_host>:<instance_port>/<dbname>
Download: Google Cloud SQL for PostgreSQL
 
IBM DB2 LUW
  • 11.5.7+
Advanced db2 File: db2jcc<version>.jar
Class: com.ibm.db2.jcc.DB2Driver
JDBC URL: jdbc:db2://<server-name>:<port>/<dbname>
Download: IBM: DB2 JDBC Driver Versions and Downloads
 
MariaDB Server
  • 10.6
  • 10.5
  • 10.4
  • 10.3
  • 10.2
Advanced mariadb File: mariadb-java-client-<version>.jar
Class: org.mariadb.jdbc.Driver
JDBC URL: jdbc:mariadb://<host>:<port>/<dbname>
Download: MariaDB: About MariaDB Connector/J
Select the Java 8 connector/j.
MariaDB SkySQL
  • 10.6
  • 10.5
  • 10.4
  • 10.3
  • 10.2
Contributed mariadb File: mariadb-java-client-<version>.jar
Class: org.mariadb.jdbc.Driver
JDBC URL: jdbc:mariadb://<host>:<port>/<dbname>?useSSL=true&serverSslCert=skysql_chain.pem
Download: MariaDB: About MariaDB Connector/J
Select the Java 8 connector/j.
Microsoft Azure SQL Database
  • Cloud
Advanced mssql File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<endpoint>:<port>/<dbname>;
Note: Requires semicolon at end.
Download: Azure SQL Database
 
Microsoft Azure SQL Managed Instance
  • Cloud
Advanced mssql File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<endpoint>:<port>/<dbname>;
Note: Requires semicolon at end.
Download: Azure SQL Database
 
Microsoft SQL Server
  • 2022
  • 2019
  • 2017
  • 2016
  • 2014
Advanced mssql File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<host>:<port>/<dbname>;
Note: Requires semicolon at end.
Download: Microsoft: Download Microsoft JDBC Driver for SQL Server
 
MongoDB Pro Extension
  • 6
  • 5
Foundational mongodb File: mongo-java-driver-<version>.jar
Class: NA
JDBC URL: jdbc:mongodb://hostname:27017/<dbname>
Reference: MongoDB: Connection String URI Format
Download: Maven: org/mongodb/mongo-java-driver
Extension: GitHub: liquibase/liquibase-mongodb
Requires Liquibase Pro 4.20+
MongoDB Atlas Pro Extension
  • 6
  • 5
Foundational mongodb File: mongo-java-driver-<version>.jar
Class: NA
JDBC URL: jdbc:mongodb://hostname:27017/<dbname>
Reference: MongoDB: Connection String URI Format
Download: Maven: org/mongodb/mongo-java-driver
Extension: GitHub: liquibase/liquibase-mongodb
Requires Liquibase Pro 4.20+
MySQL Server
  • 8.0
  • 5.7
Advanced mysql File: mysql-connector-java-<version>.jar
Class: NA
JDBC URL: jdbc:mysql://<servername>:<port>/<dbname>
Download: MySQL: MySQL Community Downloads: Connector/J
 
Oracle Database
  • 21c
  • 19c
  • 12.2
Advanced oracle File: ojdbc<version>.jar
Class: oracle.jdbc.OracleDriver
JDBC URL: jdbc:oracle:thin:@<host>:<port>:<dbname>
Download: Oracle: Oracle Database JDBC driver and Companion Jars Downloads
For information about Kerberos and TNS connections, see Connecting to an Oracle Database with Liquibase via Kerberos and Active Directory.
Oracle Autonomous Database
  • 19c
Foundational oracle File: ojdbc<version>.jar
Class: oracle.jdbc.OracleDriver
JDBC URL: jdbc:oracle:thin:@<database_name>_high?TNS_ADMIN=/path/to/Wallet_<dbname>
Download: Oracle: Oracle Database JDBC driver and Companion Jars Downloads
Requires a configured wallet. To view an example, see Using Liquibase with Oracle Autonomous Database with ATP & ADW.
PostgreSQL
  • 15
  • 14
  • 13
  • 12
  • 11
Advanced postgresql File: postgresql-<version>.jar
Class: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<host>:<port>/<dbname>
Download: PostgreSQL: Download
 
Snowflake
  • Cloud
Advanced snowflake File: snowflake-jdbc-<version>.jar
Class: net.snowflake.client.jdbc.SnowflakeDriver
JDBC URL: jdbc:snowflake://<account_ID>.snowflakecomputing.com/?<connection_params>
Download: Maven: net/snowflake/snowflake-jdbc
Requires additional files if using > 128 bit keys. For more information, see Using Liquibase with Snowflake.

Community-maintained databases

Many Liquibase features are also compatible with databases not officially maintained by Liquibase. Depending on the database, this functionality is built into Liquibase or contained in extensions separate from Liquibase Core.

For documentation on community-maintained databases, see the Liquibase Contribute Documentation site. For a full list of supported databases, see Supported Databases.

Related links