Is there a way to connect to the jira cloud database using sql developer or squirrel sql client

[Gurdipe Dosanjh]

Hi

Is there a way to connect to the jira cloud database using sql developer or squirrel sql client or is there a add on available that allows you to look at the database tables and write queries against them?

Kind Regards

Gurdipe

Mobile: 07879682511

[Andy Heinzer · Accepted solution]

Yeah sorry to report, but the Jira Cloud database is not accessible to Cloud subscribers.   This is certainly something you could control if you were using the Server line of products as you would need to setup that up in order to connect Jira to a database on setup.

However the Cloud offerings do not provide a means to directly access the SQL database in any way.

[Gurdipe Dosanjh]

Thank you for replying

[Nic Brough -Adaptavist-]

No.

And you shouldn't ever be connecting to a Jira database on any system.  Apart from some data related to bug fixing, SQL should not be used with Atlassian systems.  It is the worst possible way to report on Atlassian data, and you cannot write to an active system.

[Gurdipe Dosanjh]

Thank you for replying

[alan_treston]

So what is the best way of reporting off Atlassian data?

[Nic Brough -Adaptavist-]

Use the REST API to interrogate it.

As a simple example, look at "show me the issue data".  For the most simple of issues (a couple of comments and one custom field), you need at least 30 joins in the statement, and that increases with every field, comment, and change to the issue.  Or you can use a single REST call to get the issue, no matter how complex.