Trevor.io for Postgres / MySQL

Explore your data, build dashboards and feed live results to Google Sheets. Starting at ~$0/hour.

Read-only data playground

Trevor.io gives your team a safe (read-only) playground for them to explore your database data for answers:

  • Invite team members using their Google or work email address (no need for Heroku access).

  • Hide tables and columns that you don’t want team members to see.

Build queries with or *without* SQL

Trevor.io provides the full power of SQL in an easy-to-use point-and-click interface. Filter, Sort, Aggregate and perform complex Joins, all using the comfort of your mouse.

Even supports timestamp calculations, regex extraction, string interpolation and JSON extraction.

Export live results

Effortlessly export your queries’ results into Google sheets and Excel. Build graphs and charts off the data, and have the results automatically refresh every hour.

Zero setup required

Just choose the Postgres or MySQL database you wish to connect to, and Trevor.io will automatically work out how all your database tables are connected (via foreign keys and implicit naming conventions).

Loved by Great Companies

You’re in good company - Trevor.io is trusted by companies around the globe:

  • Everyone at Team Lexoo has used Trevor.io to get answers from our data. It's a brilliant tool. Curran from Lexoo.

  • I had been looking for an out of the box data analytics platform for months. Trevor.io is in a league of its own. Tribe.

  • We're super happy with Trevor! Emma from Honeypot.

  • We got Trevor set up in lightening speed. The ease and flexibility of querying means more fact and less guesswork in decision making for everyone. The support has also been second to none! Joe from Trail.

Region Availability

The available application locations for this add-on are shown below, and depend on whether the application is deployed to a Common Runtime region or Private Space. Learn More

  • Common Runtime
  • Private Spaces
Region Available
United States Available
Europe Available
Region Available Installable in Space
Dublin Available
Frankfurt Available
London Available
Montreal Available
Mumbai Available
Oregon Available
Singapore Available
Sydney Available
Tokyo Available
Virginia Available

Plans & Pricing

    • Live-feed results into Google sheets / Excel / Slack / Email / Zapier
    • Dashboards
    • Row limit per export 50,000
    • Number of users unlimited
    • Advanced charting customization options
    • Number of datasources 1
    • Custom SQL
    • Audit reports
    • Enforce SSO
    • Live-feed results into Google sheets / Excel / Slack / Email / Zapier
    • Dashboards
    • Row limit per export 100
    • Number of users unlimited
    • Advanced charting customization options
    • Number of datasources 1
    • Custom SQL
    • Audit reports
    • Enforce SSO
    • Live-feed results into Google sheets / Excel / Slack / Email / Zapier
    • Dashboards
    • Row limit per export 50,000
    • Number of users unlimited
    • Advanced charting customization options
    • Number of datasources 1
    • Custom SQL
    • Audit reports
    • Enforce SSO
    • Live-feed results into Google sheets / Excel / Slack / Email / Zapier
    • Dashboards
    • Row limit per export 500,000
    • Number of users unlimited
    • Advanced charting customization options
    • Number of datasources 1
    • Custom SQL
    • Audit reports
    • Enforce SSO
    • Live-feed results into Google sheets / Excel / Slack / Email / Zapier
    • Dashboards
    • Row limit per export 1,000,000
    • Number of users Unlimited
    • Advanced charting customization options
    • Number of datasources Unlimited
    • Custom SQL
    • Audit reports
    • Enforce SSO
Install Trevor.io for Postgres / MySQL
heroku addons:create trevor

To provision, copy the snippet into your CLI or use the install button above.

Trevor.io for Postgres / MySQL Documentation