dst-check-freshness

Check DST table freshness against a maximum age threshold.

2|1|Updated Oct 30, 2025
One-click install
npx skills add https://github.com/mikkelkrogsholm/dst-skills --skill dst-check-freshness
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dst-check-freshness
Source: https://github.com/mikkelkrogsholm/dst-skills/tree/main/.claude/skills/dst-check-freshness
Command: npx skills add https://github.com/mikkelkrogsholm/dst-skills --skill dst-check-freshness

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Ensures your analysis uses current data by assessing how old local copies are and when to refresh from DST.

Core Features & Use Cases

  • Age calculation: Determine data age from last_updated and fetch_timestamp.
  • Threshold checks: Evaluate freshness against a max-age setting.
  • Actionable outcomes: Prompt to refresh or proceed with analysis with a freshness note.

Quick Start

python scripts/db/query_metadata.py --table-id FOLK1A --check-freshness --max-age-days 30

Frequently Asked Questions about dst-check-freshness

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I check if my DuckDB data needs refreshing?

Data freshness checks compare your local table's last update timestamp against a maximum age threshold to determine whether a refresh is required. Use the CLI metadata check with --table-id and --max-age-days to get the data age and threshold status instantly.

What does data freshness mean for DST tables?

Freshness measures how old your local copy is by calculating the gap between the last_updated timestamp and the current fetch time. Stale data can skew analysis results, so freshness validation ensures you're working with current information before proceeding with workflows.

Can I automate refresh decisions based on data age?

Yes. The freshness check outputs actionable outcomes—comparing data age against your max-age setting—to guide whether to refresh or proceed with analysis, enabling automated validation within CLI-based analysis pipelines.

How do I set up a freshness validation in my analysis workflow?

Run the metadata check script with your table ID and desired maximum age in days. It returns Last Updated, Fetch Timestamp, Data Age, and Threshold status to inform your refresh decision before starting downstream analysis.

What happens if my data exceeds the maximum age threshold?

When data age surpasses your max-age-days limit, the freshness check flags it as stale and recommends refreshing from DST. This prevents analysis on outdated information and maintains data quality across your workflows.