Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting to Jira DB and do the SQL Execution / Editing

Soumya
Contributor
July 1, 2022

Hello Team,

I want to connect Jira postgres db using DBeaver tool.

How can I do ?

2 answers

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 1, 2022

You do not.  You should not be looking at a Jira database, it's a complete mess as far as reporting and data relationships are, and it is the worst possible way to look at a Jira system.

As for write.  No.  

No. No. No.

You will probably get it wrong, and if you do, you will corrupt your system, possibly rendering it unusable, but even if you don't damage it too badly, you'll run into problems later, including never being able to upgrade.

And that's assuming you do the writes in the only safe way - Jira must be shut down when you write, and re-indexed immediately after restart (although you probably won't need to bother with that, as you'll almost certainly want to be restoring the database back to the backup you took before you made any change)

0 votes
Joe Pitt
Community Champion
July 1, 2022

DO NOT DO ANYTHING BUT READ THE DATABASE. EDITING IT RISKS MAKING JIRA UNUSABLE 

Only use the UI or the Jira API to do anything

Suggest an answer

Log in or Sign up to answer