Connecting to Trevor.io
Securely connect your database to Trevor.io.
🥷🏻 Connecting to AWS (Amazon Web Services)
Connecting to Postgres on AWS (Amazon Web Services)
To connect Trevor.io to your Postgres database, login to Trevor and head to the connect Postgres screen. You'll need to enter the followi...
Connecting to MySQL on AWS (Amazon Web Services)
To connect Trevor.io to your MySQL database, login to Trevor and head to the connect MySQL screen. You'll need to enter the following fie...
🥷🏻 Connecting to GCP (Google Cloud Platform)
Connecting to BigQuery on GCP (Google Cloud Platform)
To connect Trevor.io to your Postgres database, login to Trevor and head to the connect BigQuery screen. You'll need to enter the followi...
🥷🏻 Connecting to Microsoft Azure
Connecting to SQL Server on Microsoft Azure
To connect Trevor.io to your Azure SQL database you simply need to: identify the Hostname and the Database name whitelist Trevor.io's St...
🥷 Connecting your database
Databases we support
You can connect the following databases to Trevor.io: Postgres MySQL MariaDB SQL Server Redshift Snowflake BigQuery Learn what you need...
How to connect
You can connect your database directly or using SSH (e.g. via a Bastion Host). Connecting directly To connect your database directly, yo...
Connecting Trevor.io to your localhost database
To connect Trevor.io to a database running on your local computer you simply need to map your local database port to an online URL (as Tr...
Whitelisting IPs on AWS (Amazon Web Services)
8. Click on the “Security Group” attached to your database. 9. Scroll down to “Inbound rules” and add Trevor’s IP by clicking “Edit in...
Finding your database's host and port on AWS (Amazon Web Services) RDS
1. Login to your “AWS” account and select the region in which your database is located. 2. Type in “RDS” in the search box. Click on the...
Creating a read-only database user in Postgres
We typically recommend that you create a read-only trevor database user that Trevor can connect as. You can do this easily by running th...
Checking regions match 1. Are our IPs whitelisted? 2. Have you been able to test the connection and is it working? 3. Check your region ...
🙋♂️ Common questions
Connect Airtable to Trevor
You can use tools like Airbyte to bring Airtable into an SQL database:Airbyte ConnectionsTrevor can then easily connect to your SQL datab...
Does Trevor.io detect the joins in my database? Yes! When you connect your database to Trevor.io, we automatically derive the relationshi...
Manually configure joins
When you connect your database to Trevor.io, we automatically detect the relationships between your tables. If a join is missing, you ca...
Data in Trevor
Does Trevor.io store a copy of my database? 💪 No! Trevor does not store a copy of your database. 🔐 Your data stays safely and securely i...