---
title: Write to Amazon RDS
description: Use sql.to() to write data to a relational database hosted on Amazon RDS.
url: https://docs.influxdata.com/flux/v0/write-data/sql/amazon-rds/
estimated_tokens: 495
product: Flux
version: v0
publisher: InfluxData
canonical: https://docs.influxdata.com/flux/v0/write-data/sql/amazon-rds/
date: '2023-09-12T23:33:31-06:00'
lastmod: '2023-09-12T23:33:31-06:00'
---

To write data to a relational database hosted on [Amazon Relational Database Service (RDS)](https://aws.amazon.com/rds/)with Flux:

1. Import the [`sql` package](/flux/v0/stdlib/sql/)

2. Pipe-forward data into [`sql.to()`](/flux/v0/stdlib/sql/to/) and provide the
   following parameters:

   * **driverName**: *Determined by your [Amazon RDS database engine](#supported-database-engines)*
   * **dataSourceName**: *Determined by your [Amazon RDS database engine](#supported-database-engines)*
   * **table**: Table to write to
   * **batchSize**: Number of parameters or columns that can be queued within
     each call to `Exec` (default is `10000`)

##### Write to an Amazon RDS PostgreSQL database

```js
import "sql"

data
    |> sql.to(
        driverName: "postgres",
        dataSourceName: "postgresql://my-instance.123456789012.us-east-1.rds.amazonaws.com:5432",
        table: "example_table",
    )
```

## Supported database engines

Use the following guides to query supported Amazon RDS database engines:

* [Write to MariaDB](/flux/v0/write-data/sql/mariadb/)
* [Write to MySQL](/flux/v0/write-data/sql/mysql/)
* [Write to PostgreSQL](/flux/v0/write-data/sql/postgresql/)
* [Write to SQL Server](/flux/v0/write-data/sql/sql-server/)

## Amazon RDS connection credentials

Amazon RDS provides connection credentials required to connect to your database instance.
The following links provide more information for each database engine:

* [Connect to MariaDB](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToMariaDBInstance.html)
* [Connect to MySQL](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToInstance.html)
* [Connect to PostgreSQL](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.html)
* [Connect to SQL Server](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToMicrosoftSQLServerInstance.html)

#### Related

* [sql.to() function](/flux/v0/stdlib/sql/to/)