sqlite-db-truncate

Recover data from truncated SQLite databases via binary page analysis.

Updated Feb 24, 2026
One-click install
npx skills add https://github.com/Zurybr/lefarma-skills --skill sqlite-db-truncate-zurybr
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sqlite-db-truncate
Source: https://github.com/Zurybr/lefarma-skills/tree/main/letta/benchmarks/trajectory-only/sqlite-db-truncate
Command: npx skills add https://github.com/Zurybr/lefarma-skills --skill sqlite-db-truncate-zurybr

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps recover data from SQLite databases that are corrupted due to binary truncation, where standard tools fail to open or read the database file.

Core Features & Use Cases

  • Binary Data Analysis: Provides systematic methods to analyze the raw binary format of SQLite database files.
  • Page-Level Recovery: Extracts recoverable data from individual database pages, even when the header is damaged.
  • Use Case: You have a critical SQLite database file that suddenly became inaccessible. Use this Skill to manually parse its binary structure and extract vital tables and records.

Quick Start

Use the sqlite-db-truncate skill to recover data from the file named 'corrupted_database.db'.

Frequently Asked Questions about sqlite-db-truncate

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

FAQPage Schema
How do I recover data from a corrupted SQLite database file?

To recover data from a corrupted SQLite database, this Skill manually parses the binary file structure using Python scripts. It extracts data by performing byte-level analysis of database pages and cell structures, bypassing standard SQLite tools that fail to open truncated files.

What is the best way to extract tables from a truncated SQLite database?

Extracting tables from a truncated SQLite database requires page-level binary recovery. This Skill decodes serial types and parses individual database pages directly from the raw bytes, successfully recovering vital records even when the database header is damaged.

Why does standard SQLite fail to open my database file after truncation?

Standard SQLite tools fail to open truncated database files because the binary header is corrupted or incomplete. This Skill addresses this by performing manual binary format analysis to extract cell structures directly, ignoring the damaged header.

Can I use Python to manually parse SQLite binary pages for data recovery?

Yes, you can use Python to manually parse SQLite binary pages for data recovery. This Skill utilizes Python scripts for byte-level parsing of database pages, enabling cell structure decoding and data extraction from inaccessible files.

When do I need manual binary parsing for SQLite database recovery?

You need manual binary parsing for SQLite database recovery when standard tools fail due to binary truncation or header corruption. This approach extracts recoverable data directly from individual database pages using byte-level analysis and serial type decoding.

Does this data recovery method work if the SQLite database header is completely damaged?

Yes, this data recovery method works if the SQLite database header is completely damaged. The Skill performs page-level recovery, extracting data from individual database pages and decoding cell structures without relying on a functional database header.