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.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...
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