The app provides its own built-in Console to explore the database model as well as write and execute SQL+JQL queries right within Jira.

Any JQL query can be transformed into a SQL statement with a single click from the:

Exporting from Jira is limited to 1000 issues by default in Jira. In such case, you get an error message like this:

Workaround: Remove the current JQL before exporting to the SQL+JQL console. This will make most examples stop to work as no default JQL will be available. You can set the default JQL by adding it as a parameter to the URL console (see below).

The SQL console can also be opened from your browser by using the following link:

Optionally, a JQL can be provided as URL parameter:

As SQL for JIRA re-uses the JIRA HTTP session you have to login in JIRA from your browser prior to access to the SQL console.

Hide the menu

The SQL Console action can be hidden from the Export menu in the Issue Navigator:

Open the app configuration page from the UPM, click on the N of N modules installed link and search for the  with key kintosoft-sql-export-jql (the name of the label might vary between versions)