Trevor

What Trevor is

Trevor, written Trevor.io on its own pages, is a self-serve business intelligence tool: a visual query builder, charts and dashboards that sit directly on your database. It is written for 2 readers at once. Operations, marketing and customer teams who do not know SQL get a way to answer their own questions. The engineers and analysts who used to field those requests get their time back, which is the point of the home page line "Free Up Your Engineers." The home page tells the story of Jeff in marketing who asks Rachel in engineering for a report, then comes back with 4 new questions while she loses a morning; Trevor is meant to remove that loop. The company also sells no-code embedded dashboards for product teams, a self-hosted version and an Enterprise tier. The footer says Trevor.io is registered in England as TMD Technology Limited, with an address in London.

What you build and how

The editor is the Query Builder, which the home page calls "simple, powerful" and "best-in-class", and which the company says lets people "answer ad hoc questions" without writing SQL. A blog post on the company's site describes it as drag-and-drop: users build queries visually, can drill down into the data without code, and can build pie charts, line graphs and other visualizations from the result. It is not SQL-only or SQL-free, because the same post says more tech-savvy users can write queries in SQL when they need to, and another post promises "a great SQL experience for analysts and engineers." A customer at Roofr puts the mix this way: it "allows you to both write SQL or use the platform's plug and play method when creating reports and pulling data." The navigation also lists a feature for mapping your database, which helps a newcomer find their way around the tables.

The data layer is your own database. The company says setup takes 5 minutes: Trevor "connects to your database directly (or via SSH) and works out of the box", without taking a copy of your data. The home page names Postgres, MySQL, Snowflake, Redshift, BigQuery, SQL Server and MariaDB, "And lots more." Data access is read-only, and the page says Trevor "uses a secure, read-only transaction. Your data cannot be altered in any way." That matters for a builder, since a non-technical user cannot write back to production by accident.

From a query you build charts and dashboards that you can share "with your team, your customers, your partners, and others." The comparison post on the company's site adds a data filter feature that lets a team look at combinations of datasets on one dashboard, and says reports can be sent to teammates by email. It says users can build queries on up-to-date data with "hourly live updates", customize dashboards to match the company's color scheme, add missing dates to charts and rename axes, then share them through public or private URLs.

Logic and automation are aimed at delivery. The home page lists "Alerts & workflows": live streaming of data to Google Sheets, data alerts, and a connection to Zapier, and says you can "Send live data to Google Sheets, Slack, email, or thousands of other apps, in just a few clicks." The resources menu has guides for sending data to Google Sheets, triggering alerts in Slack and connecting Trevor to Zapier, and a company blog post lists integrations with Slack, Google Sheets, Salesforce and Hubspot. A Goodtime data analyst describes the favorite part as the delivery options: sending data to internal and external stakeholders, "whether that's a live feed of results into a Google Sheet, or a daily CSV to Amazon S3." A developer at JGive says Trevor grew from a way for sales and marketing to read the data into "a full-fledged alerting and reporting service."

The embedded product is a separate offer, listed in the footer as "Embeddable (Our new tool!)". The home page describes "No-code embedded dashboards for your app" and says you can "embed beautiful, responsive dashboards into your app in minutes for your customers - no coding required!" This is where Trevor works as a customer-facing dashboard builder rather than an internal reporting tool.

Hosting comes in 2 forms. The navigation carries a Self-hosted page, and a company blog post says Trevor "offers both an on-premise and self-serve cloud version", with the self-hosted version quoted to your business needs. The same post says it is lightweight and never takes a copy of your database.

Collaboration is described in general terms. The home page says you can "collaborate with teammates," look up or drill into data, and build custom reports.

What the pages say about plans and limits

The home page says pricing "starts at $0 / month" and "scales with usage", alongside "low-cost implementation" and "top support all the way". Its sign-up box reads "Get started free" and includes all core features and unlimited users, with no credit card needed. One company blog post calls it "a generous free plan with no product limitations" and says "All versions offer unlimited users, dashboards and databases." Another says Trevor.io offers 3 pricing tiers, with Starter and Pro free to try, and invites readers to "Try it free for 2 weeks!" The pages give no prices for the paid tiers.

There is an Enterprise offer on the home page, "Get insights, at scale," with a note to contact the sales team.

On security and trust, the company states "GDPR compliant" and says "The security and privacy of your data is our first priority." The footer links customer terms, a privacy policy, a GDPR page and a DPA. The read-only transaction is the main technical safeguard it describes.

The home page says Trevor is trusted "From individuals and startups, to banks and public companies," and quotes customers from Scalapay, Hubble, GymFlow, Moteefe, Zen, Wedge, Aspireship, Op36Golf, Roofr, Goodtime, Curemint, Kindred, Vidsy and JGive. Steph, Chief of Staff at Kindred, calls it "the first tool I've seen that can help my non-technical peers jump into data without feeling like they need to learn how to code." Charlie at Hubble says "For our accounts team, Trevor is more important than Slack." Support gets repeated attention: the page promises "5-star support", and the CEO of GymFlow says help with building queries is "something few other brands offer."

Who it suits and who it does not

Trevor suits a startup or small company where analysts are the bottleneck and the data already sits in a SQL database or warehouse. A marketing, operations or customer success lead can build their own tracking, such as the OKR dashboards an Op36Golf customer describes, without queuing behind an engineer. A free entry with unlimited users lowers the cost of letting a whole team in. It also suits a SaaS team that wants customer-facing charts in its product without writing front-end code, and a company that wants the tool on its own servers.

It is a narrower tool than a full application builder. You do not build forms, branching workflows or apps here, and the automation described stops at alerts, Zapier, Slack and exports. A company blog post also notes that Trevor offers no dashboard templates and cannot pull data from Facebook ads or Google Analytics directly, so it is a database tool first.