AutoGineer
Generated banner for Exporting Rds To S3
Generated logo for Exporting Rds To S3

Exporting Rds To S3

AWSOfficialPublished by AWS

  • Skill
  • Workflow
  • Cloud and DevOps
  • Apache-2.0
  • No issues found
Download ZIP

From the author

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.
— the description by AWS

AutoGineer summary

Written by AutoGineer from the skill’s own files, not by the author

This skill provides a structured procedure for exporting Amazon RDS and Aurora database snapshots to Amazon S3. It manages the end-to-end process, including snapshot identification or creation, IAM role configuration, KMS encryption setup, S3 bucket preparation, and the execution of the export task. Designed for data engineers and cloud administrators, it ensures that data is correctly formatted in Apache Parquet, making it immediately ready for consumption by analytics services like Amazon Athena, AWS Glue, and Amazon Redshift Spectrum.

What it does

  • Identifies and validates RDS instances or Aurora clusters for export.
  • Handles the creation of new snapshots or selection of existing ones.
  • Configures necessary IAM roles and KMS encryption for secure data transfer.
  • Executes the export task to S3 in Apache Parquet format.
  • Monitors export progress and provides verification of the completed task.
  • Offers troubleshooting guidance for common permission, engine, and configuration errors.

When to use it

  • When you need to migrate database data to S3 for long-term storage or archival.
  • When preparing database data for analytics using Athena, Glue, or Redshift Spectrum.
  • When you require a repeatable, automated process for snapshot exports.
  • When you need to ensure exported data is encrypted and stored with proper IAM controls.

Advantages

  • Standardizes the export process to reduce manual configuration errors.
  • Ensures compatibility with major AWS analytics services through Parquet formatting.
  • Includes built-in validation for engine support and database status.
  • Provides clear troubleshooting steps for common AWS infrastructure issues.

Usage examples

“Export my production-mysql database to the rds-exports bucket.”
The agent will prompt for the required region, verify the database status, configure the necessary IAM and KMS settings, and initiate the export task.
“I need to move my Aurora cluster data to S3 for Athena analysis.”
The agent will identify the cluster, confirm engine support, and guide you through the snapshot export workflow to ensure the data is in the correct Parquet format.

Install

  1. Download the skill as a ZIP:

    https://mp-staging.autogineer.com/agent-skills/aws/exporting-rds-to-s3/download

  2. Unzip it into the cross-client skills folder of your project:

    mkdir -p .agents/skills && unzip exporting-rds-to-s3.zip -d .agents/skills

Documentation by AWS

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.

Files

NOTICE

Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved.

Requirements and compatibility

Works with: Claude Code, Claude apps, OpenAI Codex, GitHub Copilot, Cursor, Gemini CLI, Kiro, OpenCode, Goose, Amp, Roo Code, JetBrains Junie, Factory Droid, Devin (ex-Windsurf), Mistral Vibe, OpenHands, Letta

“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.

Security

No issues found by our static scan· No issues found

A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.

Attribution and licence

Published by
AWS
Publisher
AWS (Official)
Source
aws/agent-toolkit-for-aws · skills/specialized-skills/database-skills/exporting-rds-to-s3 · commit 0a218f8
Licence
Apache License 2.0 (redistribution allowed)
  • LICENSE (added by AutoGineer from LICENSE)
  • NOTICE (added by AutoGineer from NOTICE)
  • ATTRIBUTION.md (written by AutoGineer)
Synced

AutoGineer is not affiliated with or endorsed by AWS.

Download ZIP

The ZIP holds the skill’s files, its licence files and an ATTRIBUTION.md. Download exporting-rds-to-s3.zip