Trevor.io
No-code BI that queries your live database directly, no data copying.
About
Trevor.io is a UK business intelligence tool founded in 2016 that connects to your SQL database and lets non-technical users ask ad-hoc questions through a no-code query builder, with full SQL available for advanced users. It deliberately does not copy your data or write to your database: it runs secure read-only queries against the live source, with 128-bit AES encryption and row/column-level permissions.
Pricing is published and transparent: a free cloud tier, usage-based plans starting at $75/month, and a self-hosted enterprise option from $500/month with SSO and audit logs. The vendor claims it works with raw data without transformation and is dbt-compatible. Third-party comparisons put it against Power BI, Looker, Metabase, and Superset as the simpler, cheaper option for startups. I have not hands-on tested the query builder, so the no-code ease-of-use claims are provider-stated.
What it can do
- No-code query builder
- Raw SQL editor
- Live connection to your database (no data copied)
- Dashboards and drill-downs
- Alerts and scheduled reports via email, Slack, Google Sheets
- Embedded dashboards
- AES encryption, row/column-level permissions, audit trail
- dbt compatibility (per vendor)
Setup
- Sign up for the free cloud plan at trevor.io.
- Connect your SQL database with read-only credentials (about 20 minutes per the vendor).
- Build queries with the no-code builder or write SQL.
- Create dashboards, set alerts, and share or embed results.
Prerequisites
A SQL database with read-only credentials.
Use cases
Works with
Trust score — 7/10
Scored 7/10 (TIER metrics, metrics-v1). Evidence: founded 2016 (UK), still publishing active content in 2026 (trevor.io blog crawled within a day); transparent pricing (free tier, $75/mo usage-based, $500/mo enterprise); read-only architecture and encryption claims consistent across its own comparisons. Strengths: 10-year track record, published pricing, no-data-copy security model. Docked for: (1) modest public footprint and few independent reviews I could verify; (2) ease-of-use and performance claims are provider-stated, untested. License: proprietary.
How the trust score is built
Full methodology →- Adoption · stars/downloads, log-scaled vs peers
- 5.0/10
- Maintenance · recency, releases, issue load
- 7.0/10
- Openness · license + docs
- 9.0/10
- Manual review · sanity read + red-flag check
- 6.0/10
- · Founded 2016, UK (Slashdot vendor data)
- · trevor.io site verified live; blog content crawled within a day
- · Transparent pricing: free cloud tier, $75/mo usage-based, $500/mo self-hosted enterprise
- · Read-only architecture, AES encryption, row/column permissions claimed consistently
Sources
Every fact above was checked against these sources. Where a claim comes from the provider and couldn't be independently verified, the text says so.