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

View on GitHub
# Keyspaces (Apache Cassandra)

- **Docs**: https://docs.aws.amazon.com/keyspaces/
- **Docs (llms.txt)**: https://docs.aws.amazon.com/keyspaces/latest/devguide/llms.txt
- **Data model**: Wide-column (partition key + clustering columns)
- **Query language**: CQL (Cassandra Query Language)
- **Compatibility**: Apache Cassandra compatible (CQL, open-source Cassandra drivers)
- **Serverless**: Yes (on-demand and provisioned capacity)
- **Serverless type**: Operations — no cluster to manage, create a keyspace and start writing; capacity scales automatically
- **Scale to zero**: Yes (on-demand: throughput scales to zero; storage still billed)
- **VPC required**: No (VPC endpoints supported)
- **Multi-region**: Multi-Region replication (add/remove Regions on a live keyspace)
- **Consistency**: Tunable reads (ONE, LOCAL_QUORUM); lightweight transactions (LWT) for conditional writes
- **Free Tier**: First three months (30M write request units, 30M read request units, 1 GB storage per month).
- **Min cost**: $0 (free tier); on-demand and provisioned capacity modes, AWS Database Savings Plans supported
- **Time to first query**: Seconds (create table, start writing)
- **Key features**: CQL compatibility, serverless, replication across 3 AZs, multi-Region replication, TTL, point-in-time recovery, CDC Streams (pull API), client-side timestamps, logged batches, User Defined Types (UDTs) including nested UDTs, frozen collections, pre-warming, IPv6, customer-managed KMS keys
- **Limitations**: No JOINs, no secondary indexes, no full-text search, no complex analytical queries, per-row 1 MB size, some CQL features unsupported
- **Best for**: Cassandra migrations, CQL/Cassandra-driver applications, high-throughput write-heavy workloads, event-driven pipelines via CDC Streams, IoT device registries, fleet and time-series-style data already modeled in CQL
- **Not for**: Relational/transactional joins, full-text search, analytics, teams without a CQL/Cassandra requirement (DynamoDB is the default key-value choice)
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