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:
|
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:
<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:
|
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:
|
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
- To install and start using Liquibase, see Installing Liquibase.
- For more information about Liquibase extensions, see Liquibase extensions.
- For information about database versions and database-specific interactions within Liquibase, see A Harness of Integration Tests.
- For information about using supported databases with Liquibase, see Liquibase Database Tutorials.