🥷 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...
-
Creating a read-only database user in MySQL
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...
-
Creating a read-only database user in SQL Server
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...
-
Creating a read-only database user in Snowflake
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...