This add-on is operated by Ivan Schneider
Business intelligence insights and analytics from your database
DbInsights
Last updated 20 February 2019
Table of Contents
DbInsights provides you with business intelligence insights and database analytics with minimum efforts on your part. This add-on provides you with an interface to define line charts, pie charts and custom queries on your database that you can then assemble in reports. It also supports advanced features such as cohort analysis and automatic joins for building complex queries.
You can check out the sandbox account to get the feel of it.
The currently supported RDBMS are PostgreSQL and MySQL.
Installing the add-on
DbInsights can be installed for a Heroku application either via your Heroku dashboard or via the CLI:
$ heroku addons:create dbinsights
In order to generate charts on your data, DbInsights needs to be able to connect to your database. The easiest way to do that is to open the DbInsights interface either through the Heroku dashboard or from the CLI:
$ heroku addons:open dbinsights
You will be prompted for an Heroku OAuth permission, DbInsights will fetch and store an encrypted version of the DATABASE_URL of your application (removing the add-on from your application will delete that info from the DbInsights database).
Integration
DbInsights doesn’t need to integrate at a code-level and thus isn’t tied to a particular language. It can be used with any app hosted on Heroku, be it Ruby, Node.js, Clojure, Java, Python, or Scala, as long as it makes use of a PostgreSQL or MySQL database.
Once you’ve completed the previous section you’re all set to use the DbInsights interface.
DbInsights interface
The interface can be accessed via the CLI:
$ heroku addons:open dbinsights
or by visiting the Heroku Dashboard and selecting the application in question and then selecting DbInsights from the add-ons menu.
For more information on using the DbInsights interface please see the docs at dbinsights.herokuapp.com/docs.
Migrating between plans
Use the heroku addons:upgrade command to migrate to a new plan.
$ heroku addons:upgrade dbinsights:standard
Removing the add-on
DbInsights can be removed via the CLI.
This will destroy your charts configuration data and the encrypted version of your DATABASE_URL from DbInsights database. This cannot be undone.
$ heroku addons:destroy dbinsights
Support
All DbInsights support and runtime issues should be logged with Heroku Support. Any non-support related issues or product feedback is welcome at dbinsights.uservoice.com.
Additional resources
Additional resources are available at :