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?
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.
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.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG