checking-freshness
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.
Install
With your agent
Install OMGSkills skill "astronomer/agents:checking-freshness" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.
Manual command
git clone https://github.com/astronomer/agents /tmp/agents && ln -s /tmp/agents/skills/checking-freshness ~/.claude/skills/checking-freshnessFrom 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?
More from this repo
airflow-adapter
Airflow adapter pattern for v2/v3 API compatibility.
airflow-plugins
Builds Airflow 3.1+ plugins that embed FastAPI apps, custom UI pages, React components, middleware, macros, and...
analyzing-data
Queries the data warehouse with SQL and answers business questions about data.