Piyal Nanayakkara, Jira Data Center is not something I can test so I don’t know if the EJQT works with it or not. The only real difference between Jira Server and Cloud is ordering of the issues object returned by the API. My suggestion would be to try JDC with both settings to see if either of them work.
I am not sure what you mean by migrating the scripts. Google Sheets are cloud based entities. They don’t exist as files in the same way as say Excel files. While they can work offline, to my knowledge the offline functionality does not support Apps Scripts or particularly large sheets.
Unfortunately read-only access is not an option in Git. I thought it was, but apparently it is not. The source is all visible in the tool however.