Freshie Inventory Manager

Interactive command center for the freshie ecosystem inventory database.

Current DB Status

!sqlite3 freshie/inventory.sqlite "SELECT 'Run #' || id || ' — ' || rundate || ' | Plugins: ' || totalplugins || ' | Skills: ' || totalskills || ' | Packs: ' || COALESCE(totalpacks, 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 report emailing)

Instructions

Step 1: Present Main Menu

When invoked, ALWAYS start by presenting this menu using AskUserQuestion:

FRESHIE INVENTORY COMMAND CENTER
================================================================

What would you like to do?

 1. Dashboard        — Current status, grades, staleness
 2. Discovery Scan   — Full repo scan, create new run
 3. Compliance Check — Enterprise validation + DB population
 4. Remediation      — Batch fix compliance issues
 5. Query            — Ad-hoc SQLite queries
 6. Compare Runs     — Delta analysis between runs
 7. Export Data      — CSV exports to freshie/exports/
 8. Anomaly Scan     — Data quality + outlier detection
 9. Pack Coverage    — SaaS pack completeness metrics
10. Full Audit       — Scan + validate + report (end-to-end)
11. Report Only      — Generate summary from existing data

Use AskUserQuestion with these options. If the user's initial prompt already contains

a clear intent (e.g., "freshie status"), skip the menu and route directly.

Step 2: Execute Chosen Workflow

Based on selection, fo