# analyzing-data

> Claude/Codex skill by [@astronomer](https://omgskills.com/library/astronomer/index.md) · 454 stars · Updated 2026-10-14

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").

Tags: agentic-workflow, agents, ai, ai-agents, airflow, apache-airflow, claude, cursor, dag, data-engineering, data-pipelines, dbt, llm, mcp, orchestrator, skills, workflow-automation, workflow-management, workflow-orchestration, workflows

## Install

```sh
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.

## Links

- HTML page: https://omgskills.com/skills/astronomer/agents/analyzing-data/
- GitHub: https://github.com/astronomer/agents
- Author: [@astronomer](https://omgskills.com/library/astronomer/index.md)

## More from this repo

- [airflow-state-store](https://omgskills.com/skills/astronomer/agents/skills/airflow-state-store/index.md) — Persists task and asset state across retries and DAG runs using Airflow 3.3's AIP-103 key/value stores...
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 456 stars
- [authoring-go-sdk-tasks](https://omgskills.com/skills/astronomer/agents/skills/authoring-go-sdk-tasks/index.md) — Writes Airflow task logic in Go using the Airflow Go SDK.
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 456 stars
- [authoring-java-sdk-tasks](https://omgskills.com/skills/astronomer/agents/skills/authoring-java-sdk-tasks/index.md) — Writes Airflow task logic in Java, Kotlin, or any JVM language using the Airflow Java SDK.
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 456 stars