Download for macOS
Skill

warehouse-init

@astronomer Updated 2026-10-14

Initialize warehouse schema discovery. Generates .astro/warehouse.md with all table metadata for instant lookups. Run once per project, refresh when schema changes. Use when user says "/astronomer-data:warehouse-init" or asks to set up data discovery.

agentic-workflowagentsaiai-agentsairflowapache-airflowclaudecursor

Install

git clone https://github.com/astronomer/agents /tmp/agents && ln -s /tmp/agents/skills/warehouse-init ~/.claude/skills/warehouse-init

From README

Initialize Warehouse Schema Generate a comprehensive, user-editable schema reference file for the data warehouse. Scripts: ../analyzing-data/scripts/ — All CLI commands below are relative to the analyzing-data skill's directory. Before running any scripts/cli.py command, cd to ../analyzing-data/ relative to this file. What This Does Discovers all databases, schemas, tables, and columns from the warehouse Enriches with codebase context (dbt models, gusty SQL, schema docs) Records row counts and identifies large tables Generates .astro/warehouse.md - a version-controllable, team-shareable reference Enables instant concept→table lookups without warehouse queries Process Step 1: Read Warehouse Configuration Get the list of databases to discover (e.g., databases: [HQ, ANALYTICS, RAW]).