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!
PocketQuery 3.8.0 is now available on the Atlassian Marketplace! With this release you can now configure global timeouts and resource limits for your queries.
If you have already been using PocketQuery for a while but are new to PocketQuery 3, have a look at the Getting Started Part 2 - REST and Converters. It covers a good amount of the new features.