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 JIRA Home Directory and DB Browser add-on installed. You can download it from the following link and install it with the UPM:
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, as shown in the following screenshot:
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 the SELECT queries, which are read-only, but care must be taken, since you are allowed to run any arbitrary valid SQL statement, including INSERT and UPDATE. Direct data manipulation is discouraged, as it might lead to irreversible data corruption and system outages.