Analyze SQLite on-disk format and B-tree structures in Turso databases.
npx skills add https://github.com/tursodatabase/turso --skill storage-format
Please help me install this Agent Skill. Skill: storage-format Source: https://github.com/tursodatabase/turso/tree/main/.claude/skills/storage-format Command: npx skills add https://github.com/tursodatabase/turso --skill storage-format
This Skill provides a concise guide to the SQLite on-disk format, including pages, cells, overflow, and the freelist, to help engineers understand data layout and storage characteristics.
Use the storage-format skill to interpret a Turso database file's on-disk layout, referencing the header table and page type descriptions to analyze a sample file.
High-intent search queries and answers about installing and using this skill.
The SQLite B-tree page layout organizes data using page headers, cells, and record payloads to structure storage on disk. It defines how data pages, payload encoding, and overflow chains are managed for precise storage interpretation.
Debugging SQLite storage capacity and overflow chains requires analyzing the on-disk format, including page structures and the freelist. This skill interprets header fields, cell formats, and payload encoding to identify storage layout issues and plan capacity.
Interpreting SQLite file header fields like magic, page size, and encoding involves analyzing the database header table and page type descriptions. This process decodes the on-disk layout to explain storage characteristics and data representation.
Yes, the SQLite on-disk format uses serial types to define how records and payloads are stored within data pages. Understanding these serial types and cell formats is essential for precise debugging and performance tuning of the storage engine.
Analyze the SQLite freelist during performance tuning when debugging storage issues or planning capacity for the Turso storage engine. Understanding the freelist and overflow chains helps identify unused pages and optimize on-disk data layout.
ZurybrRecover data from truncated SQLite databases via binary page analysis.
elophantoMeasure system performance baselines and analyze bottlenecks for SLA compliance.
luissimon96Audit web application performance with Lighthouse, Web Vitals, and N+1 query detection.
AltinityDiagnose ClickHouse storage usage, compression efficiency, and part sizes via checks.sql queries.
