I'm working on a Confluence plugin (not Cloud) and trying to allow the admin to write a custom SQL query in the UI. Once the query is written, a button should trigger the execution of the query, sending it to the backend which in turn sends it to the database and retrieves the results, which I intend to display as a table in the UI.

I'm familiar with plugin development in Jira, but I'm having trouble figuring out the best way to access the database through the Plugin Framework in Confluence. I'm unsure what permissions, dependencies, or configurations are required in atlassian-plugin.xml to make this work. Are there manager classes for it like in Jira (I couldn't find any).

I’ve tried adding some basic dependencies and permissions, but I’m not sure if I’m missing something or if there’s a specific configuration required in Confluence. I expected the database interaction to work similarly to Jira where there was ofbiz and a Manager class for it, but I’m encountering difficulties with the Plugin Framework and database access in Confluence.

Thank you for your time.