# 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/library/astronomer/agents/analyzing-data/
- GitHub: https://github.com/astronomer/agents
- Author: [@astronomer](https://omgskills.com/library/astronomer/index.md)

## More from this repo

- [airflow-adapter](https://omgskills.com/library/astronomer/agents/astro-airflow-mcp/dot-claude/skills/airflow-adapter/index.md) — Airflow adapter pattern for v2/v3 API compatibility.
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 459 stars
- [airflow-plugins](https://omgskills.com/library/astronomer/agents/skills/airflow-plugins/index.md) — Builds Airflow 3.1+ plugins that embed FastAPI apps, custom UI pages, React components, middleware, macros, and...
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 459 stars
- [analyzing-data](https://omgskills.com/library/astronomer/agents/skills/analyzing-data/index.md) — Queries the data warehouse with SQL and answers business questions about data.
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 459 stars