sql-reporting

sql-reporting is a skill for Claude Code, Codex from apache/airflow. It costs 34 tokens per session (316 once invoked), scanned A, original, Apache-2.0.

A set of rules and review steps for writing analytics SQL, the language used to query data warehouses and build reports.

In plain words
What is it for?
Use it when querying warehouse tables, combining data, counting or summing rows, or producing metrics for reports and dashboards.
Why use it?
It helps prevent expensive or overly broad queries and makes report SQL easier to check for correctness and consistency.

Skill for Claude CodeCodex ✓ vendor

Written for no agent in particular: nothing here depends on one.

Good fit Use it when querying warehouse tables, combining data, counting or summing rows, or producing metrics for reports and dashboards.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/apache/airflow/sql-reporting
About the project

Apache Airflow is a platform for defining, scheduling, and monitoring workflows as code, with a scheduler assigning dependent tasks to workers. Teams use it to orchestrate automated data and software pipelines and inspect their progress through a user interface. Its catalogue skills and instructions help agents work with Airflow.

apache/airflow · 47,236 stars · on GitHub · airflow.apache.org

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add apache/airflow --skill sql-reporting
Clone the repo
git clone --depth 1 https://github.com/apache/airflow

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for sql-reporting

README.md
[![agentmods](https://agentmods.dev/badge/skills/apache/airflow/sql-reporting/github.svg)](https://agentmods.dev/skills/apache/airflow/sql-reporting)
Your own site
<a href="https://agentmods.dev/skills/apache/airflow/sql-reporting"><img src="https://agentmods.dev/badge/skills/apache/airflow/sql-reporting/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for sql-reporting

Your own site · 80×15
<a href="https://agentmods.dev/skills/apache/airflow/sql-reporting"><img src="https://agentmods.dev/badge/skills/apache/airflow/sql-reporting.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 34 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 316 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe. Third-party audits
  • Snyk pass 7 Sept 2026
  • NVIDIA SkillSpector pass 7 Sept 2026
How audits are shown
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00034 $0.00316
Opus 5.5 $0.00014 $0.00126
Sonnet 5.5 $0.00007 $0.00063
Haiku 4.5 $0.00003 $0.00032

Measured 1mo ago against content hash 2a3c0b7ba27d, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

sql-reporting scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 1mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

providers/common/ai/src/airflow/providers/common/ai/example_dags/skills/sql-reporting/SKILL.md · 42 lines

What it actually says

SQL Reporting Skill

Apply this skill before writing or running any analytics SQL so reports stay consistent and safe.

When to Use This Skill

Use this skill when the task involves:

  • Querying warehouse tables for a metric, report, or dashboard figure
  • Aggregating rows (counts, sums, rolling windows)
  • Cross-referencing two or more tables

Conventions

  1. Always SELECT explicit column names, never SELECT *.
  2. Filter on a partition/date column first to bound the scan.
  3. Alias aggregates with snake_case names (order_count, not count(*)).
  4. Cap exploratory queries with LIMIT unless an aggregate already collapses the result set.
  5. Prefer COUNT(DISTINCT ...) over a sub-query when de-duplicating.

Review Checklist (run before returning an answer)

  • No SELECT *.
  • A date or partition predicate is present.
  • Every aggregate has an explicit alias.
  • The query reads only from tables the task actually needs.

Output Format

Return the final SQL in a fenced ```sql block, then one sentence describing what the query returns.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 1mo ago First seen · 42 lines · 34 tokens per session scan A 2a3c0b7ba27d

Subscribe to this mod's changes

sql-reporting is a skill published in the GitHub repository apache/airflow (47,236 stars, last pushed today), licensed Apache-2.0. It adds 34 tokens to every session and 316 once invoked, about $0.0001 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

airflow-workflow

Execution guide for Airflow scheduled jobs — troubleshooting, updating, connid conventions, and cron references.

Datus-ai/Datus-agent · 24 tokens

schema-exploration

Lists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in a database. Use when the user asks about database schema, table structure, column types, what tables exist, ERD, foreign keys, or how entities relate.

langchain-ai/deepagents · 57 tokens

deepagents-thread-inspector

Inspect and explain conversations in the local Deep Agents Code SQLite session store. Use to look up the current thread's title or name, as a fallback when LangSmith trace tooling is unavailable, for offline or untraced sessions, or when asked to identify or summarize a local dcode thread, inspect checkpoint metadata…

langchain-ai/deepagents · 93 tokens

query-writing

Writes and executes SQL queries from simple SELECTs to complex multi-table JOINs, aggregations, and subqueries. Use when the user asks to query a database, write SQL, run a SELECT statement, retrieve data, filter records, or generate reports from database tables.

langchain-ai/deepagents · 57 tokens

stripe-projects

Use when the user wants to provision infrastructure or third-party services using Stripe Projects. Triggers: "I need a database", "set up auth", "add caching", "give me a Postgres", "provision Redis", "I need hosting", "add a vector DB", "get me an API key for X", "get credentials for X", "sign up for a service", "set…

stripe/ai · 213 tokens

ontology-core

A command-line tool for managing and querying Business Knowledge Networks, data sources, data views, and platform monitoring resources.

UnicomAI/wanwu · 199 tokens