Ask Jira

Ask Jira anything in natural language and get the answers you need, fast.

Comment

Inspiration

AI is the future for users to interact with systems. We wanted to bring AI to Jira in a creative, powerful and un-expensive way.

What it does

Ask Jira allows users to search any data in Jira using natural language, regardless of their technical expertise. Users type their questions into the Ask Jira search box and get relevant results in a few seconds.

How we built it

  1. SQL for Jira: it is a cloud-based database emulator for Jira that allows users to search any Jira data with standard SQL, beyond just issues. It discomposes SQL statements into calls to the Jira REST APIs and computes the results, emulating a real database that runs in the Jira security context of the calling user honoring Jira permissions.
  2. ChatGPT: for Natural language (NL) to SQL translation.
  3. Forge: it allowed us to hide our OpenAI API key at a fraction of the cost of other solutions.

Challenges we ran into

  1. One challenge was creating a large dataset of labeled SQL queries with thousands of records to fine-tune AI in a short period of time, given the tight Codegeist deadline.
  2. We faced an additional challenge when we decided not to reuse ChatGPT's out-of-the-box knowledge to build JQL queries, but instead fine-tune it to learn JQL from SQL. This worked unexpectedly well from the beginning.
  3. Unlike other AI features, such as text summarization, NL to SQL translation is intolerant of errors.

Accomplishments that we're proud of

  1. we are really proud of our Responsible AI implementation (RAI). Ask Jira displays the exact SQL query used to generate the answer, so we can understand the reasoning behind it.
  2. Furthermore, It fully respects Jira permissions and data privacy as we trained AI with an abstract database model instead of customer's specific data.
  3. Ask Jira has one of the highest success ratio in the market to undertrains users' NL questions in Jira and get accurate results.

What we learned

We learned that AI really works and it is capable to accomplish complex tasks as well as than the average user at least, and much faster.

What's next for Ask Jira

Ask Jira is POC about how to integrate AI with Jira at data level. We do not have any specific plans about next steps.

Built With

Share this project:

Updates