cv-db-rebuild

Rebuild cv-agent.db from CV copy files, sources.md, and ccrecall databases. Use when database is lost, corrupted, or needs full reconstruction.

Jump to install

Repository: spences10/cv
Last source activity: February 24, 2026 at 14:55
Detected SKILL.md language: English
Stars: 38
Forks: 6

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

npx skills add https://github.com/spences10/cv --skill cv-db-rebuild

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

File Explorer

3 files

SKILL.md

Source instructions · Read-only preview

Back to search Back to installation

name	cv-db-rebuild
description	Rebuild cv-agent.db from CV copy files, sources.md, and ccrecall databases. Use when database is lost, corrupted, or needs full reconstruction.

CV Agent Database Rebuild

Reconstruct data/cv-agent.db from source files using mcp-sqlite-tools.

Quick Start

Open/create DB: open_database at /home/scott/repos/cv/data/cv-agent.db
Create schema (see references/schema.sql)
Populate from sources (see references/data-sources.md)
Build FTS5 search index across all tables
SCP to prod (see memory/MEMORY.md for push process)

Table Population Order

profile — from src/lib/copy/basics.md + +layout.svelte
roles — from src/lib/copy/work.md, early-webdev-exp.md, non-webdev-exp.md
achievements — from src/lib/copy/work.md highlights + memory/sources.md
projects — from src/lib/copy/projects.md + memory/sources.md GitHub stars
skills — from src/lib/copy/skills.md with evidence strings
events — from memory/sources.md speaking section
content_stats — from memory/sources.md Fathom/blog/GitHub stats
qa_pairs — curate ~25-30 recruiter Q&A pairs across categories: about, skills, experience, community, projects, logistics
work_evidence — aggregate stats from ccrecall databases (see references)
search_index — FTS5 index across ALL content from ALL tables

Critical Rules

Use mcp-sqlite-tools for all DB operations
ALWAYS checkpoint WAL before SCP push: mcp-sqlite-tools uses WAL mode. Edits go to .db-wal, not the main file. Run PRAGMA wal_checkpoint(TRUNCATE) before any file-based transfer.
Push process: stop container → SCP → delete WAL/SHM on prod → start
XtendOps ccrecall (~/Downloads/ccrecall.db) contains customer PII — extract AGGREGATE stats ONLY
Personal ccrecall (~/.claude/ccrecall.db) — per-project session counts, tools, date ranges
Use en-GB spellings throughout
After rebuild, verify with: SELECT COUNT(*) FROM search_index (expect ~140 rows)

References

schema.sql — Full table DDL
data-sources.md — Where each table's data comes from

cv-db-rebuild

Source facts

Install options

Review the source files

CV Agent Database Rebuild

Quick Start

Table Population Order

Critical Rules

References

CV Agent Database Rebuild

Quick Start

Table Population Order

Critical Rules

References