storage-format
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.zipInstalls 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 tursodbKey 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
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
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.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| storage-format (this skill) | 2 | 10mo | Review | Advanced |
| postgresql-table-design | 30 | 8mo | No flags | Intermediate |
| agentdb-advanced-features | 7 | 1y | Review | Advanced |
| event-store-design | 5 | 6mo | No flags | Advanced |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by tursodatabase
View all by tursodatabase →You might also like
postgresql-table-design
wshobson
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
agentdb-advanced-features
ruvnet
Master advanced AgentDB features including QUIC synchronization, multi-database management, custom distance metrics, hybrid search, and distributed systems integration. Use when building distributed AI systems, multi-agent coordination, or advanced vector search applications.
event-store-design
wshobson
Design and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, choosing event store technologies, or implementing event persistence patterns.
database-design
davila7
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
database-schema-designer
davila7
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.
nosql-expert
davila7
Expert guidance for distributed NoSQL databases (Cassandra, DynamoDB). Focuses on mental models, query-first modeling, single-table design, and avoiding hot partitions in high-scale systems.