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/memorydb.md
View on GitHub# MemoryDB
- **Docs**: https://docs.aws.amazon.com/memorydb/
- **Docs (llms.txt)**: https://docs.aws.amazon.com/memorydb/latest/devguide/llms.txt
- **Data model**: In-memory key-value and data structures (durable primary store)
- **Query language**: Valkey/Redis commands (GET, SET, HSET, ZADD, XADD, JSON.*, FT.SEARCH, etc.)
- **Compatibility**: Valkey/Redis OSS protocol (open-source, same drivers and tools)
- **Serverless**: No (provisioned node clusters with sharding)
- **Scale to zero**: No
- **VPC required**: Yes
- **Multi-region**: Multi-Region active-active (eventually consistent cross-region, strongly consistent within region)
- **Free Tier**: None (covered by $100-200 new-account credits)
- **Min cost**: ~$75/month (db.t4g.small, single shard + 1 replica)
- **Time to first query**: 5-10 min (VPC + cluster creation)
- **Key features**: Microsecond reads / single-digit ms writes, Multi-AZ durable transactional log, vector search (HNSW, single-digit ms at 99%+ recall), JSON document support, data tiering (memory + SSD for nearly 5x capacity at 60% lower cost), 160M+ requests/sec per cluster, 100+ TB storage, sharding, ACLs
- **Limitations**: No scale to zero, VPC required, provisioned capacity only, in-memory cost scales with data size, Multi-Region excludes data tiering and vector search
- **Best for**: Workloads requiring multi-region active-active writes (strongly consistent within region, eventually consistent cross-region) — the capability that distinguishes MemoryDB from ElastiCache
- **Not for**: Single-region workloads (ElastiCache offers the same durability, vector search, and microsecond latency at lower cost with a Serverless option), large analytical datasets, relational data with JOINs, workloads needing scale-to-zero cost efficiency
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 |