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.
Not on Mac? Download TablePlus for Windows.
Need a quick edit on the go? Download for iOS
