miptah21

Reference and apply design system specifications from the VoltAgent awesome-design-md collection (Stripe, Linear, Vercel, Notion, etc.). Use this skill to initialize DESIGN.md in the project root or audit/format UI styling decisions.

Use when the user needs human-in-the-loop workflows in Airflow (approval/reject, form input, or human-driven branching). Covers ApprovalOperator, HITLOperator, HITLBranchOperator, HITLEntryOperator. Requires Airflow 3.1+. Does not cover AI/LLM calls (see airflow-ai).

Queries, manages, and troubleshoots Apache Airflow using the af CLI. Covers listing DAGs, triggering runs, reading task logs, diagnosing failures, debugging DAG import errors, checking connections, variables, pools, and monitoring health. Also routes to sub-skills for writing DAGs, debugging, deploying, and migrating Airflow 2 to 3. Use when user mentions "Airflow", "DAG", "DAG run", "task log", "import error", "parse error", "broken DAG", or asks to "trigger a pipeline", "debug import errors", "check Airflow health", "list connections", "retry a run", or any Airflow operation. Do NOT use for warehouse/SQL analytics on Airflow metadata tables — use analyzing-data instead.

Queries data warehouse and answers business questions about data. Handles questions requiring database/warehouse queries including "who uses X", "how many Y", "show me Z", "find customers", "what is the count", data lookups, metrics, trends, or SQL analysis.

Annotate Airflow tasks with data lineage using inlets and outlets. Use when the user wants to add lineage metadata to tasks, specify input/output datasets, or enable lineage tracking for operators without built-in OpenLineage extraction.

Define reusable Airflow task group templates with Pydantic validation and compose DAGs from YAML. Use when creating blueprint templates, composing DAGs from YAML, validating configurations, or enabling no-code DAG authoring for non-engineers.

Pragmatic coding standards - concise, direct, no over-engineering, no unnecessary comments

Use when turning a dbt Core project into an Airflow DAG/TaskGroup using Astronomer Cosmos. Does not cover dbt Fusion. Before implementing, verify dbt engine, warehouse, Airflow version, execution environment, DAG vs TaskGroup, and manifest availability.

Creating algorithmic art using p5.js with seeded randomness and interactive parameter exploration. Use this when users request creating art using code, generative art, algorithmic art, flow fields, or particle systems. Create original algorithmic art rather than copying existing artists' work to avoid copyright violations.

Use this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation.

Use when working with Payload CMS projects (payload.config.ts, collections, fields, hooks, access control, Payload API). Use when debugging validation errors, security issues, relationship queries, transactions, or hook behavior.

Use this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill.

Surgical code refactoring to improve maintainability without changing behavior. Covers extracting functions, renaming variables, breaking down god functions, improving type safety, eliminating code smells, and applying design patterns. Less drastic than repo-rebuilder; use for gradual improvements.

Search Engine Optimization specialist for content strategy, technical SEO, keyword research, and ranking improvements. Use when optimizing website content, improving search rankings, conducting keyword analysis, or implementing SEO best practices. Expert in on-page SEO, meta tags, schema markup, and Core Web Vitals.

Toolkit for interacting with and testing local web applications using Playwright. Supports verifying frontend functionality, debugging UI behavior, capturing browser screenshots, and viewing browser logs.

Create, manage, and cleanup git worktrees with Claude Code agents across all projects. USE THIS SKILL when user says "create worktree", "spin up worktrees", "new worktree for X", "worktree status", "cleanup worktrees", "sync worktrees", or wants parallel development branches. Also use when creating PRs from a worktree branch (to update registry with PR number). Handles worktree creation, dependency installation, validation, agent launching in Ghostty, and global registry management.

Specialized skill for optimizing cloud data INFRASTRUCTURE costs and resource utilization at the platform level. Use when: rightsizing warehouses, configuring auto-suspend policies, optimizing storage formats, setting budget alerts, or forecasting cloud spend. Do NOT use for query-level cost analysis — use `finding-expensive-queries` instead. Do NOT use for optimizing individual SQL queries — use `optimizing-query-text` or `optimizing-query-by-id` instead.

Specialized skill for data contracts, access controls, compliance, and PII handling. Use when: implementing RBAC/RLS policies, defining data contracts between producers and consumers, handling PII/PHI masking, GDPR/CCPA compliance, or managing data ownership. Do NOT use for dbt model documentation — use `documenting-dbt-models` instead. Do NOT use for data lineage tracing — use `tracing-upstream-lineage` or `tracing-downstream-lineage` instead.

Specialized skill for establishing and monitoring data quality at the INFRASTRUCTURE level. Use when: setting up Great Expectations suites, Soda checks, custom SQL quality monitors, schema drift detection, or anomaly detection logic. Do NOT use for dbt-specific tests — use `testing-dbt-models` instead. Do NOT use for data freshness spot-checks — use `checking-freshness` instead.

General pipeline orchestration for NON-Airflow tools (Dagster, Prefect, custom schedulers). Use when: the user mentions Dagster, Prefect, Luigi, or custom pipeline orchestration. Do NOT use for Airflow — use `airflow` or `authoring-dags` instead. Do NOT use for dbt — use `creating-dbt-models` or `developing-incremental-models` instead.

Cross-system incident response and post-mortem Root Cause Analysis for data platforms. Use when: investigating MULTI-system failures, correlating failures across infra + data + code, writing post-mortem reports, or diagnosing cascading failures. Do NOT use for single Airflow DAG failures — use `debugging-dags` instead. Do NOT use for single dbt model errors — use `debugging-dbt-errors` instead.

Create, manage, and cleanup git worktrees with Claude Code agents across all projects. USE THIS SKILL when user says "create worktree", "spin up worktrees", "new worktree for X", "worktree status", "cleanup worktrees", "sync worktrees", or wants parallel development branches. Also use when creating PRs from a worktree branch (to update registry with PR number). Handles worktree creation, dependency installation, validation, agent launching in Ghostty, and global registry management.