analyzing-data
Queries the data warehouse with SQL and answers business questions about data. Use when answering anything that needs warehouse data - counts, metrics, trends, aggregations, joins across tables, data lookups, or ad-hoc SQL analysis (for example "who uses X", "how many Y", "show me Z", "find customers", "what is the count").
Install
git clone https://github.com/astronomer/agents /tmp/agents && ln -s /tmp/agents/skills/analyzing-data ~/.claude/skills/analyzing-data
From README
Data Analysis Answer business questions by querying the data warehouse. The kernel auto-starts on first exec call. All CLI commands below are relative to this skill's directory. Before running any scripts/cli.py command, cd to the directory containing this file. Workflow Pattern lookup — Check for a cached query strategy: If a pattern exists, follow its strategy. Record the outcome after executing: Concept lookup — Find known table mappings: Table discovery — If cache misses, search the codebase (Grep pattern=" " glob="/.sql") or query INFORMATIONSCHEMA. See reference/discovery-warehouse.md. Execute query: Cache learnings — Always cache before presenting results: Present findings to user. Kernel Functions | Function | Returns | |----------|---------| | runsql(query, limit=100) | Polars DataFrame | | runsqlpandas(query, limit=100) | Pandas DataFrame | | runsqlmany(queries, limit=100) | List of Polars DataFrames (one per query) | pl (Polars) and pd (Pandas) are pre-imported.
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.
