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.

Note: Many databases are based on similar underlying architectures and use similar JDBC connection information. The "Database" column refers to your front-end database implementation. The "DBMS/shortname" field refers to the back-end system that Liquibase recognizes in JDBC URLs and in the dbms changeset attribute.

Database Verified versions Verification level Shortname / Driver / Notes
Amazon DocumentDB
  • 4.0
Foundational DBMS/shortname: mongodb

File: mongo-java-driver-<version>.jar
Class: NA
JDBC URL: jdbc:mongodb://localhost:27069/lbcat?tls=false&retryWrites=false
Download: Maven: org/mongodb/mongo-java-driver
Extension: GitHub: liquibase/liquibase-mongodb

Notes: Amazon DocumentDB emulates MongoDB. Connect via the MongoDB Pro extension. Also, JDBC URL with TLS enabled is different. See MongoDB Pro and Amazon DocumentDB TLS/SSL Configuration.
Amazon Redshift
  • Cloud
Foundational DBMS/shortname: 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 DBMS/shortname: mysql

File: mysql-connector-java-<version>.jar
Class: NA
JDBC URL: jdbc:mysql://<endpoint>:<port>/<dbname>
Download: Amazon Aurora
AWS Aurora for PostgreSQL
  • 15
  • 14
  • 13
  • 12
  • 11
Advanced DBMS/shortname: 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 DBMS/shortname: 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 DBMS/shortname: mssql

File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<endpoint>:<port>/<dbname>;
Download: Amazon RDS for SQL Server

Notes: Requires semicolon at end.
AWS RDS – MySQL
  • 8.0
  • 5.7
Advanced DBMS/shortname: 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
  • 21c
  • 19c
Advanced DBMS/shortname: 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
Advanced DBMS/shortname: 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 DBMS/shortname: 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 DBMS/shortname: 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 DBMS/shortname: 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
Advanced DBMS/shortname: 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 DBMS/shortname: mssql

File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<host>:<port>/<dbname>;
Download: SQL Server on Google Cloud

Notes: Requires semicolon at end.
Google Cloud SQL – MySQL
  • 8.0
Advanced DBMS/shortname: 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 DBMS/shortname: 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 DBMS/shortname: 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 DBMS/shortname: 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

Notes: Select the Java 8 connector/j.
MariaDB SkySQL
  • 10.6
  • 10.5
  • 10.4
  • 10.3
  • 10.2
Contributed DBMS/shortname: 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

Notes: Select the Java 8 connector/j.
Microsoft Azure SQL Database
  • Cloud
Advanced DBMS/shortname: mssql

File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<endpoint>:<port>/<dbname>;
Download: Azure SQL Database

Note: Requires semicolon at end.
Microsoft Azure SQL Managed Instance
  • Cloud
Advanced DBMS/shortname: mssql

File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<endpoint>:<port>/<dbname>;
Download: Azure SQL Database

Note: Requires semicolon at end.
Microsoft SQL Server
  • 2022
  • 2019
  • 2017
  • 2016
  • 2014
Advanced DBMS/shortname: mssql

File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<host>:<port>/<dbname>;
Download: Microsoft: Download Microsoft JDBC Driver for SQL Server

Note: Requires semicolon at end.
MongoDB Pro Extension Community and Enterprise Server
  • 6
  • 5
Foundational DBMS/shortname: 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

Notes: Requires Liquibase Pro 4.20+
MongoDB Atlas Pro Extension
  • 6
  • 5
Foundational DBMS/shortname: 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

Notes: Requires Liquibase Pro 4.20+
MySQL Server
  • 8.0
  • 5.7
Advanced DBMS/shortname: 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
  • 23c
  • 21c
  • 19c
  • 12.2
Advanced DBMS/shortname: 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

Notes: 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 DBMS/shortname: 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

Notes: Requires a configured wallet. To view an example, see Using Liquibase with Oracle Autonomous Database with ATP & ADW.
PostgreSQL
  • 15
  • 14
  • 13
  • 12
Advanced DBMS/shortname: postgresql

File: postgresql-<version>.jar
Class: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<host>:<port>/<dbname>
Download: PostgreSQL: Download
Snowflake
  • Cloud
Advanced DBMS/shortname: 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

Notes: 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