Liquibase Database Tutorials

Learn more about using Liquibase with your favorite databases with our in-depth tutorials.

Verification levels

A database's verification level indicates how well it works with different features in Liquibase and across different products, such as Liquibase Communityand Liquibase Pro. From highest to lowest levels of support:

  • Guaranteed: Community and Commercial functionality has been certified by Liquibase via automated and real-world testing.
  • Foundational: Community functionality has been certified by Liquibase via automated and real-world testing.
  • Compatible: Reported to work by the community. May have partially passed Foundational-level testing.
  • Unverified: Liquibase does not have enough information to know how well this extension or integration works.

Supported databases

Database Verification Level Driver Extension Notes
Amazon Redshift (AWS Redshift) Compatible File: redshift-jdbc<version>.jar
Class: com.amazon.redshift.jdbc42.Driver
JDBC URL: jdbc:redshift://endpoint:port/database
Download: AWS: Download the Amazon Redshift JDBC driver, version 2.1		 NA NA
Apache Derby Foundational File: derbytools.jar
Class: org.apache.derby
JDBC URL: jdbc:derby://localhost:1527/MYDATABASE;create=true
Download: Apache Derby: Downloads		 NA NA
BigQuery (Google BigQuery) Compatible File: GoogleBigQueryJDBC<version>.jar
Class: com.google.cloud
JDBC URL: jdbc:bigquery://https://googleapis.com/bigquery/v2:443/<dbname>;ProjectId=<STR>;OAuthType=<INT>;
Download: Google: BigQuery		 GitHub: liquibase/liquibase-bigquery  
Cassandra (Apache Cassandra) Compatible File: CassandraJDBC<version>.jar
Class: com.simba.cassandra.jdbc42.Driver
JDBC URL: jdbc:cassandra://localhost:9042/myKeyspace;DefaultKeyspace=myKeyspace
Download: Datastax: ODBC/JDBC Drivers		 NA NA
Cassandra on Datastax Astra Compatible File: CassandraJDBC<version>.jar
Class: com.simba.cassandra.jdbc42.Driver
JDBC URL: jdbc:cassandra://host:port;DefaultKeyspace=keyspace;AuthMech=2;UID=username;PWD=password;SecureConnectionBundlePath=path/to/secure-connect-database_name.zip;TunableConsistency=6
Download: Datastax: ODBC/JDBC Drivers		 NA NA
Cloud Spanner (Google Spanner) Compatible JDBC URL: jdbc:cloudspanner:/projects/<project>/instances/<instance>/databases/<database>
Download: GitHub: Liquibase Spanner Extension		 liquibase-spanner-version-all.jar Includes extension and driver.
COCKROACHDB on prem Foundational File:postgresql-<version>.jar
Class:org.postgresql.Driver
JDBC URL:jdbc:postgresql://localhost:26257/database?ssl=true&sslmode=require&sslrootcert=/full-path/certs/ca.crt&sslkey=/full-ath/certs/client.user.key.pk8&sslcert=/full-path/certs/client.user.crt
Download: PostgreSQL: Download		 NA TLS certificate workflow is preferred. The following option is insecure:
jdbc:postgresql://localhost:26257/dev
COCKROACHDB Cloud Foundational File:postgresql-<version>.jar
Class:org.postgresql.Driver
JDBC URL:jdbc:postgresql://liquibase-3r8.aws-us-east-2.cockroachlabs.cloud:26257/defaultdb?sslmode=verify-full&sslrootcert=liquibase-ca.crt
Download: PostgreSQL: Download		 NA Requires TLS certificate workflow.
Cosmos DB (Azure Cosmos DB) Compatible File: azure-cosmos-<version>.jar
Class: com.azure.cosmos.Driver
JDBC URL: jdbc:cosmosdb://AccountEndpoint=https://<cosmosdb-account-name>.documents.azure.com:443;AccountKey=<accountKey>;
Download: CData: JDBC Driver Download		 GitHub: liquibase/liquibase-cosmosdb

For Azure Cosmos DB Emulator, use this JDBC URL:

jdbc:cosmosdb://localhost:C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==@localhost:8080/testdb1
EnterpriseDB Guaranteed File: edb-jdbc-<version>.jar
Class: com.edb.Driver
JDBC URL: jdbc:edb://<hostname>:5444/<dbname>
Download: EnterpriseDB: Downloads: EDB Connectors		 NA NA
Firebird Foundational File: jaybird-full-<version>.jar
Class: org.firebirdsql.jdbc.FBDriver
JDBC URL: jdbc:firebirdsql://<IP/host>:<port>//<server/path/to/database>
Download: GitHub: jaybird: releases		 NA NA
Greenplum Compatible      
H2 Foundational File: h2-<version>.jar
Class: NA
JDBC URL:
  • Memory: jdbc:h2:tcp://localhost:9090/mem:dev
  • File: jdbc:h2:file:C:/tools/LB_DBs/H2Example/h2tutorial
