Where possible, you should always use an application’s API to retrieve data rather than its database.
To set up a local database connection and make the local database (the one that your Atlassian application is using) available to scripts, follow these steps:
Navigate to ScriptRunner > Resources > Add New Item > Local Database Connection.
Provide a name for the connection in Pool Name.
For local connections, we recommend the name local.
Optionally, enter a query into the SQL field to test receiving information from the database. Use Preview to test out different queries.
This SQL query is not saved and is only used to test the connection.
SQL can be used to run queries harder to achieve using the API.
If the preview is successful, click Add.
The local connection is always read-only (except in the case of H2, where this driver does not support it).