It is a 100% JavaScript database running on the browser and it is capable to virtualize a REST API as a relational database.

Atlassian’s public REST API for Jira Work, Software, and Service Manager are covered by this app and transformed into real-time and read-only database tables that the users can query with standard SQL.

It is also capable to run SQL and JQL in the same query getting the best of both languages working together.

Jira permissions

This app does not require any extra configuration by administrators to keep data under control as it relies 100% on the Atlassian public REST API to fetch data. So there is no way to fetch any unauthorized data from Jira. Jira permissions are honored always automatically and under all circumstances. If an administrator wants to change data-access permissions in the app then this has to be done from the Jira admin section in a regular way.

Data privacy

Even more: we have designed this app and its data privacy with an extremely paranoid mind! Hence, it is serverless: there is no server on our side (nor any third party) listening to your data. All the traffic occurs between Jira and the user’s browser in 100% of the cases. No data are sent anywhere. No data are saved anywhere. Your data is YOUR data. The app, including the database, is 100% JavaScript running on the user’s browser. Each Jira user completely owns an instance of the database which does not communicate with any other.

App permissions

Of course, there is required a minimal admin configuration specific to the app. The Vision SQL GUI is not intrusive. Just after the installation none will be aware of its presence in their daily work since the app keeps the Jira GUI unchanged until the admin grants some users or groups access to the specific functionality. In that case, the granted users will see one or two new menu actions under the Jira main top menu.

Admins must not care about anything else, as from that point, and beyond all the permissions, access to the data is managed by Atlassian through their public Jira REST API.

Shareable queries

Hence Jira admins must not have to worry about who runs an VSQL query as every SQL query returns data according to the running user’s permissions in Jira. I.e.: user A writes a query → The user B runs A’s query → A and B get different results accordingly to their permissions in Jira.

No overwhelming

Legacy databases (Oracle, MSSQL, PostgreSQL, MySQL, H2, etc.) supports their own user base and native permissions. VSQL is different and it replaces them with Jira equivalents: the VSQL user base is just the same as the Jira user base and the VSQL database permissions are just the same as Jira permissions. Neither extra work, worries, nor headaches for admins!

Reliability & Scalability

Since the app is serverless there is no extra point of failure. Every user’s PC becomes an isolated database instance. Hence the app scales with the user base automatically with no bottleneck.

The app is distributed and cached along the World with Amazon’s CloudFront service therefore the up times SLA is provided by Amazon.

Data storage

The app does not send data anywhere nor saves data anywhere else. So you, as admin, do not have to worry about hackers stealing your organization’s data.

The user’s queries are automatically saved for later use. Did you write a useful query 10 minutes ago and you want to use it again? Don’t worry. Your query is still there waiting for you to get it from the VSQL History.

Furthermore you will avoid security threats by using BBCode instead of JavaScript to enricher your contents as running JavaScript is prone to XSS (Code Injection) attacks.