JDBC Connections and URLs
Below is every driver name and URL format for most popular databases.
We use this information to provide our free SQL GUI qStudio to dynamically load JDBC drivers.
| Database | JDBC Driver Name | URL format | Default Port | Maven |
|---|---|---|---|---|
| Postgres | org.postgresql.Driver | jdbc:postgresql://{host}:{port}/{database}? | 5432 | |
| Clickhouse | ru.yandex.clickhouse.ClickHouseDriver | jdbc:clickhouse://{host}:{port}/{database} | 8123 | |
| Microsoft SQL Server | com.microsoft.sqlserver.jdbc.SQLServerDriver | jdbc:sqlserver://{host}[:{port}][;databaseName={database}];trustServerCertificate=true | 1433 | |
| Oracle | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@{host}:{port}/[{database}] | 1521 | maven |
| H2 | org.h2.Driver | jdbc:h2:tcp://{server}[:{port}] | 8082 | |
| MySQL | com.mysql.jdbc.Driver | jdbc:mysql://{host}:{port}/{database}?allowMultiQueries=true | 3306 | |
| Redis | jdbc.RedisDriver | jdbc:redis://{host}:{port}[/{database}] | 6379 | |
| DuckDB | org.duckdb.DuckDBDriver | jdbc:duckdb:{file} | ||
| Db2 for IBM i | com.ibm.as400.access.AS400JDBCDriver | jdbc:as400://{host};[libraries={database};] | 446 | maven |
| Informix | com.informix.jdbc.IfxDriver | jdbc:informix-sqli://{host}:{port}/{database}:INFORMIXSERVER={server} | 1533 | maven |
| Derby Embedded | org.apache.derby.jdbc.EmbeddedDriver | jdbc:derby:{folder} | maven | |
| Derby Server | org.apache.derby.client.ClientDriver | jdbc:derby://{host}:{port}/{database};create=false | 1527 | maven |
| HSQL Server | org.hsqldb.jdbcDriver | jdbc:hsqldb:hsql://{host}[:{port}]/[{database}] | 9001 | maven |
| HSQL Embedded | org.hsqldb.jdbc.JDBCDriver | jdbc:hsqldb:file:{folder} | maven | |
| SQLite | org.sqlite.JDBC | jdbc:sqlite:{file} | maven | |
| Teradata | com.teradata.jdbc.TeraDriver | jdbc:teradata://{host}/DATABASE={database},DBS_PORT={port} | 1025 | maven |
| CSV | org.relique.jdbc.csv.CsvDriver | jdbc:relique:csv:{folder} | maven | |
| MS Access (UCanAccess) | net.ucanaccess.jdbc.UcanaccessDriver | jdbc:ucanaccess://{file} | maven | |
| NuoDB | com.nuodb.jdbc.Driver | jdbc:com.nuodb://{host}[:{port}]/[{database}] | 2000 | maven |
| HANA (Old) | com.sap.db.jdbc.Driver | jdbc:sap://{host}[:{port}] | 30015 | maven |
| Gemfire XD | com.pivotal.gemfirexd.jdbc.ClientDriver | jdbc:gemfirexd://{host}[:{port}]/ | 1527 | maven |
| SnappyData | io.snappydata.jdbc.ClientDriver | jdbc:snappydata://{host}[:{port}]/ | 1528 | maven |
| Apache Spark | org.apache.hive.jdbc.HiveDriver | jdbc:hive2://{host}[:{port}][/{database}] | 10000 | maven |
| Apache Kyuubi | org.apache.kyuubi.jdbc.KyuubiHiveDriver | jdbc:hive2://{host}[:{port}][/{database}] | 10009 | maven |
| ClickHouse (Yandex) | ru.yandex.clickhouse.ClickHouseDriver | jdbc:clickhouse://{host}:{port}[/{database}] | 8123 | maven |
| Neo4j | org.neo4j.jdbc.Driver | jdbc:neo4j:bolt://{host}[:{port}]/ | 7687 | maven |
| PrestoSQL | io.prestosql.jdbc.PrestoDriver | jdbc:presto://{host}:{port}[/{database}] | 8080 | maven |
| Trino | io.trino.jdbc.TrinoDriver | jdbc:trino://{host}:{port}[/{database}] | 8080 | maven |
| Solr | org.apache.solr.client.solrj.io.sql.DriverImpl | jdbc:solr://{host}:{port}/[?collection={database}] | 9983 | maven |
| Apache Ignite | org.apache.ignite.IgniteJdbcThinDriver | jdbc:ignite:thin://{host}[:{port}][;schema={database}] | 1000 | maven |
| OmniSci (formerly MapD) | com.omnisci.jdbc.OmniSciDriver | jdbc:omnisci:{host}:{port}:{database} | 6274 | maven |
| CrateDB (Legacy) | io.crate.client.jdbc.CrateDriver | crate://{host}[:{port}]/ | 5432 | maven |
| SQream DB | com.sqream.jdbc.SQDriver | jdbc:Sqream://{host}:{port}/{database};cluster=true | 3108 | maven |
| Apache Calcite Avatica | org.apache.calcite.avatica.remote.Driver | jdbc:avatica:remote:url=http://{host}:{port}/druid/v2/sql/avatica/ | 8082 | maven |
| Apache Kylin | org.apache.kylin.jdbc.Driver | jdbc:kylin://{host}:{port}/{database} | 443 | maven |
| Snowflake | net.snowflake.client.jdbc.SnowflakeDriver | jdbc:snowflake://{host}[:port]/?[db={database}] | 443 | maven |
| ClickHouse.com | com.clickhouse.jdbc.ClickHouseDriver | jdbc:ch:{host}:{port}[/{database}] | 8123 | maven |
| Elasticsearch | org.elasticsearch.xpack.sql.jdbc.EsDriver | jdbc:es://{host}:{port}/ | 9200 | maven |
| DolphinDB | com.dolphindb.jdbc.Driver | jdbc:dolphindb://{host}:{port} | 9200 | maven |
| MongoDB | com.mongodb.jdbc.MongoDriver | jdbc:mongodb://{host}[:{port}][/{database}] | 27017 | maven |
| InfluxDB | com.mongodb.jdbc.MongoDriver | jdbc:arrow-flight-sql://{host}:{port}?disableCertificateVerification=true[&database={database}] | 27017 | maven |
| TDengine | com.taosdata.jdbc.rs.RestfulDriver | jdbc:TAOS-RS://{host}:{port}/[{database}] | 6041 | maven |
| Kdb | kx.jdbc | jdbc:q:{host}:{port} | 5000 | |
| Custom JDBC Driver | DriverNotSpecified | DriverUrlPrefixNotSpecified | 5000 |