analyticsengineering/ae-toolkit / skills/freshness-investigation
freshness-investigation
VerifiedInvestigates whether analytical data is ready by separating configured schedules and freshness expectations from locally observed timestamps and run artifacts. Use when data appears stale, late, incomplete, or unavailable, and before raising a freshness threshold or silencing a failing check; it explains timing evidence and gaps without inventing runtime history or querying external systems.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 8.2 KB |
| references/diagrams.md | markdown | 3.2 KB |
| references/operating-rules.md | markdown | 23.3 KB |
| references/privacy.md | markdown | 2.0 KB |
| references/severity-model.md | markdown | 1.5 KB |
| references/terminology.md | markdown | 1.9 KB |
| references/warehouse-portability.md | markdown | 4.9 KB |
| scripts/infer_conventions.py | script | 55.6 KB |
| scripts/inspect_dbt.py | script | 20.2 KB |
| scripts/inspect_git.py | script | 8.5 KB |
| scripts/inspect_repo.py | script | 13.5 KB |
| scripts/project_context.py | script | 27.4 KB |
| scripts/redact_secrets.py | script | 15.2 KB |
references/terminology.md
View on GitHub# Toolkit Terminology
## Modes
- **Work mode** — Deliver a production-oriented analysis or implementation. Inspect first, state assumptions, make only authorized changes, and verify.
- **Learn mode** — Teach through questions, explanations, and progressively stronger hints. Preserve the learner's agency; do not replace their work unless they explicitly leave Learn mode.
- **Assessment mode** — Evaluate submitted work against stated criteria. Do not reveal the answer, supply a replacement solution, or edit the submission.
When `.ae/exercise.json` exists, use it to determine exercise identity, mode, constraints, rubric references, allowed tools, and expected artifacts. Do not invent missing rubric criteria.
## Execution tiers
- **Local Basic** — Free, local-only behavior using repository files, user-provided content, and local tools. It never requires or calls MCP.
- **Connected Advanced** — An explicitly requested operation using an authenticated external data or content connection. It requires destination and content preview, secret redaction, and approval before access or transmission.
## Review terms
- **Evidence** — Reproducible fact supporting a conclusion.
- **Risk** — Potential impact and the conditions that trigger it.
- **Recommendation** — Proportionate action addressing the cause.
- **Verification** — Check that demonstrates the recommendation worked.
- **Analysis-first** — Understand artifacts, scope, and query behavior before any database execution or mutation.
## Scope
In scope: SQL, analytical data modeling, dbt, data profiling and quality, analytics requirements, warehouse behavior, and ingestion/API data pipelines.
Out of scope: frontend UI, generic backend services, SEO, DevOps/platform operations, and general application development. API work is in scope only when it designs or reviews data ingestion, extraction, contracts, lineage, or analytical delivery.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |