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/privacy.md
View on GitHub# Privacy and Connection Policy
## Local-first baseline
- Prefer local files, user-pasted snippets, repository metadata, and local tooling.
- Minimize data: inspect only what is necessary and favor schemas, statistics, and sampled/redacted values over raw rows.
- Treat credentials, tokens, connection strings, customer data, employee data, and unreleased business metrics as sensitive.
- Never place secrets in prompts, logs, generated files, shell history, URLs, or reports.
## Database posture
Start with analysis, not execution. Review SQL, schemas, manifests, query plans, and existing artifacts locally. For an explicitly approved connection, use metadata and bounded read-only queries first. V1 does not execute DDL, DML, grants, exports, unbounded scans, or production changes.
## Connected Advanced gate
A connected action is allowed only after all of these steps:
1. The user explicitly requests the connected action; never infer consent from a local command.
2. Authenticate through the configured provider without exposing credentials.
3. Identify the destination, permissions, operation, and exact content to be transmitted.
4. Redact secrets and unnecessary sensitive values.
5. Show the user a content preview and risks.
6. Obtain explicit approval for that preview.
7. Use least privilege, smallest scope, and read-only access whenever possible.
8. Report what was accessed or sent and verify the result.
If any gate fails, remain local and explain the limitation. Free behavior never requires, discovers, authenticates to, or calls MCP.
## Learning and assessment
Read `.ae/exercise.json` when present. In Assessment mode, do not expose answers, provide a replacement solution, or edit the learner's submission. Grading is read-only on its first pass.
## Product boundary
This toolkit covers analytics engineering: SQL, data quality, analytical models, dbt, requirements, warehouses, and data/API pipelines. Decline frontend, generic backend, SEO, DevOps, and general application work; redirect to an appropriate tool.
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 |