# exporting-rds-to-s3

Exports RDS or Aurora snapshots to S3 as Parquet files for Athena, Glue or Redshift Spectrum, including IAM role, KMS encryption and verification.

Skill by Amazon Web Services. Category: Data and backend.

## Install

Project (for this project only):

```sh
npx skills add aws/agent-toolkit-for-aws --skill exporting-rds-to-s3
```

Works with: Claude Code, Codex CLI, Cursor, Antigravity, Copilot CLI, opencode.

Global (for every project on this machine):

```sh
npx skills add aws/agent-toolkit-for-aws --skill exporting-rds-to-s3 -g
```

Works with: Claude Code, Codex CLI, Cursor, Antigravity, Copilot CLI, opencode.

## Tags

- Runs on your computer: It runs as a program on your machine, with your access.

## Security audits

- Gen Agent Trust Hub: Pass
- Socket: Pass
- Snyk: Pass

Installs: 5548. Installs counted by skills.sh. [Open on skills.sh](https://www.skills.sh/aws/agent-toolkit-for-aws/exporting-rds-to-s3)

## Source

[Open the source](https://github.com/aws/agent-toolkit-for-aws/tree/HEAD/skills/specialized-skills/database-skills/exporting-rds-to-s3). Checked 2026-10-10. This summary may contain AI-generated text, so it can be wrong. Check the source before you rely on it.

## SKILL.md

````markdown
---
name: exporting-rds-to-s3
description: Exports Amazon RDS or Aurora database snapshots to Amazon S3 in Apache Parquet format for analytics, backup, or data migration. Handles snapshot selection or creation, IAM role setup, KMS encryption, S3 bucket preparation, export task execution, progress monitoring, and data verification. Use when exporting RDS/Aurora data to S3 for Athena, Glue, or Redshift Spectrum consumption.
version: 1
---
# Exporting RDS/Aurora to S3

## Overview

Domain expertise for exporting Amazon RDS and Aurora database snapshots to Amazon S3
in Apache Parquet format. Covers the full workflow: snapshot identification or creation,
IAM role and KMS encryption setup, S3 bucket preparation, export task initiation,
progress monitoring, data verification, and post-export access guidance for analytics
services like Athena, Glue, and Redshift Spectrum.

## Export an RDS or Aurora snapshot to S3

To export a database snapshot to S3 with proper IAM roles, encryption, and monitoring,
follow the procedure exactly.
See [RDS to S3 export procedure](references/export-rds-to-s3.md).

## Troubleshooting

### Database not found
Verify the database identifier spelling, case, and region. For Aurora, use `describe-db-clusters` instead of `describe-db-instances`.

### Export not supported
Snapshot export supports MySQL, PostgreSQL, MariaDB, Aurora MySQL, and Aurora PostgreSQL only. Oracle and SQL Server are not supported.

### IAM role permission errors
Ensure the role trust policy allows `export.rds.amazonaws.com` with `aws:SourceAccount` and `aws:SourceArn` conditions for confused deputy protection, and has S3 PutObject and KMS permissions. Wait 10–15 seconds after role creation for propagation.

### Export stuck or failed
Check the export task status for failure reasons. Common causes: S3 bucket deleted, IAM role modified, or KMS key disabled during export. See the [full procedure](references/export-rds-to-s3.md) for detailed troubleshooting.
````

- Previous: [connecting-vpcs-with-peering](https://syn4pse.dev/terminal/connecting-vpcs-with-peering.md)
- Next: [setting-up-cloudtrail-multi-region](https://syn4pse.dev/terminal/setting-up-cloudtrail-multi-region.md)
- [Terminal](https://syn4pse.dev/terminal.md)
- [Suggest a change](mailto:terminal@syn4pse.dev?subject=Terminal%20suggestion)
