amazon-keyspaces

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

Updated Jul 1, 2026
One-click install
npx skills add https://github.com/sakicodes/BuildFestHackathon26 --skill amazon-keyspaces-sakicodes
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: amazon-keyspaces
Source: https://github.com/sakicodes/BuildFestHackathon26/tree/main/.agents/skills/amazon-keyspaces
Command: npx skills add https://github.com/sakicodes/BuildFestHackathon26 --skill amazon-keyspaces-sakicodes

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Migrating to or operating Amazon Keyspaces (for Apache Cassandra) requires accurate cost estimates, feature-compatibility verification, and safe infrastructure changes, all of which agents frequently get wrong without authoritative guidance. ## Core Features & Use Cases - Pricing Estimation: Calculate monthly on-demand, provisioned, and Savings Plan costs from manual traffic inputs (Mode 1) or from real Cassandra nodetool diagnostics (Mode 2), with optional PDF reports. - Compatibility Checking: Scan CQL schemas and prepared statements to flag unsupported features such as materialized views, secondary indexes, triggers, UDFs, and LWT-in-batch, with migration recommendations (Mode 3). - SQL-to-Keyspaces Migration: Translate relational schemas into three priced NoSQL data-modeling strategies (denormalized, query-driven, wide-row) and recommend one (Mode 4). - Infrastructure Operations: Create keyspaces and tables, configure auto-scaling, CDC, TTL, PITR, encryption, and pre-warming via AWS CLI, with a strict allow/warn/refuse safety model. - Use Case: A team migrating a self-managed Cassandra cluster captures nodetool tablestats and info files, then gets a per-keyspace cost breakdown plus a compatibility report flagging every unsupported feature 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 for my workload?

Provide your AWS region, reads per second, writes per second, average row size in bytes, and storage in GB. The skill runs calculate.ts to produce monthly on-demand, provisioned, and Savings Plan cost breakdowns with a recommendation.

How do I migrate from Cassandra to Amazon Keyspaces?

Capture nodetool tablestats and nodetool info from every node, plus your schema via cqlsh DESCRIBE SCHEMA. The skill parses these diagnostics to derive throughput, estimate costs, and flag unsupported features like materialized views and secondary indexes.

Does Amazon Keyspaces support materialized views and secondary indexes?

No, Amazon Keyspaces does not support materialized views, secondary indexes, triggers, UDFs, or user-defined aggregates. The recommended migration pattern is a denormalized secondary table maintained by application-side dual writes.

Why does my Cassandra driver get NoNodeAvailableException with Keyspaces?

This usually comes from a heartbeat timeout that is too low, an undersized connection pool, or hostname validation left enabled. Set heartbeat timeout to 2000ms, pool.local.size to at least 3, and hostname-validation to false.

Can I use LWT inside a batch on Amazon Keyspaces?

No, lightweight transactions inside UNLOGGED BATCH are not supported, and LOGGED BATCH is not supported either. Issue each conditional statement individually or use application-level coordination for multi-row atomicity.

What are the limitations of the Keyspaces compatibility check?

The check flags schema-level features like indexes, triggers, views, functions, and aggregates, plus LWT-in-batch and aggregate queries from prepared statements. It does not audit data-type or CQL-syntax differences, so consult the official functional-differences page for full coverage.