how to connect jira database using python

[chaitali k]

how to connect jira database using python

[Joe Pitt]

I can't answer you question, but doing anything but reading the DB directly can corrupt it. 

[Nic Brough -Adaptavist-]

First hit on search engine for me was for MySQL (one of the four types Jira supports) - see https://www.w3schools.com/python/python_mysql_getstarted.asp

However, exactly as @Joe Pitt suggests, I cannot recommend it.

• You must never ever write to a Jira database when it is active.
• You should probably not waste your time with SQL at all - the database is not suitable for reporting in the slightest, it's a data store, not a database, and you really need to understand it thoroughly before you'll be able to get anything useful from it.  Even a simple "show me a simple issue without custom fields, history, etc" leads to statements starting at 20 joins and they rapidly get more complex.  Oh, and the database regularly changes on upgrade.

Please, look to use the REST API for this - you can get a whole issue with a single statement, and Python has good REST interface.