Connect Amazon RDS to Skyvia - MySQL, PostgreSQL, SQL Server

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 IPs for Whitelist

      Overview Skyvia is a cloud-based platform that connects to your data sources and targets over the internet. If your database, server, or cloud service restricts inbound connections by IP address (e.g., via firewall rules, security groups, or ...

    • AADSTS650052 Error When Connecting to Dynamics 365 Business Central

      When connecting to Microsoft Dynamics 365 Business Central, the following error may occur: "AADSTS650052: The app is trying to access a service '00000015-0000-0000-c000-000000000000'(Microsoft Dynamics ERP) that your organization '***' lacks a ...

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