Agent skill · data analytics · jeremylongshore
freshie-inventory
Manage the freshie ecosystem inventory database \u2014 a CMDB tracking\
Why this skill is useful
Adds specific commands and scripts for managing a complex SQLite database that the AI wouldn't reliably generate on its own.
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--215bec