Agent skill · data analytics · jeremylongshore
freshie-inventory
Manage the freshie ecosystem inventory database \u2014 a CMDB tracking\
Why this skill is useful
Adds multiple executable scripts for database management and compliance validation that extend the AI's capabilities in ecosystem inventory management.
What it needs
Requires python3, sqlite3 installed locally. About 8k tokens when loaded. Last updated 2026-08-07. 2,604 stars on the source repository.
What this skill does
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 discoveryruns 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 skillcompliance 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 (51 tables, versioned by runid) 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 freshie/scripts/run-delta.py [--run-id N] [--alert-on-regression] — (re)generate a run's delta report (schema-vs-data changes + grade regressions; exit 4 signal on regressions) freshie/scripts/dolt-sync.py [--alert-on-regression] — Dolt sync; emits the delta report post-commit and can exit 4 when grades regressed 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: 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. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills jeremylongshore/freshie-inventory