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

[Tatiane Silva]

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!

[Nic Brough -Adaptavist- · Accepted solution]

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]

Also interesting for this subject : http://confluence.atlassian.com/display/JIRA041/Example+SQL+queries+for+JIRA