Feature overview

From building queries and dashboards to setting up data alerts, workflows, integrations and more, Trevor is a tool your team will love.

Answer data questions

Build queries, visually

Empower everyone on your team to answer ad hoc data questions, quickly and intuitively. There's no better Query Builder out there.

Get incredible support

We're really proud of the live support we provide, which is available on every plan and even includes guidance on building queries.

Join connected data

Trevor.io automatically derives your database's table relationships, making it really easy to perform joins and explore connected data.

Everything works out of the box

All of Trevor.io's functionality is available immediately, out of the box. There's no complex set up, so you can be up and running within minutes.

Write SQL

If you prefer SQL, you can write that too. You, or teammates, can even dig into the results using the query builder.

Share live results

There are multiple secure ways to share results, from simple URLs and public charts, to email and Slack messages, to Google Sheets live-streams, and more.

Upload CSVs

Have data in spreadsheets? Upload them to Trevor.io and slice and dice them using all of Trevor.io's functionality.

Advanced functionality

It's a breeze to query JSON data, create custom query columns (like in Excel or Google Sheets), perform complex aggregations, and so much more.

Access the generated SQL

Want to see the underlying SQL that's been generated by our Query Builder? No problem! Access and check this at any time.

Share beautiful dashboards

Create unlimited dashboards

You can build as many dashboards as you like and display a wide range of different chart types, from multi-line charts to donut-pies.

Customize the details

There are a huge number of ways to customize your charts, from renaming axes, to including missing dates, to using your company color scheme.

Share and embed dashboards

Share your dashboards with just the right people via public or private URLs, embed them in other tools, and more.

Filter the data

Add filters to your dashboards so your team can easily look at different combinations of data segments from the same dashboard.

Schedule snapshots via Slack

Have a snapshot of your dashboard automatically sent to you, teammates, or investors, at regular intervals via Slack or email.

Map your database

Visualize relationships

Trevor automatically generates an interactive diagram of your database so you can understand the relationships that exist and explore the data.

Search tables / columns

Easily search for tables or fiels in your database - Trevor will return and highlight the most relevant results for you.

Lightning fast to set up

Tables, columns and joins are detected automatically. Add and remove tables from your diagram at the click of a button.

Always up-to-date

As your schema changes, the relationships in your diagram automatically update without any work on your side.