...

Download the driver above and install it on your favorited Java tool as usual.

JDBC connect string

Then configure a connection to the SQL Cloud database:

...

• URL: jdbc:jira-cloud:<port> (a random any available local port)

• Username: Must match the name of the Jira instance (https:<instance>.atlassian.net>net)

• Password: Must match the password on SQL Cloud - Query Server page (https://<instance>.atlassian.net/plugins/servlet/ac/expert.marketplace.jira.cloud.sql/sqlc-server)

...

--add-opens java.base/java.text=ALL-UNNAMED

How it works

...

SQL Cloud is a 100% JavaScript database. Therefore a browser page is always required to run the database. This As it is a app for Jira page, hence the user must be logged in Jira to view the page and connect to.

This may look weird, but the JDBC Driver cares about this process as it is capable to automatically open a page on your favorite browser when it is required, run the database on it and connect to. There is no user’s action required.

Of course, that page is provided by the SQL Cloud app:

...

The database username is the Jira instance name (same as in the URL page).

The database password can be read from that page. Initially a random password is created, but the user can change it or create a new one automatically by saving whether it is blank saved.

The database port does not matter. You can use any one available in the local machine and the JDBC Driver will use it for all the local communication. This is also set in the JDBC connection URL.

...