713
Customers have installed this add-on in at least 713 active instances.
    by Marketplace Expertfor JIRA Server 7.0.0 - 7.3.6 and more versions
    Versions available for JIRA Server 6.1 - 6.4.14
    Unsupported
    This add-on isn't formally supported, but you can ask a question via Atlassian Answers.

    Ask a question

    JIRA Service Desk
    This add-on is compatible with JIRA Service Desk.
    Supported
    Marketplace Expert supports this add-on.

    Get support

    Data Center
    This add-on is compatible with the clustering and high-availability capabilities of our products.
    JIRA Service Desk
    This add-on is compatible with JIRA Service Desk.
    Get it nowFree add-on

    Convert any JIRA JQL query into standard SQL in a straightforward way... and do much more than with JQL alone

    Convert any JIRA JQL query into standard SQL in a straightforward way... and do much more than with JQL alone

    Seamlessly conversion of JQL into standard SQL

    JIRA transformed into a Relational Database Server

    100% compliance with JIRA data security & privacy

    All the power of JQL and standard SQL working together without any restriction... Can you think on anything more powerful for reporting on JIRA?

    Transform JIRA into a read-only relational database server listening to the standard HTTP/S port and use standard JDBC to remotely access to your JIRA data and perform JQL as SQL... from your favorite reporting tool

    It is fully compatible with the JIRA users' account and permissions. Every SQL query runs under the privileged JIRA user's context. The plugin fully reuses the JIRA user base without requiring any user management task

    More details

    Make JIRA Core and Software/Agile compatible with industry-standards for reporting. With a single click, you are able to transform JIRA into a real database server powered by the JIRA API and perform JIRA JQL queries as SQL statements.

    The plugin fully works out of the box without requiring any administrative task. It reuses the current JIRA user base and permissions configuration.

    There are some killer extensions available on the Marketplace to improve the its capabilities with unparalleled power and flexibility to cover the relational and analytics reporting in a visual way.

    Full support for exporting to Excel.

    User reviews

    (12)
    Sign in to write a review
    by Sebastian Pohl on 2017-05-12
    Great addon for additional statistics and summaries. Jira and the Agile reports don't give me the statistics and summaries I need. Using SQL for Jira and the Birt reports I was able to create my own charts in the Jira dashboard. Support is also fast and great!
    Was this review helpful?YesNo
    by ernesto_laing@avivacanada.com on 2017-02-22
    Is "Insert" and "Update" are removed? For data safety only "Select" statements should be enabled
    0 out of 1 found this review helpful
    Was this review helpful?YesNo
    by Aaron Palazon on 2016-09-26
    It's great! Thank you! It resolve a lot of things for me. I don't know if I am making some mistakes or whathever but i can't find some information like worklogAuthor (the name, not the id) and the date the user put in the issue when log the work instead of the created worklog. Thank you another time!! :)
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    by Prajwal Tirpude on 2016-05-03
    Very Powerful since the jql is supported inside SQL queries which makes it awesome
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    by Agustin Martin on 2016-03-28
    Very powerful addon indeed! I've spent months searching for a way of reporting the number of times an issue was reopened during a certain period of time. I didn't like currently available solutions based on too complex plugins, or cumbersome custom fields with triggers. However with SQL for JIRA creating such a query is a breeze! Thank you!
    1 out of 1 found this review helpful
    Was this review helpful?YesNo

    Pricing

    Marketplace Expert provides support for this add-on.

    Vendor support resources

    Documentation

    Find out how this add-on works.

    Atlassian Community

    Atlassian-hosted discussions connect you to other customers who use this add-on.

    Versions

    Version 3.2.0-jira-7 JIRA Server 7.0.0 - 7.3.6 Released 2017-02-27

    Summary

    JIRA 7: Data Analysis plugin no longer mandatory

    Details

    Please read the changelog

    Installation

    1. Log into your JIRA instance as an admin.
    2. Click the admin dropdown and choose Add-ons. The Manage add-ons screen loads.
    3. Click Find new add-ons from the left-hand side of the page.
    4. Locate SQL for JIRA Driver - Convert JQL to SQL via search. Results include add-on versions compatible with your JIRA instance.
    5. Click Install to download and install your add-on.
    6. You're all set! Click Close in the Installed and ready to go dialog.

    To find older SQL for JIRA Driver - Convert JQL to SQL versions compatible with your instance, you can look through our version history page.

    Similar add-ons