profiling-tables
Deep-dive data profiling for a specific table. Use when the user asks to profile a table, wants statistics about a dataset, asks about data quality, or needs to understand a table's structure and content. Requires a table name.
Install
git clone https://github.com/astronomer/agents /tmp/agents && ln -s /tmp/agents/skills/profiling-tables ~/.claude/skills/profiling-tablesFrom README
Data Profile Generate a comprehensive profile of a table that a new team member could use to understand the data. Step 1: Basic Metadata Query column metadata: If the table name isn't fully qualified, search INFORMATIONSCHEMA.TABLES to locate it first. Step 2: Size and Shape Run via runsql: Step 3: Column-Level Statistics For each column, gather appropriate statistics based on data type: Numeric Columns String Columns Date/Timestamp Columns Step 4: Cardinality Analysis For columns that look like categorical/dimension keys: This reveals: High-cardinality columns (likely IDs or unique values) Low-cardinality columns (likely categories or status fields) Skewed distributions (one value dominates) Step 5: Sample Data Get representative rows: If the table is large and you want variety, sample from different time periods or categories. Step 6: Data Quality Assessment Summarize quality across dimensions: Completeness Which columns have NULLs? What percentage?
More from this repo
airflow-state-store
Persists task and asset state across retries and DAG runs using Airflow 3.3's AIP-103 key/value stores...
authoring-go-sdk-tasks
Writes Airflow task logic in Go using the Airflow Go SDK.
authoring-java-sdk-tasks
Writes Airflow task logic in Java, Kotlin, or any JVM language using the Airflow Java SDK.