Cis AWS Database 8.4

DevOps & Security

cis-aws-database-8.4

Cis AWS Database 8.4 is an Agent Skill for devops & security published in the CyberStrikeus/CyberStrike repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Ensure Amazon Keyspaces tables have Point-in-Time Recovery (PITR) enabled

View on GitHub ↗

QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

Open your project in Codex.
Copy and paste the prompt below.
Review files and risks before approving any action.

Prompt to paste

Inspect the Agent Skill at https://github.com/CyberStrikeus/CyberStrike/blob/HEAD/.cyberstrike/skill/CIS_benchmarks/Cloud_Providers/AWS/CIS_AWS_Database_Services_Benchmark_v2.0.0/cis-aws-database-8.4/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/cis-aws-database-8-4, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

8.4 Ensure Amazon Keyspaces tables have Point-in-Time Recovery (PITR) enabled (Manual)

Description

Ensure that Amazon Keyspaces tables have Point-in-Time Recovery (PITR) enabled. When PITR is enabled, Amazon Keyspaces automatically creates continuous backups of table data, allowing tables to be restored to any point in time within the last 35 days. This protection is applied at the table level and provides defense against accidental writes, deletions, and other data loss scenarios.

Rationale

Enabling PITR on Amazon Keyspaces tables provides continuous, automatic backup protection without requiring manual snapshot management or impacting table performance or availability. In the event of accidental data corruption, malicious writes, or system failures, PITR allows rapid recovery to any second within the last 35 days, significantly reducing data loss exposure and recovery time.

Impact

Enabling PITR for Amazon Keyspaces ensures that table data is continuously protected and recoverable to any point within 35 days, providing strong defense against accidental loss and corruption while maintaining full table performance and availability.

Audit Procedure

Using AWS CLI

List PITR status for all tables in a keyspace:

aws keyspaces get-table \
  --keyspace-name <keyspace-name> \
  --table-name <table-name>

If the value of pointInTimeRecovery = DISABLED, this means PITR is turned off

Expected Result

The pointInTimeRecovery value should be ENABLED for all tables.

Remediation

Using AWS CLI

Enable PITR on a specific table:

aws keyspaces update-table \
  --keyspace-name <keyspace-name> \
  --table-name <table-name> \
  --point-in-time-recovery status=ENABLED

This command enables PITR on the specified table in the keyspace.
The change takes effect immediately with no performance impact.

Default Value

PITR is disabled by default on Amazon Keyspaces tables.

References

https://aws.amazon.com/products/databases/

CIS Controls

Controls Version	Control	IG 1	IG 2	IG 3
v8	11 Data Recovery	x	x	x

Profile

Level 1 | Manual