Trevor does not store a copy of your database. We send SQL over the wire and retrieve only the returned results. Your data stays safely and securely in your database.
All SQL / results are transmitted using SSL security, and all connections use a read-only transaction (Trevor cannot, and will not, write to your database or update / alter it in any way).
Connect your database to Trevor by entering your database (or SSH) credentials. These are kept strictly private and are securely encrypted using industry standard 128-bit AES Encryption. We provide a static IP for whitelisting.
When you export query results from Trevor, the results are temporarily cached to improve performance and protect your database from too much traffic. These results are cached (using a version 4 cryptographically strong pseudo random UUID) for 24 hours, before being automatically and permanently deleted.
Work safely with others
Only team members you specifically invite can view your data in Trevor. They cannot view your credentials or invite other users (unless you explicitly make them an administrator). You can revoke access at any time.
Invited team members authenticate using their Google or company email accounts. We do not store your passwords. Authentication is done using BCrypt hashing.
You can set table / column level permissions for your company, specific teams, or specific individuals (row-level permissions are also possible).
You can control query limits for your team, including row export limits and query timeouts.
If you fall into the majority category of people who want to access and manipulate their company data but don't know SQL, don't rush to learn it, just use Trevor. The pros: there's a way to do just about everything you want! The cons: there doesn't appear to be anyone there actually named Trevor...
We got Trevor set up in lightning speed. The instant insight into our data and ease and flexibility of querying means more fact and less guesswork in decision making for everyone from the product team to our customer success managers. The support has also been second to none - would strongly recommend it!