Exporting RDS to S3
OfficialFreeSeamlessly export RDS snapshots to S3 in Parquet format.
Free · Opens the source repo
What Exporting RDS to S3 does
The Exporting RDS to S3 skill provides a comprehensive guide for exporting Amazon RDS and Aurora database snapshots directly to Amazon S3 in Apache Parquet format. This skill is particularly useful for developers and data engineers who need to prepare data for analytics, backups, or migration. It covers the entire workflow, including selecting or creating snapshots, setting up IAM roles, configuring KMS encryption, preparing S3 buckets, and executing export tasks.
This skill is designed to streamline the export process by offering detailed instructions for each step involved. Users will learn how to initiate exports, monitor their progress, and verify the integrity of the data once the export is complete. It is especially beneficial for those who intend to utilize the exported data with analytics services such as Amazon Athena, AWS Glue, or Redshift Spectrum, ensuring that the data is readily accessible for analysis and reporting.
In addition to the export process, the skill includes troubleshooting tips for common issues that may arise, such as database not found errors, IAM role permission issues, and export task failures. These insights can save users time and effort when addressing potential problems, making the skill a valuable resource for anyone working with AWS RDS and S3.
When to use it
Use this skill when you need to export RDS or Aurora database snapshots to S3 for analytics or backup purposes.
When not to use it
This skill is not suitable for exporting databases other than MySQL, PostgreSQL, MariaDB, Aurora MySQL, and Aurora PostgreSQL, and does not support Oracle or SQL Server.
What you can build with it
Data Analytics Preparation
Use this skill to export RDS snapshots for analysis in Amazon Athena or AWS Glue, enabling efficient data querying.
Backup Strategy Implementation
Implement a robust backup strategy by exporting RDS snapshots to S3, ensuring your data is securely stored and easily accessible.
Data Migration to Analytics Services
Facilitate data migration to services like Redshift Spectrum by exporting your RDS data in a compatible format.
How to install Exporting RDS to S3
View source1. Install with the skills CLI
npx skills add aws/agent-toolkit-for-aws/exporting-rds-to-s3 --agent claude-code2. Or install it manually
Download the skill folder and drop it into ~/.claude/skills/ for all projects, or .claude/skills/ to scope it to one repo. Restart Claude Code so it picks up the new skill.
Anthropic's agentic coding CLI, and the reference implementation of Agent Skills. Drop a skill folder into ~/.claude/skills and Claude Code loads it automatically whenever a task matches the skill's description. Claude Code docs
Inside SKILL.md
Written by awsExporting 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.
Frequently asked questions about Exporting RDS to S3
Similar skills
Single-Cell RNA-seq QC
Automate quality control for single-cell RNA-seq data.
Instrument Data to Allotrope Converter
Standardize lab data for seamless integration.
SQL Server Table Reconciliation
Efficiently compare SQL Server tables across instances.
Data Cleaning and Variable Screening
Streamline credit risk data preprocessing for modeling.
Arize Dataset
Manage and query Arize datasets efficiently.
Spreadsheet Management
Efficiently create, edit, and analyze spreadsheet files.