GitHub Actions　✕　Claude CodeのスキルでGitHub Projectsからプロジェクトの進捗状況を取得・分析してSlackに通知してみた

.claude/
└── skills
    └── check-pbi-progress
        ├── scripts
        │   ├── diff.py
        │   └── fetch_progress.sh
        └── SKILL.md

---
name: check-pbi-progress
description: 各PBIの進捗状況をチェックするスキル
disable-model-invocation: true
user-invocable: true
allowed-tools: 
  - Bash(date +%Y_%m_%d)
  - Read
  - Grep
---

## Context
- 本日の日付: !`date +%Y_%m_%d`

## Your Task

### 1.シェルスクリプトを実行し、プロジェクトの進捗状況ファイルを取得する

- `bash ${CLAUDE_SKILL_DIR}/scripts/fetch_progress.sh $ARGUMENTS[0] $ARGUMENTS[1]` を実行する
- 作成された進捗状況ファイルは`progress report created: "/foo/bar/github-user/project/iteration/yyyy_mm_dd_pbi_progress.json"`のような形式で出力されるので、このファイルパスを取得する。


### 2.前回取得した進捗状況ファイルと今回取得した進捗状況ファイルを比較する

- 先程取得した進捗状況ファイルと同じディレクトリから前回保存した進捗状況ファイルを探す
- スプリントの初日などは前回保存した進捗状況ファイルが存在しないので、その場合は処理を終了する
- 以下のコマンドを実行して進捗状況の差分を取得
    `uv run ${CLAUDE_SKILL_DIR}/scripts/diff.py  <本日の進捗状況ファイル> <前回保存した進捗状況ファイル>`
- 取得した比較結果をターミナルの表示に最適化したフォーマットで見やすく表示する

### 3.進捗状況について報告
- 今日の進捗状況と前回の進捗状況を比較して、どのPBIが完了したか、どのPBIが遅れているかを要約
- "due Date"が変更されている場合は変更内容についても報告する
    - 土日は稼働しないのでその点を考慮する
    - 日本の祝日は日本のメンバーが稼働しないため、レビューや仕様確認が停滞することも考慮する

## Output
以下の形式で結果を出力する
```json
{"result":"<報告内容>"}
```

## Context
- 本日の日付: !`date +%Y_%m_%d`

#!/bin/bash

set -eu

SCRIPT_DIR="$(cd "$(dirname "$0")" && pwd)"
OWNER="${1:?Usage: $0 <owner> <project_number>}"
PROJECT_NUMBER="${2:?Usage: $0 <owner> <project_number>}"

