Query the Jira Database directly in SQL
Objectives
Objectives of this editor is to simplify the access to the Jira Database when querying it by SQL. It will provide some solutions for some of situations you are facing :
- You are not aware about the Database Schema of Jira and the different Apps,
- You do not know which are the relevant table for an Apps (The native page in System / Plugin Data Storage is long to be displayed on large instance, since a count of rows is done systematically),
- You need to recall some queries previously executed.
- ...
using the Alkaes Database Client , some settings will be welcomed to enhance your experience.
To enhance your usage of the SQL Editor, you may have additional configuration to complete. Discover the Database Schema by applying filter on Apps Query the tables more quickly ... Stop to search you SQL Statements ...SQL Editor - Settings
SQL Editor - Tables Filtering
SQL Editor - SQL Statement
SQL Editor - History