PocketQuery is a Confluence app that allows users to retrieve data from external data sources and effortlessly display it within Confluence. Data sources can be SQL databases or arbitrary REST APIs and the access is encapsulated in a way that easily works with your security standards.
It comes with a handy macro that can be embedded into any Confluence page. The user simply selects the desired query and enters parameters if necessary. After saving, the macro fetches and neatly displays the data. Queries itself can be managed within the PocketQuery Administration interface, which is only available to Confluence users with appropriate permissions.
And there is a lot more to discover! How about adding your query result to the Confluence search index? Or setting parameters dynamically via URL?
Here, you will find a comprehensive feature documentation as well as a number of guides and examples, that should help you get started. Have fun exploring the possibilities of PocketQuery!