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

    Ask a question

    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

    When JQL is not enough, this plugin is able to do the rest. It has almost no limits for JIRA advanced reporting.

    It transforms JIRA JQL into standard SQL and supports JQL queries over JDBC. This brings infinite possibilities to JIRA reporting as it allows to use a lot of 3rd party tools to make JIRA JQL-based reports in a straightforward way and fully integrated with the current JIRA users' accounts and permissions.

    The SQL for JIRA Driver also supports common reporting tasks like

    • Export to Excel
    • Build your custom JQLs on the fly to improve JIRA native capabilities
    • and much more...

    There are some killer extensions for this plugin on the Marketplace to cover much more reporting and analytics requirements than with SQL+JQL alone:

    • For JIRA-integrated reports running as JIRA gadgets in Dashboards, use the he Eclipse BIRT extension (optional).
    • For JQL-based Business Intelligence use the Data Analysis extension.

    User reviews

    (7)
    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

    SQL for JIRA Driver - Convert JQL to SQL isn't formally supported.

    Versions

    Version 3.1.1-jira-6 JIRA Server 6.1 - 6.4.14 Released 2016-12-06

    Summary

    JIRA 6: Critical 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