Supported Databases

Database Driver Extension Notes
Amazon Redshift File: redshift-jdbc<version>.jar
Class: com.amazon.redshift.jdbc42.Driver
Example: jdbc:redshift://endpoint:port/database
Download: https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-download-driver.html
NA NA
Apache Derby File: derbytools.jar
Class: org.apache.derby
Example: jdbc:derby://localhost:1527/MYDATABASE;create=true
Download: https://db.apache.org/derby/derby_downloads.html
NA NA
Cassandra File: CassandraJDBC<version>.jar
Class: com.simba.cassandra.jdbc42.Driver
Example: jdbc:cassandra://localhost:9042/myKeyspace;DefaultKeyspace=myKeyspace
Download: https://downloads.datastax.com/#odbc-jdbc-drivers
NA NA
Cassandra on Datastax Astra File: CassandraJDBC<version>.jar
Class: com.simba.cassandra.jdbc42.Driver
Example: jdbc:cassandra://host:port;DefaultKeyspace=keyspace;AuthMech=2;UID=username;PWD=password;SecureConnectionBundlePath=path/to/secure-connect-database_name.zip;TunableConsistency=6
Download: https://downloads.datastax.com/#odbc-jdbc-drivers
NA NA
Cloud Spanner Example: jdbc:cloudspanner:/projects/<project>/instances/<instance>/databases/<database>
Download: https://github.com/cloudspannerecosystem/liquibase-spanner
liquibase-spanner-version-all.jar Includes extension and driver.
COCKROACHDB on prem File: postgresql-<version>.jar
Class: org.postgresql.Driver
Example: 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: https://jdbc.postgresql.org/download.html
NA TLS certificate workflow is preferred. The following option is insecure:
jdbc:postgresql://localhost:26257/dev
COCKROACHDB Cloud File: postgresql-<version>.jar
Class: org.postgresql.Driver
Example: jdbc:postgresql://liquibase-3r8.aws-us-east-2.cockroachlabs.cloud:26257/defaultdb?sslmode=verify-full&sslrootcert=liquibase-ca.crt
Download: https://jdbc.postgresql.org/download.html
NA Requires TLS certificate workflow.
Firebird File: jaybird-full-<version>.jar
Class: org.firebirdsql.jdbc.FBDriver
Example: jdbc:firebirdsql://<IP/host>:<port>//<server/path/to/database>
Download: https://github.com/FirebirdSQL/jaybird/releases/download/v3.0.6/Jaybird-3.0.6-JDK_1.8.zip
NA NA
H2 File: h2-<version>.jar
Class: NA
Example:
  • 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/lib>
