Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Guide users building a personal CRM from simple files to structured database.
Guide users building a personal CRM from simple files to structured database.
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
Ask what they're tracking: clients, leads, investors, job contacts, networking โ context shapes schema Ask their technical comfort: spreadsheets, JSON, databases โ determines starting format Create ~/crm/ folder as the single source of truth
JSON or CSV for first version โ validate data model before adding complexity Single file contacts.json initially โ resist creating multiple files until needed Don't suggest web app until they've used files for at least a week Don't suggest database until files feel slow or limiting
id, name, email, company, phone, notes, tags, created, updated โ nothing more initially tags array over rigid categories โ flexible, no schema changes needed notes field is often the most valuable โ encourage freeform context Generate UUID for id, not auto-increment โ survives merges and imports
User asks "when did I last talk to X" โ signal they need history Separate file linked by contact_id โ not nested in contact object type field (note/email/call/meeting) enables filtering later Always include date โ timeline view is essential
Multiple contacts at same company โ signal to separate Many-to-many: one person can work at multiple companies over time company_id in contacts, not company name duplication
User mentions "pipeline", "stage", "close date", "deal value" Link to contact_id and optionally company_id Stages as simple string field initially โ don't over-engineer state machine
File operations feel slow (>100 contacts typically) User wants to query/filter in complex ways Multiple users need access (SQLite handles concurrent reads) Offer to write migration script โ don't force manual re-entry
Week 1: contacts file only, prove they'll use it Week 2: add interactions when they want history Week 3: add tags, search helper script Month 2: companies file if needed Month 3: deals file if tracking opportunities Only then: consider web UI or more complex tooling
Web application โ massive scope increase, validate data model first Email sync/integration โ suggest BCC/forward workflow, much simpler Calendar integration โ manual logging is fine initially Authentication โ single-user local CRM doesn't need it Mobile app โ sync complexity not worth it early
Quick add from command line โ reduces friction Search across all files โ grep/jq one-liner Backup to timestamped zip โ essential before migrations Export to CSV โ for users who want spreadsheet view
Backup before any bulk edit or migration Check for duplicate emails before adding contact Validate email format on entry Keep created/updated timestamps โ debugging lifesaver
Cloud folder (Dropbox/iCloud/Drive) for multi-device โ simplest Git repo for version history โ good for technical users Don't suggest complex sync solutions until files prove insufficient
Writing, remixing, publishing, visual generation, and marketing content production.
Largest current source with strong distribution and engagement signals.