Create Connection

Learn how to set up database connection information and create a connection.

Add Connection

Add a new database connection to the project.

1

Click Add Connection Button

Click the "+" button in the connection list on the left panel.

2

Select DBMS

Select the database type to connect. Supports MariaDB, MySQL, Oracle, PostgreSQL, SQL Server, SQLite, and H2.

3

Enter Connection Info

Enter the host, port, database name, username, and password.

4

Test & Save Connection

Click the "Test Connection" button to verify, then click "Save".

커넥션 생성

Connection Fields

Detailed description of the fields required when creating a connection.

FieldDescriptionExample
Connection nameDisplay name for identificationDevDB, ProductionDB
HostDatabase server addresslocalhost, 192.168.1.100
PortDatabase service port3306 (MySQL), 5432 (PostgreSQL)
DatabaseDatabase (schema) name to connectmyapp_dev
UsernameDatabase access accountroot, admin
PasswordPassword for the access account-

Database-Specific Settings

Connection settings 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

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)

Connection Test

Verify that the entered connection information is correct before saving.

Note: If the connection test fails, check the host address, port, firewall settings, and database access permissions.