A rebuild procedure that recreates an NFL analytics warehouse—a database for storing prepared football data—and its derived views from data already on disk.

Use it after changing downloaded data or warehouse-building code, then run the warehouse tests and check the travel-data result.

It provides a repeatable way to regenerate the database and check that the rebuilt data is usable. It also points out common failures such as missing files or a database lock.

How parthakker/nfl-analytics configures Claude Code

Reuse

Borrowing it

Nothing to install: this file belongs to parthakker/nfl-analytics. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file

curl -O https://raw.githubusercontent.com/parthakker/nfl-analytics/main/.claude/skills/rebuild/SKILL.md

Clone the repo

git clone --depth 1 https://github.com/parthakker/nfl-analytics

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/parthakker/nfl-analytics/rebuild/github.svg)](https://agentmods.dev/skills/parthakker/nfl-analytics/rebuild)

Your own site

<a href="https://agentmods.dev/skills/parthakker/nfl-analytics/rebuild"><img src="https://agentmods.dev/badge/skills/parthakker/nfl-analytics/rebuild/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/parthakker/nfl-analytics/rebuild"><img src="https://agentmods.dev/badge/skills/parthakker/nfl-analytics/rebuild.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 18 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 198 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00018	$0.00198
Opus 5.5	$0.00007	$0.00079
Sonnet 5.5	$0.00004	$0.00040
Haiku 4.5	$0.00002	$0.00020

Measured 2mo ago against content hash e6d7d664140e, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

rebuild scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.claude/skills/rebuild/SKILL.md · 18 lines

What it actually says

Rebuild warehouse

Preflight: explore.cmd (DuckDB browser UI) must be closed — the rebuild deletes and recreates nfl.duckdb.
python -m nfl_analytics.cli rebuild (raw tables, ~60s) then python -m nfl_analytics.cli views (venues, weather parse, views, macros).
Both must exit 0; views output ends with "travel sanity OK". Then python -m pytest -m warehouse -q.
If a table fails with "no files match": non-optional glob missing from data/ — run /refresh-data instead. If the Jarvis server was up during the rebuild it may hold a stale handle — restart it if /api/health degrades.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

2mo ago First seen · 18 lines · 18 tokens per session scan A e6d7d664140e

Subscribe to this mod's changes

rebuild is a skill published in the GitHub repository parthakker/nfl-analytics (1 stars, last pushed 11d ago), licensed MIT. It adds 18 tokens to every session and 198 once invoked, about $0.0001 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Analytics and metrics Databases duckdb mcp nfl sports-analytics streamlit

rebuild next to 6 skills from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
rebuildparthakker/nfl-analytics	Skill	1	11d ago	MIT	A	18	Claude Code
usageCanner/WrenAI	Skill	18k	2d ago	none	A	156	Claude Code, Codex
generate-mdlCanner/WrenAI	Skill	18k	2d ago	none	A	82	Claude Code, Codex
dlt-connectorCanner/WrenAI	Skill	18k	2d ago	none	A	158	Claude Code, Codex
wrenCanner/WrenAI	Skill	18k	2d ago	none	A	315	Claude Code
duckdb-spatialznlgis/opengis-skills	Skill	76	10d ago	MIT	A	125	Claude Code, Codex
duckdb-differentialtobilg/duckdb-differential	Skill	48	4d ago	MIT	A	123	Claude Code

nfl-analytics: Skill for Claude Code