Connect your data
Allowlist Querio IPs
Allow Querio to reach databases that are behind a firewall.
If your database blocks external connections, you may need to allowlist Querio's outbound IP address before the connection can work.
What to allow
Allow inbound traffic from Querio to the database port used by your datasource.
Common ports include:
| Datasource | Common port |
|---|---|
| PostgreSQL | 5432 |
| Redshift | 5439 |
| MySQL / MariaDB | 3306 |
| SQL Server | 1433 |
| ClickHouse | 9440 |
The exact IP address will be provided by the Querio team.
How to verify
After allowlisting the IP, return to Querio and test the datasource connection. If the test still fails, check:
- The hostname and port are correct
- The database accepts SSL if required
- The user has permission to connect
- The firewall rule targets the correct network or security group