Pp Airflow Admin

<!-- GENERATED FILE — DO NOT EDIT.
     This file is a verbatim mirror of library/developer-tools/airflow-admin/SKILL.md,
     regenerated post-merge by tools/generate-skills/. Hand-edits here are
     silently overwritten on the next regen. Edit the library/ source instead.
     See the repository agent guide, section "Generated artifacts: registry.json, cli-skills/". -->

Airflow Admin — Printing Press CLI

Prerequisites: Install the CLI

This skill drives the airflow-admin-pp-cli binary. You must verify the CLI is installed before invoking any command from this skill. If it is missing, install it first:

1. Install via the Printing Press installer:

   npx -y @mvanhorn/printing-press-library install airflow-admin --cli-only

2. Verify: airflow-admin-pp-cli --version
3. Ensure $GOPATH/bin (or $HOME/go/bin) is on $PATH.

If the npx install fails (no Node, offline, etc.), fall back to a direct Go install (requires Go 1.26.6 or newer):

go install github.com/mvanhorn/printing-press-library/library/developer-tools/airflow-admin/cmd/airflow-admin-pp-cli@latest

If --version reports "command not found" after install, the install step did not put the binary on $PATH. Do not proceed with skill commands until verification succeeds.

Apache Airflow is a workflow orchestrator used by data teams to schedule and monitor data pipelines. Data engineers usually model each pipeline as a DAG, then watch DAG runs, task instances, retries, pools, and scheduler health to understand whether daily loads, API extracts, dbt jobs, reports, and other data workflows are running correctly.

Use this skill when a user needs an operational readout from Airflow: list DAGs, inspect failed DAG runs, check task instance status, review pools, verify API health, or sync/search Airflow metadata locally. The CLI is read-first and intended for investigation, triage, and reporting. Avoid implying that it deploys DAGs, edits schedules, clears tasks, or mutates Airflow state.

Common Airflow Workflows

Local Airflow auth

For a local Airflow webserver at http://localhost:8080, get a token and store it:

airflow-admin-pp-cli apache-airflow-admin-auth --username airflow --password airflow --json
airflow-admin-pp-cli auth set-token <access_token>
airflow-admin-pp-cli doctor --json

For a remote Airflow environment, set the base URL first:

export AIRFLOW_ADMIN_BASE_URL="https://airflow.example.com"
export AIRFLOW_ADMIN_BEARER_AUTH="<access_token>"

Never ask the user to paste Airflow credentials into a repository, issue, PR, or shared log.

Pipeline health triage

Start broad, then drill down:

airflow-admin-pp-cli monitor --agent
airflow-admin-pp-cli dags list --agent --select dag_id,is_active,is_paused,last_parsed_time
airflow-admin-pp-cli dags dag-runs list <dag_id> --state failed --agent --select dag_id,dag_run_id,state,start_date,end_date
airflow-admin-pp-cli dags dag-runs list-task-instances <dag_id> <dag_run_id> --state failed --agent --select task_id,state,try_number,start_date,end_date

Local search and analysis

When a user wants repeated investigation without paging the Airflow API each time:

airflow-admin-pp-cli sync --resources dags,pools --agent
airflow-admin-pp-cli search "failed" --data-source local --agent --limit 20
airflow-admin-pp-cli analytics count --type dag-runs --agent

Command Reference

apache-airflow-admin-auth — Manage apache airflow admin auth

• airflow-admin-pp-cli apache-airflow-admin-auth — Authenticate with an Airflow username and password and return a JWT access token.

apache-airflow-admin-version — Manage apache airflow admin version

• airflow-admin-pp-cli apache-airflow-admin-version — Get Airflow version

connections — Airflow connection metadata.

• airflow-admin-pp-cli connections — List connections

dags — DAG inventory and metadata.

• airflow-admin-pp-cli dags get — Get DAG
• airflow-admin-pp-cli dags list — List DAGs
• airflow-admin-pp-cli dags dag-runs list — List DAG runs
• airflow-admin-pp-cli dags dag-runs get — Get DAG run
• airflow-admin-pp-cli dags dag-runs list-task-instances — List task instances
• airflow-admin-pp-cli dags dag-runs get-task-instance — Get task instance
• airflow-admin-pp-cli dags tasks list — List DAG tasks
• airflow-admin-pp-cli dags details — Get detailed DAG metadata

monitor — Manage monitor

• airflow-admin-pp-cli monitor — Get health

pools — Airflow pool capacity and occupancy.

• airflow-admin-pp-cli pools get — Get pool
• airflow-admin-pp-cli pools list — List pools

variables — Airflow variable metadata.

• airflow-admin-pp-cli variables — List variables

Finding the right command

When you know what you want to do but not which command does it, ask the CLI directly:

airflow-admin-pp-cli which "<capability in your own words>"

which resolves a natural-language capability query to the best matching command from this CLI's curated feature index. Exit code 0 means at least one match; exit code 2 means no confident match — fall back to --help or use a narrower query.

Auth Setup

Airflow JWT tokens can be created through the API token endpoint when the Airflow environment allows username/password auth:

airflow-admin-pp-cli apache-airflow-admin-auth --username <username> --password <password> --json

Store the returned access_token:

airflow-admin-pp-cli auth set-token YOUR_TOKEN_HERE

Or set AIRFLOW_ADMIN_BEARER_AUTH as an environment variable. Set AIRFLOW_ADMIN_BASE_URL when the Airflow webserver is not http://localhost:8080.

Run airflow-admin-pp-cli doctor to verify setup.

Agent Mode

Add --agent to any command. Expands to: --json --compact --no-input --no-color --yes.

• Pipeable — JSON on stdout, errors on stderr

• Filterable — --select keeps a subset of fields. Dotted paths descend into nested structures; arrays traverse element-wise. Critical for keeping context small on verbose APIs:

  airflow-admin-pp-cli apache-airflow-admin-version --agent --select id,name,status

• Previewable — --dry-run shows the request without sending

• Offline-friendly — sync/search commands can use the local SQLite store when available

• Non-interactive — never prompts, every input is a flag

• Explicit retries — use --idempotent only when an already-existing create should count as success