# === Iteration一覧を取得 ===
ITERATIONS=$(gh api graphql -f query="
{
  user(login: \"${OWNER}\") {
    projectV2(number: ${PROJECT_NUMBER}) {
      field(name: \"Sprint\") {
        ... on ProjectV2IterationField {
          configuration {
            iterations {
              id
              title
              startDate
              duration
            }
          }
        }
      }
    }
  }
}")

# 現在のスプリントの取得
CURRENT_SPRINT=$(echo "$ITERATIONS" | jq -r "
  .data.user.projectV2.field.configuration.iterations[] |
  .startDate as \$start |
  .duration as \$dur |
  (now | strftime(\"%Y-%m-%d\")) as \$today |
  (\$start | strptime(\"%Y-%m-%d\") | mktime + (\$dur * 86400) | strftime(\"%Y-%m-%d\")) as \$end |
  select(\$today >= \$start and \$today <= \$end) |
  .title
")

CURRENT_SPRINT_DIR_NAME=$(echo "${CURRENT_SPRINT}" | tr '[:upper:]' '[:lower:]' | sed 's/ //g')
TODAY=$(date +%Y_%m_%d)
OUTPUT_DIR=$(dirname "${SCRIPT_DIR}")/output/${OWNER}/${PROJECT_NUMBER}

if [ ! -d "${OUTPUT_DIR}" ]; then
  mkdir -p "${OUTPUT_DIR}"
fi

if [ ! -d "${OUTPUT_DIR}/${CURRENT_SPRINT_DIR_NAME}" ]; then
  mkdir -p "${OUTPUT_DIR}/${CURRENT_SPRINT_DIR_NAME}"
fi


OUTPUT_FILE_NAME="${OUTPUT_DIR}/${CURRENT_SPRINT_DIR_NAME}/${TODAY}_pbi_progress.json"
gh project item-list --owner "${OWNER}" "${PROJECT_NUMBER}" --query "sprint:\"${CURRENT_SPRINT}\"" --format json --limit 100  \
  | jq '[.items[] |  {number: .content.number, title: .title, status: .status, "due Date": ."due Date", "start Date": ."start Date"}]' \
  > "${OUTPUT_FILE_NAME}"

echo "progress report created: \"${OUTPUT_FILE_NAME}\""

# /// script
# requires-python = ">=3.11"
# dependencies = [
#     "deepdiff",
#     "tabulate",
# ]
# ///

import argparse
import json
import sys
from deepdiff import DeepDiff
from tabulate import tabulate


def flatten_diff(diff):
    rows = []
    type_map = {
        "values_changed":         ("changed",  True),
        "dictionary_item_added":  ("added",    False),
        "dictionary_item_removed":("removed",  False),
        "iterable_item_added":    ("added",    False),
        "iterable_item_removed":  ("removed",  False),
        "type_changes":           ("type_changed", True),
    }

    for key, (label, has_old_new) in type_map.items():
        items = diff.get(key, {})
        for path, value in items.items():
            if has_old_new:
                rows.append([label, path, value.get("old_value", ""), value.get("new_value", "")])
            elif "added" in label:
                rows.append([label, path, "-", value])
            else:
                rows.append([label, path, value, "-"])

    return rows


def main():
    parser = argparse.ArgumentParser(description="JSON diff in table format")
    parser.add_argument("file1", help="Old JSON file")
    parser.add_argument("file2", help="New JSON file")
    parser.add_argument("--format", default="grid",
                        choices=["grid", "github", "pipe", "tsv", "csv", "plain"],
                        help="Table format (default: grid)")
    args = parser.parse_args()

    with open(args.file1) as f:
        old = json.load(f)
    with open(args.file2) as f:
        new = json.load(f)

    diff = DeepDiff(old, new, verbose_level=2)

    if not diff:
        print("No differences found.")
        sys.exit(0)

    rows = flatten_diff(diff)
    print(tabulate(rows, headers=["Type", "Path", "Old", "New"], tablefmt=args.format))


if __name__ == "__main__":
    main()

name: Project Daily Report
permissions:
  id-token: write
  contents: read
on:
  workflow_dispatch:
  schedule:
    - cron: '0 1 * * 1-5'	#JST 10:00に実行　※15時以降にするとUTCとJSTで日付が変わってしまうので注意
jobs:
  report:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout
        uses: actions/checkout@v6

      - uses: actions/setup-python@v6
        with:
          python-version: "3.11"

      - name: Setup uv
        uses: astral-sh/setup-uv@v7

      - name: Configure AWS credentials
        uses: aws-actions/configure-aws-credentials@v4
        with:
          role-to-assume: ${{ vars.AWS_ROLE_ARN }}
          aws-region: us-east-1

      - name: Download previous report
        run: |
          aws s3 sync s3://${{ vars.REPORT_BUCKET_NAME }}/${{ github.repository_owner }} .claude/skills/check-pbi-progress/output/${{ github.repository_owner }}

      - name: Run Claude Skill
        id: claude
        uses: anthropics/claude-code-action@v1
        with:
          use_bedrock: true
          github_token: ${{ secrets.GITHUB_TOKEN }}
          # show_full_output: true
          prompt: |
            /check-pbi-progress ${{ github.repository_owner }} ${{ vars.PROJECT_NUMBER }}
          claude_args: |
            --max-turns 20
            --allowed-tools Read,Bash
            --json-schema '{"type":"object","properties":{"result":{"type":"string"}},"required":["result"]}'

      - name: Process results
        run: echo "${RESULT}"
        env:
          RESULT: ${{ fromJSON(steps.claude.outputs.structured_output).result }}

      - name: Prepare Slack message
        id: slack_msg
        run: |
          {
            echo 'text<<DELIM'
            echo '```'
            echo "$RESULT"
            echo '```'
            echo DELIM
          } >> "$GITHUB_OUTPUT"
        env:
          RESULT: ${{ fromJSON(steps.claude.outputs.structured_output).result }}

      - name: Send Report
        uses: slackapi/slack-github-action@v3.0.1
        with:
          webhook: ${{ secrets.SLACK_WEBHOOK_URL }}
          webhook-type: incoming-webhook
          payload: |
            {"text": ${{ toJSON(steps.slack_msg.outputs.text) }}}

      - name: Upload report
        run: |
          aws s3 sync .claude/skills/check-pbi-progress/output/${{ github.repository_owner }} s3://${{ vars.REPORT_BUCKET_NAME }}/${{ github.repository_owner }}

- name: Run Claude Skill
  id: claude
  uses: anthropics/claude-code-action@v1
  with:
    use_bedrock: true
    github_token: ${{ secrets.GITHUB_TOKEN }}
    # show_full_output: true
    prompt: |
      /check-pbi-progress ${{ github.repository_owner }} ${{ vars.PROJECT_NUMBER }}
    claude_args: |
      --max-turns 20
      --allowed-tools Read,Bash
      --json-schema '{"type":"object","properties":{"result":{"type":"string"}},"required":["result"]}'

- name: Prepare Slack message
  id: slack_msg
  run: |
    {
      echo 'text<<DELIM'
      echo '```'
      echo "$RESULT"
      echo '```'
      echo DELIM
    } >> "$GITHUB_OUTPUT"
  env:
    RESULT: ${{ fromJSON(steps.claude.outputs.structured_output).result }}

- name: Send Report
  uses: slackapi/slack-github-action@v3.0.1
  with:
    webhook: ${{ secrets.SLACK_WEBHOOK_URL }}
    webhook-type: incoming-webhook
    payload: |
      {"text": ${{ toJSON(steps.slack_msg.outputs.text) }}}