SQLite Truncated Database Recovery FAQs

Question 1

What specific SQLite structures can this skill handle?

Accepted Answer

The skill provides deep expertise in SQLite's internal architecture, including Table Leaf Page layouts (Type 0x0d), variable-length integers (varints), cell pointer arrays, and the mapping of serial types to their corresponding data formats (Strings, BLOBs, and Integers).

Question 2

How does this skill improve the data recovery workflow?

Accepted Answer

It streamlines the recovery process by preventing iterative 'trial and error' scripts. By providing a systematic assessment strategy—including hex analysis and serial type mapping—it allows Claude to build a modular, high-precision recovery script that handles big-endian integers and complex SQLite data formats correctly on the first attempt.

Question 3

Can this skill recover data if the database header is missing?

Accepted Answer

Yes. This skill identifies corruption patterns where the 100-byte SQLite header is absent. It teaches Claude to recognize a database by its data pages (starting with 0x0d or 0x05) and adjust parsing offsets to recover records even without a valid file signature.

Question 4

What does the SQLite Truncated Database Recovery skill do?

Accepted Answer

This skill provides Claude with specialized knowledge to recover data from SQLite files that are truncated or corrupted. It moves beyond standard repair commands by using manual binary parsing, identifying page structures (like 0x0d table leaves), and decoding varints to extract raw records directly from the hex data.

Question 5

When should I use this skill instead of standard recovery tools?

Accepted Answer

You should use this skill when standard tools like the SQLite '.recover' command or 'PRAGMA integrity_check' fail. It is specifically designed for scenarios where the database header is missing, the file is cut off mid-page, or filesystem errors have rendered the file unreadable by the standard SQLite engine.

SQLite Truncated Database Recovery

SQLite Truncated Database Recovery

Key Features

Use Cases

Key Features

Use Cases