In the previous recipe, we looked at how to view JIRA log files online, which is a very convenient way to troubleshoot problems. In this recipe, we will continue with this by looking at how you can run queries against the JIRA database from the JIRA UI directly.
For this recipe, we need to have the Home Directory Browser for JIRA add-on installed. You can download it from the following link and install it with the UPM:
https://marketplace.atlassian.com/plugins/com.atlassian.sysadmin.homedirectorybrowser
Perform the following steps to query the JIRA database directly in the JIRA UI:
The Db console opens up a direct connection to JIRA's database, allowing you to run any SQL statement just as if you are using a native SQL client.
It is a great tool to run SELECT
queries which are read-only, but since you are allowed to run any arbitrary valid SQL statement, including INSERT
and UPDATE
, care must be taken. Direct data manipulation is discouraged, as it might lead to irreversible data corruption and system outages.