Not 100% what you are looking for, since you specify "installed in apps as a package", but we are using https://redash.io/ and love it. They are open source and very easy to run ad-hoc queries, save/schedule queries and alerts, and build dashboards.