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
With your agent
Install OMGSkills skill "astronomer/agents:profiling-tables" 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/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-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.