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:
- Introduction to Liquibase – Dive into Liquibase concepts.
- Install Liquibase – Download Liquibase on your machine.
- Get Started with Liquibase – Learn how to use Liquibase with an example database.
- Design Your Liquibase Project – Create a new Liquibase project folder and organize your changelogs
- 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 |
|
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 |
|
Advanced | mysql
|
File: mysql-connector-java-<version>.jar Class: NA JDBC URL: jdbc:mysql://<endpoint>:<port>/<dbname> Download: Amazon Aurora |
|
AWS Aurora for PostgreSQL |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
Advanced | postgresql
|
File: postgresql-<version>.jar Class: org.postgresql.Driver JDBC URL: jdbc:postgresql://<host>:<port>/<dbname> Download: PostgreSQL: Download |
|
Snowflake |
|
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.