Customers have installed this add-on in at least 619 active instances.
    by Kinto Softfor JIRA Server 7.0.0 - 7.3.3 and more versions
    Versions available for JIRA Server 6.1 - 6.4.14
    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.
    Kinto Soft 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.

    User reviews

    Sign in to write a review
    by ernesto_laing@avivacanada.com on 2017-02-22
    Is "Insert" and "Update" are removed? For data safety only "Select" statements should be enabled
    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!! :)
    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
    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!
    Was this review helpful?YesNo
    by Juan José García [AtSistemas] on 2015-11-25
    This plugin is very useful, the possibility to create flexible JIRA reports visually from Eclipse and embed them in JIRA Dashboards is very amazing. The database web console allows to do queries with jql easily, especially to do joins between tables. Great plugin!!!
    Was this review helpful?YesNo


    Kinto Soft provides support for this add-on.

    Vendor support resources


    Find out how this add-on works.

    Atlassian Community

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


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


    JIRA 7: Data Analysis plugin no longer mandatory


    Please read the changelog


    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