SQL+JQL Driver: Transform JQL into SQL

for Jira Server 7.0.0 - 8.19.1, Jira Data Center 7.0.0 - 8.19.1 and more
1,828 installs
  • Supported
  • Jira Service Management

All the power of the SQL and JQL languages working together with no limits

YouTube's thumbnail image for the video.

Full control of data with maximum flexibility

All the power of SQL to take control of every detail reading issue data.

SELECT SUM, COUNT, MAX ... FROM ... JOIN ... GROUP BY ... HAVING ... OFFSET LIMIT and a lot of SQL functions for complex queries and calculations

Get the maximum value of your data from everywhere

Build end-to-end queries for Jira Core, Software & Service Desk, and other popular Marketplace apps

Build your own collection of JQL functions and custom fields

Built-in report & analytics capabilities for Dashboards

Maximum connectivity

Get the benefits of the industry-standardsPlug Jira data into your corporate ALM reporting system with web services for REST, CSV, JDBC to integrate PowerBI, Tableau etc. or export to Excel with 1-click

More details

  • Pure SQL: industry-standard, well-defined data model, strong data type support
  • SQL is executed in the context of the calling user honoring Jira permissions!
  • Support for Jira Core, Software, and Manager
  • Support for JQL to search for issues from SQL queries
  • Zero configuration
  • Support for standard JDBC over HTTP to connect remotely
  • Support for public REST JSON and CSV APIs to integrate Jira data with industry popular tools: MS Excel, MS PowerBI, Tableau, etc.
  • Read-only
  • Support to build custom JQL on the fly, custom fields, dashboards, run workflows, etc. with support for basic, powerful, and friendly analytics (pivot table)
  • Support for exporting Jira data to Excel
  • It is powered by the popular H2 Java database by reusing its SQL language parser and its high performer engine plus all the built-in H2 SQL functions to manipulate data from the queries
  • It supports Eclipse BIRT to build advanced custom visual reports (free app available on the Atlassian Marketplace)
  • Privacy and security

    Privacy policy

    Atlassian's privacy policy is not applicable to the use of this app. Please refer to the privacy policy provided by this app's vendor.

    Vendor privacy policy

    Security

    This app is part of the Marketplace Bug Bounty Program. Learn more

    Resources