Download: Included with Liquibase in <install-directory/internal/lib>		 NA Included with Liquibase.
Hibernate Unverified File: h2-<version>.jar
Class: liquibase.ext.hibernate.database.connection.HibernateDriver
JDBC URL: hibernate:ejb3:com.liquibase.hibernate.tutorial.jpa
Download: Included with Liquibase in <install-directory/internal/lib>		 GitHub: liquibase/liquibase-hibernate NA
HSQLDB (HyperSQL Database) Foundational File: hsqldb.jar
Class: org.hsqldb.jdbcDriver
JDBC URL: jdbc:hsqldb:hsql://192.168.1.15:9001/<db-name>
Download: Included with HSQL download from SourceForge		 NA NA
IBM DB2 LUW Guaranteed File: db2jcc<version>.jar
Class: com.ibm.db2.jcc.DB2Driver
JDBC URL: jdbc:db2://<server-name>:<port>/<db-name>
Download: IBM: DB2 JDBC Driver Versions and Downloads		 NA NA
IBM DB2 on Z Unverified File: db2jcc<version>.jar
Class: com.ibm.db2.jcc.DB2Driver
JDBC URL: jdbc:db2://<host-IP-address>:<port>/<db-name>:retrieveMessagesFromServerOnGetMessage=true;emulateParameterMetaDataForZCalls=1;
Download: IBM: DB2 JDBC Driver Versions and Downloads		 NA Requires IBM license file db2jcc_license_cisuz.jar.
Informix Unverified File: jdbc-<version>.jar
Class: com.informix.jdbc.IfxDriver
JDBC URL: jdbc:informix-sqli://localhost:9088/dbname:INFORMIXSERVER=dbserver
Download: Maven: IBM Informix JDBC Driver		 NA Requires Informix database in ANSI mode to enable implicit transactions with statements like the following JDBC URL:
CREATE DATABASE [ansiDatabase] WITH LOG MODE ANSI;
MariaDB, skySQL, or MariaDB AWS RDS

Guaranteed (MariaDB)

Unverified (MariaDB AWS RDS)

 File: mariadb-java-client-<version>.jar
Class: org.mariadb.jdbc.Driver
JDBC URL: jdbc:mariadb://<host>:<port>/<dbname>
Download: MariaDB: About MariaDB Connector/J		 NA Select the Java 8 connector/j.
MaxDB (SAP MaxDB) Unverified File: sapdbc.jar
Class: com.sap.dbtech.jdbc.DriverSapDB
JDBC URL: jdbc:sapdb://localhost:7200/MaxDB1
Download: SAP: SAP MaxDB Product Availability		 GitHub: liquibase/liquibase-maxdb To view installed database software packages, including JDBC drivers, run the following command:
sdbregview -l
MongoDB Compatible File: mongo-java-driver-<version>.jar
Class: NA
JDBC URL: mongodb://hostname:27017/<db-name>
Reference: MongoDB: Connection String URI Format
Download: Maven: org/mongodb/mongo-java-driver		 GitHub: liquibase/liquibase-mongodb NA
MSSQL (Microsoft SQL Server) Guaranteed File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<host>:<port>/<db-name>;
Note: Requires semicolon at end.
Download: Microsoft: Download Microsoft JDBC Driver for SQL Server		 NA NA
MySQL Guaranteed File: mysql-connector-java-<version>.jar
Class: NA
JDBC URL: jdbc:mysql://<servername>:<port>/<dbname>
Download: MySQL: MySQL Community Downloads: Connector/J		 NA NA
Neo4j Compatible      
Oracle Guaranteed 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		 NA For information about Kerberos and TNS connections, see Connecting to an Oracle Database with Liquibase via Kerberos and Active Directory.
Oracle ATP & ADW Compatible File: ojdbc<version>.jar
Class: oracle.jdbc.OracleDriver
JDBC URL: jdbc:oracle:thin:@<database_name>_high?TNS_ADMIN=/path/to/Wallet_<database_name>
Download: Oracle: Oracle Database JDBC driver and Companion Jars Downloads		 NA Requires a configured wallet. To view an example, see Using Liquibase with Oracle ATP & ADW.
Percona XtraDB Cluster Foundational File:mysql-connector-java-<version>.jar
Class: NA
JDBC URL:jdbc:mysql://<servername>:<port>/<dbname>
Download: MySQL: MySQL Community Downloads: Connector/J		    
PostgreSQL Guaranteed File: postgresql-<version>.jar
Class: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<host>:<port>/<dbname>
Download: PostgreSQL: Download		 NA NA
SAP Adaptive Server Enterprise/SAP ASE (Sybase ASE) Unverified File: jconn4.jar
Class: com.sybase.jdbc4.jdbc.SybDriver
JDBC URL: jdbc:sybase:Tds:127.0.0.1:5000/dbname
Download: Included in database client		    
SAP HANA Unverified File: ngdbc-<version>.jar
Class: com.sap.db.jdbc.Driver
JDBC URL: jdbc:sap://localhost:30013/?databaseName=mydatabase&encrypt=true
Download: Maven: SAP HANA JDBC Driver		 GitHub: liquibase/liquibase-hanadb NA
SAP SQL Anywhere (Sybase Anywhere) Compatible File: sajdbc4.jar
Class: sybase.jdbc.sqlanywhere.IDriver
JDBC URL: jdbc:sqlanywhere:UserID=DBA;Password=passwd;
Download: Included in database client		 NA NA
Snowflake Guaranteed 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		 NA Requires additional files if using > 128 bit keys. For more information, see Using Liquibase with Snowflake.
SQLite Foundational File: sqlite-jdbc-<version>.jar
Class: org.sqlite.JDBC
JDBC URL: jdbc:sqlite:example.db
Download: GitHub: xerial/sqlite-jdbc		 NA NA
Teradata Compatible File: terajdbc<version>.jar
Class: com.teradata.jdbc.TeraDriver
JDBC URL: jdbc:teradata://hostname/DATABASE=<db-name>
Download: Teradata: Teradata JDBC Driver		 GitHub: liquibase/liquibase-teradata NA
Vertica Unverified File: vertica-jdbc-<version>.jar
Class: com.vertica.jdbc.Driver
JDBC URL: jdbc:vertica://localhost:5433/docker
Download: Vertica: Vertica Downloads: Client Drivers		 GitHub: liquibase/liquibase-vertica NA
YugabyteDB Compatible File: postgresql-<version>.jar
Class: org.postgresql.Driver
JDBC URL: jdbc:postgresql://<host>:<port>/<db-name>
Download: PostgreSQL: Download		 NA NA

Related links