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/dynamodb.md

View on GitHub
# DynamoDB

- **Docs**: https://docs.aws.amazon.com/amazondynamodb/
- **Docs (llms.txt)**: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/llms.txt
- **Data model**: Key-value and document (partition key + optional sort key)
- **Query language**: DynamoDB API (GetItem, Query, Scan), PartiQL (SQL-like, limited)
- **Compatibility**: Proprietary (AWS SDK, CLI, or HTTPS API); ExtendDB open-source adapter for local dev, CI, and on-premises (PostgreSQL backend)
- **Serverless**: Yes (on-demand mode)
- **Serverless type**: Operations — no tables to provision capacity for (on-demand), no infrastructure to manage
- **Scale to zero**: Yes (on-demand: $0 compute at no traffic; storage still billed)
- **VPC required**: No
- **Multi-region**: Global Tables (active-active; eventually consistent by default, optional multi-region strong consistency / MRSC)
- **Free Tier**: Always free (25 GB + 25 RCU + 25 WCU, provisioned mode)
- **Min cost**: $0 (always-free tier)
- **Time to first query**: ~5 seconds
- **Key features**: Single-digit ms at any scale, unlimited horizontal scaling, no capacity planning (on-demand), up to 20 GSIs / 5 LSIs, native vector search (`SearchVectors` API, ANN, single-digit ms at 99%+ recall, up to 4,096 dimensions, trillions of vectors, externally generated embeddings — GA August 2026), DynamoDB Streams (CDC), TTL, DAX (in-memory cache), transactions, deep service integrations (Lambda triggers, EventBridge Pipes, AppSync, Glue, Zero-ETL to Redshift/OpenSearch/Amazon S3), ExtendDB (open-source local dev and CI testing with DynamoDB API on PostgreSQL)
- **Limitations**: Access patterns must be designed upfront (changing them later is expensive — often requires table redesign and data migration), no JOINs, ad-hoc queries possible but can be slow at scale, 400KB item limit, table-wide aggregations require Scan or external pipeline; vector indexes require on-demand capacity mode, are eventually consistent, cap at 4,096 dimensions / `TopK` 100 / 18 inline filters / 5 indexes per table / 16 MB response with no pagination / 600 GB base table for index creation, have immutable definitions (dimensions, distance function, projection, filters, partition key — recreate to change), and support neither `Query`/`Scan`/PartiQL nor fine-grained access control on `SearchVectors` — if the workload exceeds these limits or needs strong consistency or mutable index definitions, route back to `select`; candidates include Aurora PostgreSQL pgvector, OpenSearch Serverless, and DocumentDB vector search
- **Best for**: Serverless and low-overhead apps wanting a fast, fully managed backend with no infrastructure to manage (to-do lists, messaging, session stores, shopping carts, IoT); and high-throughput workloads with well-defined key-based access patterns at massive scale
- **Not for**: Workloads needing ad-hoc queries or runtime JOINs, normalized schemas queried flexibly, unclear or frequently changing access patterns, and heavy analytics/aggregations
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