This add-on is operated by Trevor Technology Limited
Postgres / MySQL / Redshift querying interface your whole team can use
Trevor.io Query Builder
Last updated 28 March 2019
Table of Contents
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.
- 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.
You will be prompted to enter your database’s
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 emailing the email@example.com email address. You will then be able to whitelist Trevor.io’s IP addresses (22.214.171.124 and 126.96.36.199) via the private space dashboard.
Please note: if you have a follower database, you may wish to connect to this.
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.
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.
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 firstname.lastname@example.org.
Migrating between plans
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)
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 email@example.com.