Amazon Athena | jdbc:awsathena://AwsRegion=us-east-1;S3OutputLocation=s3://mybucket/queryoutput/; |
Amazon Redshift | jdbc:redshift://localhost:5439/mydb |
Apache Derby | jdbc:derby://localhost:1527/mydb;create=true |
Apache Druid | jdbc:avatica:remote:url=http://localhost:8082/druid/v2/sql/avatica/ |
Apache Hive | jdbc:hive2://localhost:10000/default |
Apache Ignite | jdbc:ignite:thin://localhost:10800 |
Apache Pinot | jdbc:pinot://<HOST>:8099/query?controller=http://<CONTROLLER>:9000 |
ClickHouse | jdbc:clickhouse://localhost:8123/mydb |
CockroachDB | jdbc:postgresql://localhost:26257/defaultdb?sslmode=require |
DuckDB | jdbc:duckdb:/path/to/mydb.duckdb |
Elasticsearch (SQL) | jdbc:es://localhost:9200 |
Exasol | jdbc:exa:localhost:8563;schema=MYDB |
Firebird (Jaybird) | jdbc:firebirdsql://localhost:3050/path/to/mydb.fdb |
Google BigQuery | jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=myproject;OAuthType=3; |
Google Cloud Spanner | jdbc:cloudspanner:/projects/<PROJECT_ID>/instances/<INSTANCE_ID>/databases/<DATABASE_ID> |
Greenplum | jdbc:greenplum://localhost:5432;DatabaseName=mydb |
H2 | jdbc:h2:~/mydb |
HSQLDB | jdbc:hsqldb:hsql://localhost/mydb |
IBM Db2 | jdbc:db2://localhost:50000/mydb |
Informix | jdbc:informix-sqli://localhost:1526/mydb:INFORMIXSERVER=server |
MariaDB | jdbc:mariadb://localhost:3306/mydb |
Microsoft SQL Server | jdbc:sqlserver://localhost:1433;databaseName=mydb |
MongoDB (Atlas SQL) | jdbc:mongodb://localhost:27017/mydb?ssl=false |
MySQL | jdbc:mysql://localhost:3306/mydb |
Neo4j | jdbc:neo4j:bolt://localhost:7687 |
Oracle Database | jdbc:oracle:thin:@//localhost:1521/orclpdb1 |
PostgreSQL | jdbc:postgresql://localhost:5432/mydb |
PrestoDB | jdbc:presto://<HOST>:8080/<CATALOG>/<SCHEMA> |
QuestDB | jdbc:postgresql://localhost:8812/qdb |
SAP HANA | jdbc:sap://localhost:30015/?databaseName=MYDB |
SingleStore | jdbc:singlestore://localhost:3306/mydb |
Snowflake | jdbc:snowflake://account_name.snowflakecomputing.com/?db=MYDB&schema=PUBLIC |
SQLite | jdbc:sqlite:/path/to/mydb.sqlite |
Teradata | jdbc:teradata://localhost/mydb |
TimescaleDB | jdbc:postgresql://<HOST>:5432/<DATABASE> |
Trino | jdbc:trino://localhost:8080/hive/default |
Vertica | jdbc:vertica://localhost:5433/mydb |
YugabyteDB | jdbc:postgresql://localhost:5433/mydb |