Supported DBMS & Versions

A summary of the DBMS supported by NeoSQL, their version coverage, and the JDBC drivers bundled with NeoSQL.

DBMSSupported VersionsBundled JDBC Driver
PostgreSQL9.xor later
postgresql 42.7.3
MySQL5.x / 8.x
mysql-connector-j 8.3.0 (8.x)
mysql-connector-java 5.1.49 (5.x)
MariaDB10.x / 11.x
mariadb-java-client 3.0.4
Oracle11g / 12c / 19c / 21c
ojdbc8 23.3.0.23.09
SQL Server2014 / 2016 / 2017 / 2019 / 2022, Azure SQL
mssql-jdbc 12.6.1.jre11
SQLite3.x
sqlite-jdbc 3.45.3.0
H22.x (Embedded / Server / In-Memory)
h2 2.1.214
DatabricksSQL Warehouse (AWS, Unity Catalog)
databricks-jdbc 3.4.2
SnowflakeCloud Service
snowflake-jdbc 4.3.4

Note: To use a version not listed here, register your own .jar file via Add Custom Driver from the JDBC Driver settings on the connection screen (Desktop mode only).

DBMS Connection Guide

Per-DBMS JDBC URL, driver, and default property reference for each database supported by NeoSQL.

MariaDB

FieldValue
Default port3306
JDBC URLjdbc:mariadb://{host}:{port}/{database}
Driverorg.mariadb.jdbc.Driver

Default connection properties:

  • useUnicode=true — Unicode support
  • characterEncoding=utf8 — UTF-8 encoding
  • useSSL=false — Disable SSL
  • allowMultiQueries=true — Allow multiple queries

MySQL

FieldValue
Default port3306
JDBC URLjdbc:mysql://{host}:{port}/{database}
Drivercom.mysql.cj.jdbc.Driver

Default connection properties:

  • serverTimezone=Asia/Seoul — Server timezone setting
  • useSSL=false — Disable SSL

Oracle

Supported versions: 11g / 12c / 19c / 21c

FieldValue
Default port1521
Driveroracle.jdbc.OracleDriver
Driver typeChoose from thin, oci, oci8

Oracle allows you to choose a connection method:

Connection MethodJDBC URL
Service Namejdbc:oracle:thin:@//{host}:{port}/{serviceName}
SIDjdbc:oracle:thin:@{host}:{port}:{SID}

Oracle-specific options:

  • oracleRetrieveRemarks=true — Retrieve table/column comments (may increase query time)
  • oracleRetrieveSynonyms=false — Include public synonyms

PostgreSQL

FieldValue
Default port5432
JDBC URLjdbc:postgresql://{host}:{port}/{database}
Driverorg.postgresql.Driver

SQL Server

FieldValue
Default port1433
JDBC URLjdbc:sqlserver://{host}:{port};database={database}
Drivercom.microsoft.sqlserver.jdbc.SQLServerDriver

Default connection properties:

  • encrypt=true — Connection encryption
  • trustServerCertificate=true — Trust server certificate

Note: SQL Server uses <code>;</code> (semicolon) instead of <code>&</code> as the connection property separator.

SQLite

FieldValue
JDBC URLjdbc:sqlite:{파일 경로}
Driverorg.sqlite.JDBC

SQLite is a file-based database that connects directly to a local file without a separate server.

  • No host, port, username, or password required.
  • Only specify the database file path to connect.

Connection examples:

  • jdbc:sqlite:/Users/user/data/mydb.db — Absolute path
  • jdbc:sqlite:./data/mydb.db — Relative path
  • jdbc:sqlite::memory: — In-memory (volatile)

Note: SQLite is only available in Desktop mode. Since local file system access is required, it is not supported in Web App mode.

H2

FieldValue
Default port9092 (TCP 모드)
Driverorg.h2.Driver

H2 allows you to choose a connection mode:

ModeJDBC URLDescription
TCPjdbc:h2:tcp://{host}:{port}/{database}Remote access over network
Embeddedjdbc:h2:{database}Local file-based access
In-Memoryjdbc:h2:mem:{database}In-memory (volatile)

Databricks

Connect to Unity Catalog SQL Warehouses (Serverless / Pro / Classic) on Databricks on AWS using PAT authentication.

FieldValue
Default port443
JDBC URLjdbc:databricks://{host}:443;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/{warehouseId}
Drivercom.databricks.client.jdbc.Driver
  • Enter the workspace hostname as the host, token as the username, and your PAT as the password.
  • Select an accessible SQL Warehouse to populate httpPath in the URL. When entering a JDBC URL manually, use the httpPath from the warehouse’s Connection details.
  • Database maps to the Unity Catalog catalog and is passed as ConnCatalog. Set the schema through ConnSchema. Do not repeat properties already present in the URL in additional properties.

Snowflake

Connect to a Snowflake account. Select a Database and Schema, and specify the Warehouse and Role for query execution.

FieldValue
Default port443
JDBC URLjdbc:snowflake://{host}/?db={database}&schema={schema}&warehouse={warehouse}&role={role}
Drivernet.snowflake.client.api.driver.SnowflakeDriver
  • Enter your account hostname (<orgname>-<account_name>.snowflakecomputing.com), your Snowflake username, and a Programmatic Access Token (PAT) in the password field.
  • The Warehouse and Role fields populate the warehouse and role properties in the JDBC URL. Running a query may automatically resume a suspended warehouse and consume credits.
  • Database maps to a Snowflake database. When entering a JDBC URL manually, use db and schema to set the default scope. Do not repeat properties already present in the URL in additional properties.