exporting-rds-to-s3

Exports RDS and Aurora snapshots to S3 in Apache Parquet format.

Updated Jul 21, 2026
Ready to run
npx skills add https://github.com/richardnroman/Synthetic-Data-Exchange-Licensing-Platform --skill exporting-rds-to-s3-richardnroman
💬 Prompt for ChatGPT / Claude Chat▼
Please help me install this Agent Skill.
Skill: exporting-rds-to-s3
Source: https://github.com/richardnroman/Synthetic-Data-Exchange-Licensing-Platform/tree/main/.agents/skills/exporting-rds-to-s3
Command: npx skills add https://github.com/richardnroman/Synthetic-Data-Exchange-Licensing-Platform --skill exporting-rds-to-s3-richardnroman

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Moving data out of Amazon RDS or Aurora for analytics, backup archival, or migration normally requires manual snapshot handling, IAM role configuration, KMS encryption setup, and export monitoring. This Skill automates the entire snapshot-to-S3 export workflow so the data lands in S3 as analytics-ready Apache Parquet files. ## Core Features & Use Cases - End-to-End Export Workflow: Identifies or creates snapshots, prepares S3 buckets, configures IAM roles with confused deputy protection, sets up KMS encryption, and starts the export task. - Progress Monitoring & Verification: Polls export task status, handles failures with actionable troubleshooting, and verifies the exported Parquet files in S3 including size and compression ratios. - Analytics Access Guidance: Provides ready-to-use instructions for querying exported data with Amazon Athena, AWS Glue crawlers, Redshift Spectrum, or local tools like pandas and Spark. - Use Case: Export a production Aurora PostgreSQL cluster snapshot to S3, then create an Athena external table over the Parquet files to run analytics queries without touching the live database. ## Quick Start Ask the assistant to export your RDS or Aurora database to S3 by providing the database identifier, AWS region, and target S3 bucket name.

Frequently Asked Questions about exporting-rds-to-s3

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I export an RDS snapshot to S3?▼

Use the aws rds start-export-task command with the snapshot ARN, target S3 bucket, IAM role, and optional KMS key. The data is exported in Apache Parquet format, and you can monitor progress with describe-export-tasks until the status is complete.

Which database engines support RDS snapshot export to S3?▼

Snapshot export to S3 supports MySQL, PostgreSQL, MariaDB, Aurora MySQL, and Aurora PostgreSQL. Oracle and SQL Server are not supported, so those databases require alternative export approaches such as native dump tools.

Can I export only specific tables from an RDS snapshot?▼

Yes, pass a comma-separated list of tables via the export-only parameter using schema.table format, such as public.users for PostgreSQL. Table names are not validated until the export starts, so incorrect names will cause the task to fail.

Why does my RDS export task fail with IAM permission errors?▼

The IAM role must trust the export.rds.amazonaws.com service principal with aws:SourceAccount and aws:SourceArn conditions, and must have S3 PutObject and KMS permissions. Also wait 10-15 seconds after role creation for IAM propagation before starting the export.

How do I query exported RDS data in S3 with Athena?▼

Create an external table in Athena with STORED AS PARQUET pointing to the S3 export path, then query it with standard SQL. Alternatively, run an AWS Glue crawler over the export path to automatically discover the schema into the Data Catalog.