It is a pure Javascript database running on the user’s browser that supports the industry.standard SQL language close to the '99 specification.
IIts unique features make it particularly a suitable solution for the Cloud. It fact it was designed with that purpose in mind.
The database is created when the html page is loaded and destroyed when the page is closed.. During its creation process a comprehensive schema is created with a lot of tables representing almost all entities of Jira Core Software and Service Manager (issues, projects, boards, sprints, SLA, queues, etc).
All the built-in tables have no data. They are empty and populated in real-time to answer the users' queries: all the data are fetched over the Jira public REST API sharing the same user’s http session: in other words, all the queries run in the calling user’s context honoring the Jira permissions. Therefore, it does not require any users nor permissions configuration as they are implicitly inherited from Jira.
The installation process is 1-click from the Atlassian Marketplace and it is ready to run out-of-the-box with no further configuration.
In addition, it supports the Atlassian JQL language to search for issues in SQL queries taking advantage of the best of both languages working together with no limits.
In this area you will learn about