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

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

Community moderators have prevented the ability to post new answers.

3 votes

Answer accepted

Yes, help yourself. But bear in mind

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

Risks:

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.
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
Load 2 - inefficient queries can easily cause load problems too

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.