Connecting to Trevor.io

• 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 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 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...

• 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...

See all 9 articles

• Troubleshooting BigQuery

  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 ...

• 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...

• Detecting joins

  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...