warehouse-init
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.
Install
With your agent
Install OMGSkills skill "astronomer/agents:warehouse-init" 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/warehouse-init ~/.claude/skills/warehouse-initFrom 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]).
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.