JDBC URL Formats List

This here is a list of JDBC driver class names and URL formats for some popular databases.

Database JDBC URL Format Driver Name
DB2 jdbc:db2://HOST:PORT/DATABASE com.ibm.db2.jcc.DB2Driver
IBM Informix® jdbc:informix-sqli://HOST:PORT/DATABASE: informixserver=IBM Informix instance name;user=user_name; password=password com.informix.jdbc.IfxDriver
Microsoft SQL Server jdbc:sqlserver://HOST:PORT;databaseName=DATABASE com.microsoft.sqlserver.jdbc.SQLServerDriver
MySQL jdbc:mysql://HOST:PORT/DATABASE com.mysql.cj.jdbc.Driver
MariaDB jdbc:mariadb://HOST:PORT/DATABASE org.mariadb.jdbc.Driver
Postgresql jdbc:postgresql://HOST:PORT/DATABASE org.postgresql.Driver
Netezza® jdbc:netezza://HOST:PORT/DATABASE org.netezza.Driver
Oracle Thin jdbc:oracle:thin:@HOST:PORT:DATABASE oracle.jdbc.driver.OracleDriver
Oracle OCI jdbc:oracle:oci:@DATABASE oracle.jdbc.OracleDriver
Sybase jdbc:sybase:Tds:HOST:PORT/DATABASE com.sybase.jdbc3.jdbc.SybDriver
Teradata jdbc:teradata://HOST/DBS_PORT=PORT/ DATABASE=DATABASE/CHARSET=UTF8,COMPAT_DBS=true com.ncr.teradata.TeraDriver

TablePlus is a native database client. You can work with Oracle, MySQL, SQL Server, PostgreSQL, and other databases side by side in the same app.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

Need a quick edit on the go? Download for iOS

TablePlus in Dark mode

← All posts