exporting-rds-to-s3 — Claude Code skill: RDS snapshots to S3
Walks the agent through exporting an RDS or Aurora snapshot to S3 as Parquet, from IAM roles and KMS encryption to task monitoring and data checks.
npx skills add aws/agent-toolkit-for-aws --skill exporting-rds-to-s3 -a claude-codeWhat exporting-rds-to-s3 does
The skill covers the whole path from picking or creating a database snapshot to files landing in your bucket. It points the agent at references/export-rds-to-s3.md for the export procedure, which is what you want when the data is headed for Athena, Glue or Redshift Spectrum.
Snapshot export works for MySQL, PostgreSQL, MariaDB, Aurora MySQL and Aurora PostgreSQL. Oracle and SQL Server are not supported, so check the engine before planning a migration. For Aurora, diagnostics use describe-db-clusters rather than describe-db-instances — an easy mistake to make.
The IAM role has to trust export.rds.amazonaws.com with aws:SourceAccount and aws:SourceArn conditions, and carry S3 PutObject plus KMS permissions. Wait 10–15 seconds after creating the role or the call fails on permissions. When a task stalls, the skill lists the usual culprits: a deleted bucket, a modified role, a disabled KMS key.
What it helps with
- export an RDS snapshot to S3 as Parquet
- set up the IAM role the RDS export service needs
- turn on KMS encryption for exported data
- diagnose a stuck or failed export task
- prepare S3 data for Athena, Glue or Redshift Spectrum
Example prompts for the agent
- export my RDS snapshot to S3 in Parquet
- set up an Aurora PostgreSQL export to my analytics bucket
- the RDS export task is stuck — check the failure reasons
How to install exporting-rds-to-s3
1Skills CLI (Vercel)
npx skills add aws/agent-toolkit-for-aws --skill exporting-rds-to-s3 -a claude-code2Manually: put the files in place
~/.claude/skills/exporting-rds-to-s3/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/exporting-rds-to-s3/
1Skills CLI (Vercel)
npx skills add aws/agent-toolkit-for-aws --skill exporting-rds-to-s3 -a codex2Manually: put the files in place
.agents/skills/exporting-rds-to-s3/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add aws/agent-toolkit-for-aws --skill exporting-rds-to-s3 -a cursor2Manually: put the files in place
.cursor/skills/exporting-rds-to-s3/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install aws/agent-toolkit-for-aws exporting-rds-to-s32Manually: put the files in place
.github/skills/exporting-rds-to-s3/SKILL.md1Skills CLI (Vercel)
npx skills add aws/agent-toolkit-for-aws --skill exporting-rds-to-s3 -a gemini-cli2Platform CLI
gemini skills install https://github.com/aws/agent-toolkit-for-aws --path skills/specialized-skills/database-skills/exporting-rds-to-s3Manually: put the files in place
.devin/skills/exporting-rds-to-s3/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add aws/agent-toolkit-for-aws --skill exporting-rds-to-s3 -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about exporting-rds-to-s3
How do I install exporting-rds-to-s3 in Claude?
Run npx skills add aws/agent-toolkit-for-aws --skill exporting-rds-to-s3 -a claude-code. The skill file then lives at ~/.claude/skills/exporting-rds-to-s3/SKILL.md.
What does exporting-rds-to-s3 do?
It guides the agent through exporting an RDS or Aurora snapshot to S3 in Apache Parquet: snapshot selection, IAM role and KMS setup, bucket preparation, task execution, progress monitoring and data verification.
Which database engines can be exported?
MySQL, PostgreSQL, MariaDB, Aurora MySQL and Aurora PostgreSQL only. Oracle and SQL Server are not supported.
Source text
SKILL.md · Apache-2.0
--- 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.
© aws · Apache-2.0 · aws/agent-toolkit-for-aws
