Trevor.io Data Playground

Postgres / MySQL querying interface your whole team can use Starting at $0/mo.

Read-only data playground

Trevor 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 *without* SQL

Trevor 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 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 is trusted by companies around the globe:

  • Everyone at Team Lexoo has used Trevor 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 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
Virginia Available
Oregon Available
Frankfurt Available
Tokyo Available
Sydney Available
Dublin Available

Plans & Pricing

    • Live-stream results into Google sheets / Excel
    • Query timeout 2 minutes
    • Row limit per export 100
    • Number of users unlimited
    • Dashboards
    • Number of datasources 1
    • Advanced queries
    • Custom SQL
    • Live-stream results into Google sheets / Excel
    • Query timeout 2 minutes
    • Row limit per export 50,000
    • Number of users unlimited
    • Dashboards
    • Number of datasources 1
    • Advanced queries
    • Custom SQL
    • Live-stream results into Google sheets / Excel
    • Query timeout 20 minutes
    • Row limit per export 250,000
    • Number of users unlimited
    • Dashboards
    • Number of datasources 1
    • Advanced queries
    • Custom SQL
    • Live-stream results into Google sheets / Excel
    • Query timeout 2 minutes
    • Row limit per export 50,000
    • Number of users unlimited
    • Dashboards
    • Number of datasources 1
    • Advanced queries
    • Custom SQL
    • Live-stream results into Google sheets / Excel
    • Query timeout 20 minutes
    • Row limit per export 250,000
    • Number of users unlimited
    • Dashboards
    • Number of datasources 1
    • Advanced queries
    • Custom SQL
Install Trevor.io Data Playground
heroku addons:create trevor

To provision, copy the snippet into CLI or login to provision on Elements.

Trevor.io Data Playground Documentation