Mysql datatbase documentation

[shashank_bhuvanala]

Is there any features to ocment the mysql database in jira

[Nic Brough -Adaptavist-]

Please note that there is very little use for having the Jira database schema.

You can not write to a Jira database with an external application, and reading it is ugly, complicated, slow and because most of the logic is done in the application, it often doesn't have the data you want.

Whatever you are doing, please, use the REST API to read/write Jira, not the database.

[JimmyVanAU]

Hi @shashank_bhuvanala

Welcome to the community. To add to Daniel's answers, have a look at:

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

The first few links provide pdf links for the database schema of Jira, which is what I think you're interested in. Note that it only goes up to Jira 7. It is likely that you are running Jira 8, in which case the consequent jar's would be helpful. In the UPM (Universal Plugin Manager) for Jira, upload the jar's. This will then allow you to generate the latest database schema.

This is very helpful too if you have additional marketplace apps installed. The app will also describe the active object (AO) tables where app data is stored.

Hope that answers your question!

Cheers, Jimmy

[Daniel Ebers]

Hi @shashank_bhuvanala

could you please add details what you are trying to achieve?

You either could be understood in a way you want to connect Jira to a database, then the following guide should help you get started:

• Connecting Jira application to MySQL
  https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-8-0-1018775461.html

In case your question is if you can display data from a MySQL database in fields of an issue - yes. There are Apps, like Script Runner which can provide a "Database Picker":
https://scriptrunner.adaptavist.com/6.15.0/jira/script-fields/database-picker.html

Please let us know if you meant something else.

Regards,
Daniel

[shashank_bhuvanala]

No, 

We are developed a web application in php(Laravel) along with mysql datatbase.

We are planning to use jira for the same web apllication for enhancements.

So we already have the mysql database along with data.

For the same database we done documentaion using third party application "dataedo".

So as planning to shift to jira, is there any fetaure such as dataedo for mysql database documnetation.

The documentation basically tells about the database tables and their scehams and their descriptions.

Can you please help me on this.

[Daniel Ebers]

If I understand you correctly you are aiming towards a solution like "dataedo", but something for Jira (an App). You could always check https://marketplace.atlassian.com but I suspect the better tool to do it would be Confluence.

Please also see:

• Develop technical documentation in Confluence
  https://confluence.atlassian.com/doc/develop-technical-documentation-in-confluence-226166494.html

The good news is: Jira is pretty flexible, so with some effort you could still reach your goal. But you would have to check with you team if it is the suitable solution.

You always can use a trial license to have a look around and check if it meets your needs (same applies to Confluence).