Setup

All Claude skills for investigating and editing Turquoise Health DAGs are available through the sandbox-answers repo. The repo uses git submodules to provide read access to the airflow_dags source code and tq-api-docs documentation.

Prerequisites

• Claude Code CLI installed
• Access to the turquoisehealth/sandbox-answers, turquoisehealth/airflow_dags, and turquoisehealth/tq-api-docs repos

Installation

1. Clone with submodules:

   git clone --recurse-submodules git@github.com:turquoisehealth/sandbox-answers.git
   cd sandbox-answers

2. Install Python dependencies:

   poetry install

3. Configure credentials:

   cp .env.example .env

   Fill in your credentials in .env:

   # Trino connection
   TRINO_HOST=147b7bf44ec44cdd839b486627571030.trino-external.turquoise.health
   TRINO_USERNAME=your_username
   TRINO_PASSWORD=your_password
   TRINO_PORT=443
   
   # Jira API (generate token at https://id.atlassian.com/manage-profile/security/api-tokens)
   JIRA_EMAIL=your_email@turquoisehealth.com
   JIRA_API_TOKEN=your_token

4. Start Claude Code:

   claude

Running Skills

All skills are invoked from the sandbox-answers repo root using slash commands:

# Investigate a question
/questions cld Why is the rate null for payer 388 and code 29826?

# Investigate a Jira ticket
/jira CLD-7

# Run a Trino query
/trino-query SELECT COUNT(*) FROM tq_production.clear_rates_2025_03.clear_rates WHERE payer_id = '388'

# QA a CLD run
/qa-cld-run cld-v2.4.3 path/to/params.json

# Edit DAGs (creates a branch, makes changes, creates a PR)
/edit-dags cld add network from spec at ~/Downloads/new_payers.xlsx
/edit-dags spines create new spine dialysis_center

# Update documentation
/document-skills

Updating Submodules

To pull the latest code and docs:

git submodule update --remote

The airflow_dags submodule tracks the develop branch (not main). The tq-api-docs submodule tracks main.