572
Customers have installed this add-on in at least 572 active instances.
    by Kinto Softfor JIRA Server 7.0.0 - 7.3.1
    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
    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

    Transform JIRA into a Relational Database Server

    100% compliance with JIRA data security & privacy

    All the power of JQL and standard SQL working together... Can you imagine anything more powerful for reporting on JIRA Core and Software/Agile?

    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 without requiring any configuration.

    More details

    It unifies the JIRA APIs (Java Core and REST Software at the present) under an uniform layer of standard SQL.

    It also allows to extend native JIRA JQL capabilities by building custom JQL functions on the fly and avoid most of the 3rd party plugins' opacity. You decide how they exactly work without complex scripting. Only SQL combined with JQL.

    It has been designed for painless administration and secure and massive usage as well as to support reporting and business intelligence industry-standards to connect JIRA data to a lot of compatible tools for reporting and data analysis.

    There are free extensions available in the Marketplace to extends its visual reporting capabilities with unparalleled flexibility, user friendly and powerful GUIs.

    It supports a SQL console to write SQL queries right within JIRA and with support for Excel exporting.

    User reviews

    (10)
    Sign in to write a review »
    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
    by Anere Goodness on 2015-11-24
    This Plugin is fantastic and helped me to pull out reports that are not possible by JQL. Its awesome.
    Was this review helpful?YesNo

    Pricing

    Support

    Kinto Soft supports SQL for JIRA Driver - Convert JQL to SQL. You can ask a support question via Atlassian Answers to get help.

    Ask a question

    Versions

    Version 3.1.2-jira-7 JIRA Server 7.0.0 - 7.3.1 Released 2017-02-02

    Summary

    Bug fixes

    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