NA Included with Liquibase.
Hibernate File: h2-<version>.jar
Class: liquibase.ext.hibernate.database.connection.HibernateDriver
Example: hibernate:ejb3:com.liquibase.hibernate.tutorial.jpa
Download: Included with Liquibase in <install-directory/lib>
https://github.com/liquibase/liquibase-hibernate/releases NA
Hive File: HiveJDBC<version>.jar
Class: com.cloudera.hive.jdbc41.HS2Driver
Example: jdbc:hive2://localhost:10000/hive_test;UID=eselyavka;UseNativeQuery=1
Download: https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-2.html
https://github.com/eselyavka/liquibase-impala NA
HSQLDB File: hsqldb.jar
Class: org.hsqldb.jdbcDriver
Example: jdbc:hsqldb:hsql://192.168.1.15:9001/<db-name>
Download: Included with HSQL download fromhttps://sourceforge.net/projects/hsqldb/files/
NA NA
IBM DB2 LUW File: db2jcc<version>.jar
Class: com.ibm.db2.jcc.DB2Driver
Example: jdbc:db2://<server-name>:<port>/<db-name>
Download: https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads
NA NA
IBM DB2 on Z File: db2jcc<version>.jar
Class: com.ibm.db2.jcc.DB2Driver
Example: jdbc:db2://<host-IP-address>:<port>/<db-name>:retrieveMessagesFromServerOnGetMessage=true;emulateParameterMetaDataForZCalls=1;
Download: https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads
NA Requires IBM license file db2jcc_license_cisuz.jar.
Impala File: ImpalaJDBC<version>.jar
Class: com.cloudera.impala.jdbc41.Driver
Example: jdbc:impala://localhost:21050/impala_test
Download: https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-4.html
https://github.com/eselyavka/liquibase-impala NA
Informix File: jdbc-<version>.jar
Class: com.informix.jdbc.IfxDriver
Example: jdbc:informix-sqli://localhost:9088/dbname:INFORMIXSERVER=dbserver
Download: https://mvnrepository.com/artifact/com.ibm.informix/jdbc
NA Requires Informix database in ANSI mode to enable implicit transactions with statements like the following example:
CREATE DATABASE [ansiDatabase] WITH LOG MODE ANSI;
Interbase File: interclient.jar
Class: interbase.interclient.Driver
Example: jdbc:interbase://localhost:3050/interbase/testdb.ib
Download: Downloaded with Interbase from https://www.embarcadero.com/products/interbase/downloads
https://github.com/Gtunali/Liqubase-interbase/blob/master/jar/liquibase-interbase-1.2.0.jar NA
MariaDB, skySQL, or MariaDB AWS RDS File: mariadb-java-client-<version>.jar
Class: org.mariadb.jdbc.Driver
Example: jdbc:mariadb://<host>:<port>/<dbname>
Download: https://mariadb.com/kb/en/about-mariadb-connector-j/
NA Select the Java 8 connector/j.
MaxDB File: sapdbc.jar
Class: com.sap.dbtech.jdbc.DriverSapDB
Example: jdbc:sapdb://localhost:7200/MaxDB1
Download: https://maxdb.sap.com/
https://github.com/liquibase/liquibase-maxdb/releases To view installed database software packages, including JDBC drivers, run the following command:
sdbregview -l
MongoDB File: mongo-java-driver-<version>.jar
Class: NA
Example: mongodb://hostname:27017/<db-name>
Reference: https://docs.mongodb.com/manual/reference/connection-string/
Download: https://repo1.maven.org/maven2/org/mongodb/mongo-java-driver
https://github.com/liquibase/liquibase-mongodb/releases/ NA
MSSQL File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Example: jdbc:sqlserver://<host>:<port>/<db-name>;
Note: Requires semicolon at end.
Download: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server
NA NA
MySQL File: mysql-connector-java-<version>.jar
Class: NA
Example: jdbc:mysql://<servername>:<port>/<dbname>
Download: https://dev.mysql.com/downloads/connector/j/
NA NA
Oracle File: ojdbc<version>.jar
Class: oracle.jdbc.OracleDriver
Example: jdbc:oracle:thin:@<host>:<port>:<dbname>
Download: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
NA For information about Kerberos and TNS connections, see Connecting to an Oracle Database with Liquibase via Kerberos and Active Directory.
Oracle ATP & ADW File: ojdbc<version>.jar
Class: oracle.jdbc.OracleDriver
Example: jdbc:oracle:thin:@<database_name>_high?TNS_ADMIN=/path/to/Wallet_<database_name>
Download: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
NA Requires a configured wallet. To view an example, see Using Liquibase with Oracle ATP & ADW.
Postgres File: postgresql-<version>.jar
Class: org.postgresql.Driver
Example: jdbc:postgresql://<host>:<port>/<dbname>
Download: https://jdbc.postgresql.org/download.html
NA NA
SAP HANA File: ngdbc-<version>.jar
Class: com.sap.db.jdbc.Driver
Example: jdbc:sap://localhost:30013/?databaseName=mydatabase&encrypt=true
Download: https://mvnrepository.com/artifact/com.sap.cloud.db.jdbc/ngdbc
https://github.com/liquibase/liquibase-hanadb/releases NA
Snowflake File: snowflake-jdbc-<version>.jar
Class: net.snowflake.client.jdbc.SnowflakeDriver
Example: jdbc:snowflake://<account_ID>.snowflakecomputing.com/?<connection_params>
Download: https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc
https://github.com/liquibase/liquibase-snowflake/releases Requires additional files if using > 128 bit keys. For more information, see Using Liquibase with Snowflake.
SQLite File: sqlite-jdbc-<version>.jar
Class: org.sqlite.JDBC
Example: jdbc:sqlite:example.db
Download: https://github.com/xerial/sqlite-jdbc
NA NA
Sybase Anywhere File: jtds-<version>.jar
Class: net.sourceforge.jtds.jdbc.Driver
Example: jdbc:jtds:sybase://localhost:5002/<db-name>
Download: https://mvnrepository.com/artifact/net.sourceforge.jtds/jtds
NA NA
Teradata File: terajdbc<version>.jar
Class: com.teradata.jdbc.TeraDriver
Example: jdbc:teradata://hostname/DATABASE=<db-name>
Download: https://downloads.teradata.com/download/connectivity/jdbc-driver
https://github.com/liquibase/liquibase-teradata/releases NA
Vertica File: vertica-jdbc-<version>.jar
Class: com.vertica.jdbc.Driver
Example: jdbc:vertica://localhost:5433/docker
Download: https://www.vertica.com/download/vertica/client-drivers/
https://github.com/liquibase/liquibase-vertica/releases NA
VoltDB File: jdbcdriver.jar
Class: org.voltdb.jdbc.Driver
Example: jdbc:voltdb://<server>:<port>
Download: https://mvnrepository.com/artifact/org.voltdb/voltdbclient/9.2.2
https://github.com/arun0009/liquibase-voltdb/tree/master/target NA
YugabyteDB File: postgresql-<version>.jar
Class: org.postgresql.Driver
Example: jdbc:postgresql://<host>:<port>/<db-name>
Download: https://jdbc.postgresql.org/download.html
NA NA

Related links