skills.rest
danzakon
danzakonCOMMUNITY
Explore all skills by this author →
GitHub

db-rebuild

Rebuild SQLite index.db from Markdown frontmatter in content files.

Updated Aug 27, 2026
Search Tags:#database#data integrity#sqlite#recovery#index#rebuild
One-click install
npx skills add https://github.com/danzakon/dan-life --skill db-rebuild
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-rebuild
Source: https://github.com/danzakon/dan-life/tree/main/skills/db-rebuild
Command: npx skills add https://github.com/danzakon/dan-life --skill db-rebuild

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill reconstructs the index.db file, ensuring data integrity when the database is corrupted, lost, or requires a fresh build from source content.

Core Features & Use Cases

  • Database Reconstruction: Rebuilds the SQLite index from scratch using frontmatter data in Markdown files.
  • Data Integrity: Acts as a safety net for the database, ensuring it accurately reflects the content files.
  • Use Case: If your index.db becomes corrupted or you suspect inconsistencies, this Skill will restore it by reprocessing all relevant content files.

Quick Start

Rebuild the database from the content files.

Frequently Asked Questions about db-rebuild

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

FAQPage Schema
How do I rebuild a corrupted SQLite database from Markdown frontmatter?▼

To rebuild a corrupted SQLite database from Markdown frontmatter, this Skill scans raw content files like posts and articles to reconstruct the items and series tables in index.db from scratch.

What is the best way to restore a lost SQLite index.db file?▼

Restoring a lost SQLite index.db file involves reprocessing all relevant content files, extracting frontmatter data to rebuild the items and series tables and ensure data integrity.

Do I need sqlite3 installed to reconstruct an index database from content files?▼

Yes, you need sqlite3 installed to reconstruct an index database from content files, as it handles the database operations while glob, grep, read, and write tools manage file system interaction.

Can I use database recovery to fix data inconsistencies between content files and index.db?▼

Database recovery fixes data inconsistencies by reprocessing briefs, posts, articles, research reports, and inbox files to ensure index.db accurately reflects the source content frontmatter.

What file types does the index.db rebuild process scan to restore database tables?▼

The index.db rebuild process scans raw files, briefs, posts, articles, research reports, and inbox files to extract frontmatter and restore the items and series tables.

When should I rebuild index.db instead of running a standard database migration?▼

You should rebuild index.db instead of running a database migration when the database is corrupted, lost, or suspected of having inconsistencies, requiring a fresh build from source content.

Related Skills

Explore More Software Engineering Skills→
greatSuminigreatSumini
434

subagent-creator

Create Claude Code sub-agents with YAML frontmatter and system prompts.

Community
Advanced
BirdywenBirdywen
1

sqlite-data

Create, query, analyze, and export SQLite data via the sqlite3 CLI.

Community
Intermediate
edochiedochi
27

mdvs

Infer typed schemas from Markdown frontmatter and validate files.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

automating-database-backups

Generate backup scripts with compression, encryption, and cron scheduling for PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Intermediate