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.
Build workflows
Live stream results to Google Sheets
In just a couple of clicks, you can send live data directly to Google Sheets and have it update automatically every hour.
Send customer data to [app]
Need to send customer data to Salesforce? Via our Zapier integration, you can send data to hundreds of apps, including Salesforce, Intercom, Airtable & more.
Get data alerts in Slack
Stay on top of your business by triggering custom Slack messages when things you're interested in happen (e.g. a large order is placed).
Send results via email
Have query results automatically sent to you, teammates, or investors, at regular intervals.
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
4.png)
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.
