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