Its possible to read data directly from a jira server database?

Question

We are using API calls in our application but in some cases reading data from issues takes a lot of time, is it possible to access the database (according to the configuration of jira it runs on mysql57) to retrieve the data directly from it? if possible what should we need to have this running?

Florian Bonniec · Accepted Answer

Hi @Enrique Valverde Soriano

I usually avoid to query the db directly but you can do it by connecting to the db. You need your db admin to create an account with read only access to the jira db they have configured for the app.

Then base on the JIRA db schema and the jira version you can query the db using script or mysql workbench for instance.

https://developer.atlassian.com/server/jira/platform/database-schema/

Regards

Nic Brough -Adaptavist- · Accepted Answer

Welcome to the Atlassian Community!

I very strongly recommend that you do not do this.  The Jira database is not intended for any form of reporting, it's a data store for the application.

If you go down the route of reading the database, you will be making a world of pain for yourself.  At best, you're going to be spending months working out what SQL might get you the same data a simple REST call can fetch in one go.  At worst, you're going to be building SQL that is howlingly non-performant and makes Jira unusable for everyone.

As an example "show me an issue that has one custom field set" means at least 18 joins, some 2-5 layers deep.

Please, stick with the REST calls.  They're easier, cheaper, and the right way to do it.