/ccboard-remember — Store Knowledge in Brain

Saves a piece of knowledge to ~/.ccboard/insights.db for future session context injection.

Usage

/ccboard-remember fix: <description>
/ccboard-remember pattern: <description>
/ccboard-remember context: <description>
/ccboard-remember decision: <description>

Workflow

1. Parse the user's input prefix (fix:, pattern:, context:, decision:)

- Default type is context if no prefix provided

1. Get the current project path with pwd
2. Distill the input into a clean 1-line summary (≤ 120 chars)
3. Run this exact command (substituting TYPE, SUMMARY, and ORIGINAL):

sqlite3 "$HOME/.ccboard/insights.db" \
  "PRAGMA journal_mode=WAL;
   CREATE TABLE IF NOT EXISTS insights (
     id INTEGER PRIMARY KEY AUTOINCREMENT,
     session_id TEXT, project TEXT NOT NULL,
     type TEXT NOT NULL, content TEXT NOT NULL,
     reasoning TEXT, archived INTEGER NOT NULL DEFAULT 0,
     created_at TEXT NOT NULL DEFAULT (datetime('now'))
   );
   INSERT INTO insights (project, type, content, reasoning, created_at)
   VALUES ('$(pwd)', 'TYPE', 'SUMMARY', 'ORIGINAL', datetime('now'));"

1. Confirm: Stored [TYPE] — SUMMARY

Type Guide

Examples

/ccboard-remember fix: SQLite WAL mode required when hooks write concurrently with Rust reads
/ccboard-remember pattern: Use Arc<DataStore> + parking_lot::RwLock for all shared state
/ccboard-remember context: This project targets macOS only, no Windows support needed
/ccboard-remember decision: insights.db is separate from session-metadata.db to avoid CACHE_VERSION conflicts

Safeguards

• NEVER run sqlite3 if the user input contains shell metacharacters (;, |, ` `, $()`)

that weren't in the original input — escape properly

• sql_escape the content: replace ' with '' before inserting
• If sqlite3 is not available, report the error and show the manual SQL to run
• Max content length: 500 chars (truncate with … if longer)

Expected Outcome

One new row in ~/.ccboard/insights.db, visible in the Brain tab (cargo run) and Brain web page (/brain).