freshie-inventory

# Freshie Inventory Manager Interactive command center for the freshie ecosystem inventory database. ## Current DB Status !`sqlite3 freshie/inventory.sqlite "SELECT 'Run #' || id || ' — ' || run_date || ' | Plugins: ' || total_plugins || ' | Skills: ' || total_skills || ' | Packs: ' || COALESCE(total_packs, 0) FROM discovery_runs ORDER BY id DESC LIMIT 3;" 2>/dev/null || echo "DB not found at freshie/inventory.sqlite"` !`sqlite3 freshie/inventory.sqlite "SELECT grade || ': ' || COUNT(*) FROM skill_compliance GROUP BY grade ORDER BY grade;" 2>/dev/null` ## Overview The freshie database is the single source of truth for ecosystem-wide metrics — plugin counts, skill compliance grades, pack coverage, anomaly detection, and historical trends across versioned discovery runs. This skill is an **interactive wizard** — it always asks what you want to do, then delegates heavy operations to specialized subagents. **Database location:** `freshie/inventory.sqlite` (50 tables, versioned by `run_id`) **Key scripts:** - `freshie/scripts/rebuild-inventory.py` — full repo scan, creates new discovery run - `freshie/scripts/batch-remediate.py` — auto-fix compliance issues - `scripts/validate-skills-schema.py` — enterprise validation with DB population ## Prerequisites - `sqlite3` CLI available on PATH - `python3` with `pyyaml` installed - Working directory is the repo root (`claude-code-plugins/`) - Database exists at `freshie/inventory.sqlite` - `/email` skill installed (for PDF repor...