Trevor.io for Postgres / MySQL

This add-on is operated by Trevor Technology GmbH

Explore your data, build dashboards and feed live results to Google Sheets.

Trevor.io for Postgres / MySQL

Last updated January 11, 2021

Trevor is an add-on that enables both your technical and non-technical teams to safely access and query your postgres and mysql database data and share the results.

In a nutshell, Trevor:

  • provides the power of SQL, in a point-and-click interface.
  • gives read-only database access to your team using their Google account.
  • lets you export live results into Excel and Google sheets.

Trevor:

  • connects to your database using a read-only transaction (so no bad things can happen).
  • takes just a minute to set up.
  • automatically works out how your tables are connected (using foreign keys and naming conventions).

Trevor also has developer support, including raw SQL snippets and advanced JSON support.

Provisioning the add-on

Trevor can be attached to a Heroku application via the CLI:

$ heroku addons:create trevor
-----> Adding trevor to sharp-mountain-4005... done, v18 (free)

A list of all plans available can be found here.

Once Trevor has been added, it can be opened via the Heroku dashboard, or by using the heroku addons:open trevor command.

Service setup

You will be prompted to enter your database’s DATABASE_URL.

This can be found using the heroku config command

$ heroku config | grep postgres:
DATABASE_URL:                 postgres://zjfofgjmfkyrr:9tSo_Rq9vW28A-HLXhipYv8sc4@ec2-51-243-208-6.compute-1.amazonaws.com:5432/dbi1dht6mmmhun
HEROKU_POSTGRESQL_COPPER_URL: postgres://zjfofgjmfkyrr:9tSo_Rq9vW28A-HLXhipYv8sc4@ec2-51-243-208-6.compute-1.amazonaws.com:5432/dbi1dht6mmmhun

For databases in private spaces you will need to opt into Heroku’s “trusted IPs for data” feature, currently in beta. You can do so by opening a support ticket via one of the Heroku Support channels. You will then be able to allowlist Trevor.io’s IP addresses (34.192.31.89 and 34.192.37.108) via the private space dashboard.

Please note: if you have a follower database, you may wish to connect to this.

Getting started

The easiest way to get a feel for Trevor is to connect and have a play.

However, you can also see an interactive demo of Trevor here.

Inviting teammates

Often you want to give read-only database access to team members, but not necessarily give them Heroku access.

Once you have connected your database to Trevor, you can invite team members using the “Team Access” function (located in the top-right corner of your Trevor dashboard). They will then be able to connect to Trevor using their Google accounts by signing in here.

Troubleshooting

If you have a question or issue, you can get in contact by clicking the in-platform Intercom icon (located in the bottom-right corner of your Trevor dashboard) or send an email to support@trevor.io.

Migrating between plans

Use the heroku addons:upgrade command to migrate to a new plan.

$ heroku addons:upgrade trevor:team
-----> Upgrading trevor:team to sharp-mountain-4005... done, v18 ($99/mo)
       Your plan has been updated to: trevor:startup

Removing the add-on

Trevor can be removed via the CLI.

This will destroy all associated data and cannot be undone!

$ heroku addons:destroy trevor
-----> Removing trevor from sharp-mountain-4005... done, v20 (free)

Support

All Trevor support and runtime issues should be submitted via one of the Heroku Support channels.

For any other issues or questions, you can get in contact by clicking the in-platform Intercom icon (located in the bottom-right corner of your Trevor dashboard) or send an email to support@trevor.io.

Feedback

Log in to submit feedback.