opensite-ai/opensite-skills / aws-database
aws-database
VerifiedRoutes any task involving AWS databases — choosing, comparing, recommending, getting started with, or operating a database — to the correct service-specific skill. Supersedes general training-data knowledge with post-training service updates, corrected limitations, and decision procedures for relational (Aurora, DSQL, RDS), key-value (DynamoDB), wide-column (Keyspaces), document (DocumentDB), graph (Neptune), time-series (Timestream), and in-memory/caching (ElastiCache, MemoryDB) workloads. Activates when a user describes building an application on AWS that will store, retrieve, or manage data, even if they do not mention 'database' explicitly.
| File | Kind | Size |
|---|---|---|
| .aws-skill-metadata | other | 18 B |
| SKILL.md | skill md | 7.8 KB |
| assets/aurora-dsql.md | markdown | 1.4 KB |
| assets/aurora-mysql.md | markdown | 1.9 KB |
| assets/aurora-postgresql.md | markdown | 2.5 KB |
| assets/documentdb.md | markdown | 1.4 KB |
| assets/dynamodb.md | markdown | 2.9 KB |
| assets/elasticache.md | markdown | 3.4 KB |
| assets/keyspaces.md | markdown | 2.0 KB |
| assets/memorydb.md | markdown | 1.7 KB |
| assets/neptune.md | markdown | 2.1 KB |
| assets/odb-aws.md | markdown | 1.9 KB |
| assets/rds-db2.md | markdown | 1.1 KB |
| assets/rds-mariadb.md | markdown | 1.5 KB |
| assets/rds-mysql.md | markdown | 1.2 KB |
| assets/rds-oracle.md | markdown | 1.5 KB |
| assets/rds-postgresql.md | markdown | 1.4 KB |
| assets/rds-sqlserver.md | markdown | 1.3 KB |
| assets/timestream.md | markdown | 1.8 KB |
| references/handoff.md | markdown | 4.1 KB |
| references/report-issue.md | markdown | 3.9 KB |
| references/select.md | markdown | 19.5 KB |
assets/aurora-mysql.md
View on GitHub# Aurora MySQL
- **Docs**: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraMySQL.html
- **Docs (llms.txt)**: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/llms.txt
- **Data model**: Relational (full MySQL)
- **Query language**: MySQL SQL
- **Compatibility**: Full MySQL
- **Serverless**: Yes
- **Serverless type**: Capacity — you create and manage a cluster, while compute scales automatically within the supported capacity range (currently up to 256 ACUs on supported engine and platform versions). Patching, upgrades, and maintenance remain a shared responsibility, consistent with standard Aurora MySQL
- **Scale to zero**: Conditional — requires an engine version that supports auto-pause and a minimum capacity of 0 ACUs; otherwise the minimum is 0.5 ACU. Enabled features and settings can require a higher effective floor or prevent auto-pause
- **VPC required**: Yes (no Express Configuration for MySQL)
- **Multi-region**: Global Database for disaster recovery
- **Free Tier**: new-account AWS Free Tier — $100 at sign-up plus up to $100 more ($200 total), usable across eligible services including Aurora for up to 12 months (per aws.amazon.com/rds/aurora/pricing). Note: the named "Free plan" 4-ACU/1-GiB-per-cluster allowance is documented for Aurora PostgreSQL serverless; MySQL workloads draw on the same credits
- **Min cost**: ~$0 with auto-pause; ~$45/month always-on at 0.5 ACU (compute only; storage billed separately)
- **Time to first query**: 10-15 min (VPC + cluster setup)
- **Key features**: Serverless, Global Database, I/O-Optimized, parallel query
- **Migration tooling**: Aurora MySQL power for Kiro (AI-assisted RDS MySQL → Aurora MySQL migration via the Kiro IDE; a migration aid, not an engine feature)
- **Limitations**: No Express Configuration, no pgvector equivalent
- **Best for**: Existing MySQL workloads, teams with MySQL expertise
- **Not for**: New apps without MySQL requirement
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deployment | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |