1,471
Customers have installed this add-on in at least 1,471 active instances.
    by Scandio GmbHfor Confluence Server 5.5 - 5.10.6 and more versions
    Versions available for Confluence Server 4.0 - 5.4.4
    Unsupported
    This add-on isn't formally supported, but you can ask a question via Atlassian Answers.

    Ask a question

    Supported
    Scandio GmbH supports this add-on.

    Get support

    Get it nowFree add-on

    Execute parametrized SQL queries to external databases within Confluence pages while ensuring secure maintenance by administrators

    Execute parametrized SQL queries to external databases within Confluence pages while ensuring secure maintenance by administrators

    Run Predefined Queries to External Databases

    Maintain Database Queries as Administrator

    Visualize Query Data

    Display data from different SQL databases well-arranged in your Confluence Wiki. Use the PocketQuery macro in as many pages and as many times as you wish. Integration from different sources at one place!

    Prepare database queries that can be executed and parametrized as Confluence Macro. Enforce clearly defined security and access mechanisms that are configured by Confluence administrators.

    PocketQuery has the Google Charts API embedded. In next to no time you'll have data from your external database visualized with different types of charts in your Confluence page.

    More details

    PocketQuery is a Confluence SQL Plugin that allows administrators to create database queries that can be parametrized, excecuted and visualized on every page. It offers custom templating, security mechanisms, embedded Google Chart API and much more.

    Read our Blog article for a description of the features of PocketQuery 2.1!

    Breaking News: the lightning talk on PocketQuery from the Atlassian User Group Augsburg/Munich is online! Watch it here.

    Other resources:

    User reviews

    (40)
    Sign in to write a review »
    by Alex Anh on 2016-07-19
    I love this plugin, and wish that they will consider the WRITE (Insert / update) function instead of SELECT only. Tks the developers.
    Was this review helpful?YesNo

    Scandio GmbH

    Thanks for your review. We explicitly don't want to support manipulating statements with PocketQuery. This is a matter of security. PocketQuery is designed to be a read-only tool.

    by Cuto Calleja on 2016-05-25
    I've been spending some time in challenging its possibilities for dashboarding with confluence using a "real time Oracle database". It's quite 'simple' to use despite that to go for 'advanced features', it is required to have "some" advanced technical knowledge in templating offering the possibility to do everything with data and in presenting results using Google Charts. One of the nice possibilities I have explored is to incorporate in the page "dynamic filtering" in order to have the possibility to obtain advanced statistics for many graphical reports at the same time. At this time I feel confortable to produce very nice dashboards on the screen and I try to move on in exploring its possibilities to cover the 100% of my needs to produce reports. Support provided by Scandio/Felix is excellent considering that we are talking about a free addon. Felix has been very patient in providing me many solutions to the issues I've found during my tests. Thanks again, Felix! ;) There are 2 main things that, if improved, will make this addon perfect for our needs: - The pocketquery administration. Given that its administration is in the main console of Confluence if produces some issues regarding the administration rights. It could be better to offer the possibility to provide administration features at the level of page/macro at least for query management and template management. In adition to that, the administration could be better managed by "subjects" given that when many queries and templates are incorporated it becomes difficult to have everything under control despite using "descriptive" names for them. - Offer the possibility to print out. Information at the screen is nice and it is already a lot... but I need also to provide reports on "paper" or to have the possibility to export it into pdf or doc documents, what, up to my knowledge is not at this moment "easily" feasible using Google Charts given that the on the spot exports features of Confluence are not working properly for this macro. As a conclusion, I would like to congratulate for the addon and I am looking forward to see its future evolutions!! Regards
    1 out of 1 found this review helpful
    Was this review helpful?YesNo

    Scandio GmbH

    Hi Cuto! Thank you very much for this great detailed review and thank you also for the feature requests! Highly appreciated! Felix

    by Pranjal Shukla on 2016-05-25
    This is a Fantastic Add-On and has taken capabilities of our Confluence Instance to superlative level. It has now become one stop portal for senior management folks to check Charts/Data (reports) from confluence. They need not go to other tools to view respective reports as we have integrated everything inside Confluence. Despite being a free plugin, the support for this is amazing and Felix does reply to all your queries. Keep going Scandio...Cheers!!!
    Was this review helpful?YesNo

    Scandio GmbH

    Hi Pranjal! Thank you very much for this great review!

    by Dan Bishop on 2016-05-18
    Fantastic add-on! Provides a high level of customization for our reporting requirements on Confluence. We are very thankful to the developers for their continued support of this FREE add-on!
    Was this review helpful?YesNo

    Pricing

    Support

    Atlassian Support supports PocketQuery. You can ask a support question via Atlassian Answers to get help.

    Ask a question

    Versions

    Version 2.1 Confluence Server 5.5 - 5.10.6 Released 2016-05-25

    Summary

    Group-based administration and other new features

    Details

    Check out our news article on PocketQuery 2.1

    • Group-based PocketQuery administration
    • Query parameters of type Boolean
    • Query parameters in SELECT clauses
    • Render custom templates also when errors occured
    • Deactivate auto-load for dynamic load

    Installation

    1. Log into your Confluence instance as an admin.
    2. Click the admin dropdown and choose Add-ons. The Manage add-ons screen loads.
    3. Click Find new add-ons from the left-hand side of the page.
    4. Locate PocketQuery via search. Results include add-on versions compatible with your Confluence instance.
    5. Click Install to download and install your add-on.
    6. You're all set! Click Close in the Installed and ready to go dialog.

    To find older PocketQuery versions compatible with your instance, you can look through our version history page.

    Similar add-ons