Claude Skills Overview

Claude skills for investigating and editing Turquoise Health Airflow DAGs, available through the sandbox-answers repo.

For setup instructions, see the Setup Guide.

Question Answering & Investigation

These skills help you understand the codebase, investigate issues, and query data. If a question leads to a code change, /questions can invoke /edit-dags to make the fix, commit, and create a PR. If triggered from a Jira ticket, the answer is automatically posted back as a comment.

Skill	Usage	Description
/jira	/jira <issue key or URL>	Fetch a Jira issue and investigate it; posts the answer back as a Jira comment
/questions	/questions [cld|spines|consumer] <question>	Investigate a question by searching code, docs, and Trino; can apply code changes and post to Jira
/trino-query	/trino-query <SQL>	Run a Trino SQL query and return the results
/generate-report	/generate-report <product> <type> <version> [old_version]	Generate a QA report (consistency, accuracy, or PR-based QA)

DAG Editing

These skills modify airflow DAG source code in the airflow_dags submodule. Start with /edit-dags which creates a branch off develop, routes to the right sub-skill, and creates a PR when done.

CLD (Clear Rates)

CLD edits are version-based — you'll be asked to specify the CLD version (e.g. v2.4.3) for branch naming.

Skill	Usage	Description
/add-codes	/add-codes <spec.xlsx>	Add billing codes to CLD codeset SQL files
/add-network	/add-network <spec.xlsx>	Add payer networks (payer.sql, network_mappings.py, plan bridge)
/add-provider-type	/add-provider-type <name>	Scaffold a new provider type into the CLD sub-DAG
/chunkify-task	/chunkify-task <module> <function>	Parallelize a task into chunk+union pattern
/modify-chunking	/modify-chunking <module> <function> [--provider-type-chunks]	Modify chunking strategy (e.g. add provider_type as a chunking dimension)

Spines

Skill	Usage	Description
/create-new-spine	/create-new-spine <name>	Scaffold a new provider spine DAG

Apps

Create and deploy interactive data apps to the sandbox-apps Heroku server. Apps are static HTML/JS with optional Trino database access via a server-side API endpoint.

Skill	Usage	Description
/create-app	/create-app <name> <category> [description] [from <source>]	Create an app in sandbox-apps, add MDX redirect page, update sidebar

How it works

1. /create-app scaffolds (or copies) an app into sandbox-apps/static/apps/<name>/
2. Creates an MDX redirect page in tq-api-docs/sandbox/docs/misc/apps/
3. Updates sidebars.ts to add the app under the specified category (Clear Rates, Consumer, etc.)
4. Commits and pushes to sandbox-apps — deploy to Heroku with git push heroku main

Apps are protected by zero-trust access control (e.g., Cloudflare Access).

Example

/create-app apr-drg-xwalks "Clear Rates" "APR-DRG crosswalk bias analysis" from reports/clear_rates/apr_drg_and_eapg_xwalks/app/