Empower everyone on your team to answer ad hoc data questions, quickly and intuitively. There's no better Query Builder out there.
We're really proud of the live support we provide, which is available on every plan and even includes guidance on building queries.
Trevor.io automatically derives your database's table relationships, making it really easy to perform joins and explore connected data.
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.
If you prefer SQL, you can write that too. You, or teammates, can even dig into the results using the query builder.
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.
Have data in spreadsheets? Upload them to Trevor.io and slice and dice them using all of Trevor.io's 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.
Want to see the underlying SQL that's been generated by our Query Builder? No problem! Access and check this at any time.
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.
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 your dashboards with just the right people via public or private URLs, embed them in other tools, and more.
Add filters to your dashboards so your team can easily look at different combinations of data segments from the same dashboard.
Have a snapshot of your dashboard automatically sent to you, teammates, or investors, at regular intervals via Slack or email.
In just a couple of clicks, you can send live data directly to Google Sheets and have it update automatically every hour.
Need to send customer data to Salesforce? Via our Zapier integration, you can send data to hundreds of apps, including Salesforce, Intercom, Airtable & more.
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).
Have query results automatically sent to you, teammates, or investors, at regular intervals.
Trevor automatically generates an interactive diagram of your database so you can understand the relationships that exist and explore the data.
Easily search for tables or fiels in your database - Trevor will return and highlight the most relevant results for you.
Tables, columns and joins are detected automatically. Add and remove tables from your diagram at the click of a button.
As your schema changes, the relationships in your diagram automatically update without any work on your side.
Connect your database to Trevor by entering your SSH or database credentials. These are kept stricly private and are securely encrypted.
Trevor does not store a copy of your database. SQL is sent over the wire and only the returned results are retrieved (and transmitted using SSL security).
All connections to your database use a read-only transaction. Trevor will never write to your database or update / alter your data in any way.
Your team admins can get access to detailed reports containing the actions each team members has performed and data they have accessed.
It is common to create a database user with specific permissions for use with Trevor. You can also set table / column level permissions via Trevor's interface.
SQL / results are transmitted using SSL security, which protects against eavesdropping and man-in-the-middle attacks.
We have multiple features in place to speed up building queries and protect your database, including rate-limiting and temporary caching of results.
You can learn more about data security, privacy, and GDPR, as well as our general terms and customer agreements, here.