Connecting to Amazon RDS from Skyvia

Connecting to Amazon RDS from Skyvia

Skyvia supports Amazon RDS databases. You can connect MySQL, PostgreSQL, or SQL Server hosted on Amazon RDS. To do so, click + Create New -> Connection -> Database, and then select the required database type. Below is useful information on how to configure your Amazon RDS database to allow connections from Skyvia:

  1. Open the Security Group associated with your server (you can access it directly from the server by clicking on it).
  2. In the necessary Security Group, click Actions and select Edit inbound rules.
  3. Click Add Rule in the rules editor.
  4. Select the required database type from the Type dropdown (for example, MySQL). The Protocol and Port will be automatically assigned.
  5. In the Source field, add the following IP addresses:
    40.118.246.204/32
    13.86.253.112/32
    52.190.252.0/32
  6. Save the changes and test the connection again.
For network requirements and the list of Skyvia IP addresses that must be allowed, see How to Configure Local Database Server to Access It from Skyvia.

For further reference, please refer to the following links:
Amazon VPC User Guide - general information about security groups and inbound rules
Create Security group inbound for the RDS - example of configuring inbound rules for Amazon RDS




    • Related Articles

    • ❗Issue connecting to Looker Studio

      If you are experiencing issues with connecting to Looker Studio or finding Skyvia in the list of available connectors, please note that our team is aware of this issue and is actively working on a resolution. In the meantime, you can access the ...

    • Skyvia Query: Easily Verify Data in Your Connection!

      Please follow the steps below to query your data in Skyvia Query: Log in to Skyvia and navigate to + Create New → Query. Select an existing connection or establish a new one for your data source. Choose the desired table or object from the Connection ...

    • Skyvia Query: You have reached the limit of queries

      If you encounter the message "You have reached the limit of queries," it indicates that you have exceeded the maximum number of queries allowed for your Free plan on Skyvia Query. The Free Query plan is designed for basic testing purposes and allows ...

    • Understanding Records in Skyvia Data Integration

      1.1 Understanding Records in Skyvia Data Integration A record in Data Integration represents a single row in a database table. Every integration process (Import, Replication, Export, Synchronization, etc.) handles individual records. Records also ...

    • 🔁 Skyvia Full (Initial) Replication

      Full Replication creates a complete copy of your source data in the target database. Use it for the first replication run, after schema changes, when refreshing all data, or if you encounter duplicate records. Requirements Valid Source and Target ...