# checking-freshness

> Claude/Codex skill by [@astronomer](https://omgskills.com/library/astronomer/index.md) · 454 stars · Updated 2026-10-14

Quick data freshness check. Use when the user asks if data is up to date, when a table was last updated, if data is stale, or needs to verify data currency before using it.

Tags: agentic-workflow, agents, ai, ai-agents, airflow, apache-airflow, claude, cursor, dag, data-engineering, data-pipelines, dbt, llm, mcp, orchestrator, skills, workflow-automation, workflow-management, workflow-orchestration, workflows

## Install

```sh
git clone https://github.com/astronomer/agents /tmp/agents && ln -s /tmp/agents/skills/checking-freshness ~/.claude/skills/checking-freshness
```

## From README

Data Freshness Check Quickly determine if data is fresh enough to use. Freshness Check Process For each table to check: Find the Timestamp Column Look for columns that indicate when data was loaded or updated: loadedat, updatedat, createdat (common ETL patterns) updatedat, createdat, modifiedat (application timestamps) loaddate, etltimestamp, ingestiontime date, eventdate, transactiondate (business dates) Query INFORMATIONSCHEMA.COLUMNS if you need to see column names. Query Last Update Time Check Row Counts by Time For tables with regular updates, check recent activity: Freshness Status Report status using this scale: | Status | Age | Meaning | |--------|-----|---------| | Fresh | 24 hours | Likely a problem unless batch job | | Unknown | No timestamp | Can't determine freshness | If Data is Stale Check Airflow for the source pipeline: Find the DAG: Which DAG populates this table? Use af dags list and look for matching names. Check DAG status: Is the DAG paused?

## Links

- HTML page: https://omgskills.com/library/astronomer/agents/checking-freshness/
- GitHub: https://github.com/astronomer/agents
- Author: [@astronomer](https://omgskills.com/library/astronomer/index.md)

## More from this repo

- [airflow-adapter](https://omgskills.com/library/astronomer/agents/astro-airflow-mcp/dot-claude/skills/airflow-adapter/index.md) — Airflow adapter pattern for v2/v3 API compatibility.
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 459 stars
- [airflow-plugins](https://omgskills.com/library/astronomer/agents/skills/airflow-plugins/index.md) — Builds Airflow 3.1+ plugins that embed FastAPI apps, custom UI pages, React components, middleware, macros, and...
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 459 stars
- [analyzing-data](https://omgskills.com/library/astronomer/agents/skills/analyzing-data/index.md) — Queries the data warehouse with SQL and answers business questions about data.
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 459 stars