Can i acess the JIRA DataBase to run my own Querys?

Tatiane Silva October 23, 2011

Hi guys,

I'm wondering if i can make mwy own querys in JIRA database instead of using JQL.

I need more specific searchs to support my decision management.

We will use JIRA Local instead of JIRA Hosted, so, i think i have control of the database.

Am i correct? Any comments?

Thanks a lot!

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

3 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 23, 2011

Yes, help yourself. But bear in mind

  1. You must not write to it (unless Jira is offline and you re-index after starting it)

Risks:

  1. Zero security - with read access to the database, a user can effectively bypass any and all security you've set up in Jira. It's only acceptable if your users can be trusted, or you have a blanket "anonymous can browse *all* issues" setup.
  2. Load 1 - direct access to a large Jira database can have an impact on the database server, which could potentially slow the Jira system access. Queries with large data set results can become a problem
  3. Load 2 - inefficient queries can easily cause load problems too

Have a look at http://confluence.atlassian.com/display/JIRA041/Database+Schema# to get started. It's quite complex...

Tatiane Silva March 25, 2012