Skip to content

opensite-ai/opensite-skills / aws-database

aws-database

Verified

Routes 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.

FileKindSize
.aws-skill-metadataother18 B
SKILL.mdskill md7.8 KB
assets/aurora-dsql.mdmarkdown1.4 KB
assets/aurora-mysql.mdmarkdown1.9 KB
assets/aurora-postgresql.mdmarkdown2.5 KB
assets/documentdb.mdmarkdown1.4 KB
assets/dynamodb.mdmarkdown2.9 KB
assets/elasticache.mdmarkdown3.4 KB
assets/keyspaces.mdmarkdown2.0 KB
assets/memorydb.mdmarkdown1.7 KB
assets/neptune.mdmarkdown2.1 KB
assets/odb-aws.mdmarkdown1.9 KB
assets/rds-db2.mdmarkdown1.1 KB
assets/rds-mariadb.mdmarkdown1.5 KB
assets/rds-mysql.mdmarkdown1.2 KB
assets/rds-oracle.mdmarkdown1.5 KB
assets/rds-postgresql.mdmarkdown1.4 KB
assets/rds-sqlserver.mdmarkdown1.3 KB
assets/timestream.mdmarkdown1.8 KB
references/handoff.mdmarkdown4.1 KB
references/report-issue.mdmarkdown3.9 KB
references/select.mdmarkdown19.5 KB

assets/elasticache.md

View on GitHub
# ElastiCache (Valkey)

- **Docs**: https://docs.aws.amazon.com/AmazonElastiCache/
- **Docs (llms.txt)**: https://docs.aws.amazon.com/AmazonElastiCache/latest/dg/llms.txt
- **Data model**: In-memory key-value and data structures (durable primary store with durability enabled, or cache layer without)
- **Query language**: Valkey/Redis commands (GET, SET, HSET, ZADD, XADD, FT.SEARCH, FT.AGGREGATE, etc.)
- **Compatibility**: Valkey/Redis protocol (open-source, no vendor lock-in)
- **Serverless**: Yes (option)
- **Serverless type**: Capacity — Serverless mode auto-scales compute and memory. Compute scales to zero compute. Memory has a minimum cache size of 100MB
- **Scale to zero**: Partial — compute scales to zero, minimum 100MB memory floor
- **VPC required**: Yes
- **Multi-region**: Global Datastore (replicate a primary to up to 2 secondary Regions — 3 Regions total — with sub-second replication lag; local reads at microsecond latency from any Region; promote a secondary to primary for fast disaster recovery). Cross-Region replicas are read-only; for active-active multi-Region writes use MemoryDB.
- **Free Tier**: up to $200 credits for free tier accounts - applicable to ElastiCache Serverless as well as any node-based instance deployments
- **Min cost**: $0 (free tier) → ~$6/month after (ElastiCache for Valkey Serverless)
- **Time to first query**: 1 min (Serverless) and 5-10 min (node-based)
- **Key features**: Sub-millisecond latency, sorted sets (leaderboards), pub/sub, streams, Lua scripting, JSON support, durability (sync or async writes via Multi-AZ transactional log, Valkey 9.0+), vector search (HNSW, up to 32K dimensions, microsecond latency, 95%+ recall, billions of embeddings — Valkey 8.2+), full-text/numeric/tag/hybrid search with aggregations (Valkey 9.0+), semantic caching (reduce LLM token costs via embedding-similarity matching on cached prompt/response pairs), Global Datastore for multi-region replication with local-speed reads
- **Durability modes** (Valkey 9.0+): With durability enabled, ElastiCache is a primary database (no backing store, no cache-miss penalty — data lives here as source of truth). Synchronous writes (zero data loss, single-digit ms write latency, microsecond reads) or asynchronous writes (microsecond write AND read latency, up to 10s data loss on failure, no additional cost)
- **Agentic workloads**: Agentic memory (sub-ms read/write for agent state, conversation history, tool call results, and workflow checkpoints stored as JSON/hashes with TTL), semantic caching to cut LLM token spend on repetitive queries, vector search for RAG retrieval, Global Datastore for multi-region AI applications with local-latency access to shared context
- **Limitations**: In-memory (cost scales with data size), minimum 100MB memory on Serverless, VPC required
- **Best for**: Durable primary data store for microsecond-latency workloads (with durability enabled), caching (API responses, query results, sessions), real-time leaderboards and counters, rate limiting, pub/sub messaging, streams, AI agent memory and workflow state, semantic/prompt caching to cut LLM costs, real-time vector similarity search (recommendations, RAG, anomaly detection), payment tokenization, real-time inventory, global low-latency reads via Global Datastore
- **Not for**: Multi-region active-active writes (use MemoryDB multi-region replication), large analytical datasets, relational data with JOINs, workloads needing full scale-to-zero cost efficiency
writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deploymentStars: 322kUpdated Claude CodeCodexVerifiedInstall
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 119kUpdated Claude CodeCodexVerifiedInstall
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: 118kUpdated Claude CodeCodexVerifiedInstall