ST

It details the SQLite file format, including page types, cell structures, and memory management mechanisms.

Install

mkdir -p .claude/skills/storage-format && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/2096" && unzip -o skill.zip -d .claude/skills/storage-format && rm skill.zip

Installs to .claude/skills/storage-format

Activation

This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.

SQLite file format, B-trees, pages, cells, overflow, freelist that is used in tursodb
85 charsno explicit “when” trigger
Advanced

Key capabilities

  • →Parse SQLite database file headers
  • →Navigate B-tree page structures
  • →Decode table and index cell formats
  • →Manage freelist and overflow pages

How it works

The skill provides a guide to the SQLite on-disk format, including page types, cell layouts, and record serialization, with specific references to Turso's internal implementation.

Inputs & outputs

You give it
SQLite database file
You get back
Database structure and page metadata

When to use storage-format

  • →Debugging low-level database file corruption
  • →Optimizing database storage structures
  • →Understanding SQLite internal organization

About storage-format

Provides structure and parsing details for the SQLite database file format. It explains page types (interior vs leaf), cell layouts, and freelist mechanisms.

SQLite file format, B-trees, pages, cells, overflow, freelist that is used in tursodb

When not to use it

  • →Modifying database files without backup

Prerequisites

tursodb environment

Limitations

  • →Requires understanding of big-endian integer formats
  • →Limited to SQLite format 3

How it compares

It provides direct access to internal storage structures rather than relying on high-level SQL abstraction layers.

Compared to similar skills

storage-format side by side with the closest alternatives in the catalog.

SkillInstallsUpdatedSafetyDifficulty
storage-format (this skill)210moReviewAdvanced
postgresql-table-design308moNo flagsIntermediate
agentdb-advanced-features71yReviewAdvanced
event-store-design56moNo flagsAdvanced

Try saying

Example prompts that trigger this skill in your AI assistant.

Search skills

Search the agent skills registry