skilld
All skills
aws avatar

/exporting-rds-to-s3

@803cbf4
by Amazon Web Servicesaws/agent-toolkit-for-aws2.8k stars
337

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.

Ask your Agent

Use this Skill: https://skilld.dev/gh/aws/agent-toolkit-for-aws/exporting-rds-to-s3

This session only. Nothing lands on disk.

SKILL.md

≈101 tokens always: the name and description. ≈385 when used: this file. ≈15k more on demand in 1 file.

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.

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 for detailed troubleshooting.

Source: SKILL.md on GitHub

Third-party checks

No alerts16d3 checks · Risk SAFE
  • Gen Agent Trust Hub16d

    This skill provides a standard and comprehensive workflow for exporting Amazon RDS or Aurora database snapshots to Amazon S3 in Apache Parquet format. The configuration settings and instructions follow AWS security best practices, such as suggesting the use of .env files for secrets management and establishing proper IAM trust relationships with confused deputy protections. No security findings or potentially risky behaviors were identified.

  • Socket16d

    No alerts

  • Snyk16d

    Risk: LOW · No issues

Provenance

Signed by skilld at 803cbf4. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 5 months ago

Capability

version
1

README badge

README badge for aws/agent-toolkit-for-aws/exporting-rds-to-s3