skills.rest
richardnroman
richardnromanCOMMUNITY
Explore all skills by this author →
GitHub

amazon-keyspaces

Estimates pricing, checks compatibility, and manages tables for Amazon Keyspaces workloads.

Updated Jul 21, 2026
Search Tags:#aws#migration#cql#cassandra#compatibility check#pricing calculator#amazon keyspaces
One-click install
npx skills add https://github.com/richardnroman/Synthetic-Data-Exchange-Licensing-Platform --skill amazon-keyspaces-richardnroman
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: amazon-keyspaces
Source: https://github.com/richardnroman/Synthetic-Data-Exchange-Licensing-Platform/tree/main/.agents/skills/amazon-keyspaces
Command: npx skills add https://github.com/richardnroman/Synthetic-Data-Exchange-Licensing-Platform --skill amazon-keyspaces-richardnroman

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve? Teams migrating from Apache Cassandra to Amazon Keyspaces often guess at costs, hit unsupported-feature surprises (materialized views, secondary indexes, LWT in batches), and misconfigure drivers, leading to failed connections and throttling. ## Core Features & Use Cases - Cost Estimation: Computes monthly on-demand, provisioned, and Savings Plan pricing from manual traffic inputs (Mode 1) or from real nodetool tablestats/info diagnostics (Mode 2), with optional PDF reports. - Compatibility Checking: Scans CQL schemas and prepared statements to flag UNSUPPORTED features like secondary indexes, triggers, materialized views, UDFs, and LWT-in-unlogged-batch, with migration guidance (Mode 3). - SQL-to-Keyspaces Migration: Translates relational schemas into three priced NoSQL data-modeling strategies (denormalized, query-driven tables, wide rows) for comparison (Mode 4). - Infrastructure Operations & Troubleshooting: Creates keyspaces/tables/UDTs with mandatory tagging, configures TTL, PITR, CDC, auto-scaling, and pre-warming under a strict confirm/warn/refuse safety policy, plus diagnoses connection errors like NoNodeAvailableException and HeartbeatException. - Use Case: A team with a self-managed Cassandra cluster captures diagnostics, runs Mode 2 to get an accurate Keyspaces cost estimate plus a compatibility report, then uses Mode 4 guidance to remodel their SQL-era tables before cutover. ## Quick Start Ask the agent to estimate Amazon Keyspaces costs for your workload by providing your region, reads and writes per second, average row size, and storage in GB.

Frequently Asked Questions about amazon-keyspaces

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I estimate Amazon Keyspaces pricing before migrating from Cassandra?▼

Provide your region, reads per second, writes per second, average row size in bytes, and storage in GB to get on-demand, provisioned, and Savings Plan monthly totals. For higher accuracy, capture nodetool tablestats and nodetool info from your cluster and run the diagnostics-based mode instead.

Which Cassandra features are not supported in Amazon Keyspaces?▼

Amazon Keyspaces does not support secondary indexes, triggers, materialized views, user-defined functions, user-defined aggregates, or LWT inside unlogged batches. The compatibility checker flags each occurrence in your schema or prepared statements and suggests migration patterns like denormalized lookup tables.

How do I check if my Cassandra schema works on Amazon Keyspaces?▼

Export your schema with cqlsh DESCRIBE SCHEMA and optionally your prepared statements as NDJSON, then run the compatibility check against those files. The report lists every unsupported object per keyspace and table with a binary UNSUPPORTED verdict and migration recommendations.

Why does my application get NoNodeAvailableException when connecting to Keyspaces?▼

This usually comes from a heartbeat timeout that is too low, an undersized connection pool, or a missing retry policy. Set the 4.x driver heartbeat timeout to 2000 milliseconds, pool local size to at least 3, and use the AmazonKeyspacesExponentialRetryPolicy with idempotence enabled.

Can the skill delete my Keyspaces tables or keyspaces?▼

No. Destructive operations like deleting keyspaces, tables, or UDTs, disabling CDC, and enabling client-side timestamps are refused by design. The skill explains why and offers an assessment instead, directing irreversible changes to your change-control process or the AWS Console.

What do I need installed to run the pricing calculator scripts?▼

The scripts require Node.js 18 or later and dependencies installed via npm install inside the scripts directory. They run with npx ts-node and output JSON that can optionally feed the PDF report generator.

Related Skills

Explore More Software Engineering Skills→
awsaws
2.5k

amazon-keyspaces

Estimates pricing, checks compatibility, and manages tables for Amazon Keyspaces workloads.

Official
Advanced
aberrantCodeaberrantCode
1

aws-aurora

Configure AWS Aurora connections with IAM authentication and connection pooling.

Community
Advanced
awsaws
2.5k

aws-database

Routes AWS database selection and operational questions to service-specific skills and knowledge cards.

Official
Advanced
tranhieutttranhieutt
70

nosql-expert

Design query-first Cassandra and DynamoDB schemas with partition key strategies.

Community
Advanced