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:
- Navigate to Administration | Add-ons | Db Console.
- Select the database table to query from.
- Select the columns to include as part of the query, or leave it blank for all the columns.
- Optionally, you can construct your own queries in the Enter SQL text field.
- Click on the Execute button to run the SQL query:
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.