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.
The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs