Cassandra SSTable Format Parsing

Parse Cassandra 5.0+ SSTable files by pointing this Skill at Data.db, Index.db, Statistics.db, Summary.db, and TOC components. Extract binary format details, inspect partition layouts, validate offsets, and diagnose compression or BTI indexing problems using zero-copy deserialization and built-in format references.

SSTable parsing supports LZ4, Snappy, and Deflate compression formats. The Skill handles block boundary verification, decompression validation, and format-specific offset calculations across all three algorithms to identify compression-related data corruption or misalignment.

Yes. By parsing SSTable binary formats, inspecting hex dumps, validating partition boundaries, and analyzing BTI mappings, you can diagnose data corruption, locate offset errors, and identify which components are affected—enabling targeted recovery strategies.

Use the Skill's reference notes to decode BTI (Big Table Index) mappings and partition layout structure. Understand flag bytes, VInt encodings, and delta-encoded metadata handling to verify correct partition boundaries and block offsets within Data.db and Index.db.

Data.db stores partition rows; Index.db maps row keys to offsets; Statistics.db holds column metadata; Summary.db provides partition index summaries; TOC tracks file format version and component checksums. Parsing each reveals structure integrity and cross-component consistency.