Trevor.io

SQL-based BI tool letting non-technical users query databases and build dashboards without code.

📍 United Kingdom 🇬🇧, London

Product overview

Trevor.io is a SQL-based BI tool headquartered in London that lets non-technical users query databases and build dashboards without writing code. The platform provides a visual query builder that generates SQL under the hood, allowing marketing, operations, and product teams to pull data from PostgreSQL, MySQL, Snowflake, Redshift, and SQL Server databases without involving engineering teams. Users build queries through a point-and-click interface, then visualize results as charts and tables that can be assembled into dashboards. Trevor.io also includes a full SQL editor for technical users, scheduled alerts, live data feeds to Google Sheets, and Slack integration for sharing results. The platform supports embedded dashboards, enabling companies to offer customer-facing analytics within their own products. Founded in 2016 by Tom Gardiner and Harry Marshall, Trevor.io is backed by OpenOcean (Helsinki) and has raised approximately $10.7 million. The company serves startups, banks, and public companies, with customers including Lexoo, Tribe, and Honeypot. The team is small (about 11 employees) and London-based. Pricing operates on a credit system: a permanent free plan includes 3,000 credits per month (roughly 1,000 ad-hoc queries), and the Pro plan starts at $75 per month with additional usage-based charges. KEY FEATURES: - Visual query builder that generates SQL without requiring coding - Connections to PostgreSQL, MySQL, Snowflake, Redshift, and SQL Server - Embedded dashboards for customer-facing analytics - Scheduled alerts and live data feeds to Google Sheets - Credit-based pricing with a permanent free tier