cyanluna-git/cyanluna.skills/worklog-sync

Name: worklog-sync
Author: cyanluna-git

Claude Code and agent skill by cyanluna-git/cyanluna.skills

Trust tier 2

community

LLM review pending

Source check pending

Checking that the SKILL.md file is still in the repository.

Sync kanban board tasks to EOB weekly worklogs. Reads completed/in-progress kanban cards, maps them to worklog projects, estimates hours from timestamps, aggregates by day, and submits via the EOB API.

Install

npx vskill@latest install cyanluna-git/cyanluna.skills/worklog-sync

SKILL.md

Overview

Reads kanban board tasks and creates weekly worklog entries in the Engineering Operation Board (EOB). Tasks are aggregated by date + project + work type into one worklog card per group.

Project Classification

Each kanban project has a worklog_type:

type	Behavior
`work`	Maps to an EOB project; worklog created with `project_id`
`non-project`	Worklog created without `project_id` (work type only)
`personal`	Excluded from sync entirely

Project Settings Storage

Primary: Kanban DB project_settings table (via PUT /api/project-settings/:project) Fallback: ~/.claude/worklog-sync.json → project_map (only if the deployed API has not been updated yet)

sql

-- Kanban DB table (auto-created on connection)
CREATE TABLE IF NOT EXISTS project_settings (
  project TEXT PRIMARY KEY,
  worklog_type TEXT NOT NULL DEFAULT 'work',
  eob_project_id TEXT,
  eob_product_line_id TEXT,
  default_work_type_code TEXT DEFAULT 'ENG-SW',
  label TEXT
);

Kanban API for project_settings

bash

KANBAN_API="$BASE_URL"  # from kanban config
 
# List all
curl -s "${AUTH_HEADER[@]}" "$KANBAN_API/api/project-settings"
 
# Get one
curl -s "${AUTH_HEADER[@]}" "$KANBAN_API/api/project-settings/$PROJECT"
 
# Upsert
curl -s "${AUTH_HEADER[@]}" -X PUT "$KANBAN_API/api/project-settings/$PROJECT" \
  -H 'Content-Type: application/json' \
  -d '{"worklog_type":"work","eob_project_id":"<UUID>","default_work_type_code":"ENG-SW","label":"..."}'

If the API returns 404, fall back to project_map in config file. Do not read any local DB directly.

Configuration

~/.claude/worklog-sync.json:

json

{
  "eob_base_url": "https://eob.10.182.252.32.sslip.io",
  "kanban_api": "https://cyanlunakanban.vercel.app",
  "kanban_auth_token": "<X-Kanban-Auth token>",
  "access_token": null,
  "refresh_token": null,
  "user_id": null,
  "project_map": {
    "edwards.oqc.infra": { "worklog_type": "work", "eob_project_id": "ac78d5ae-a15e-4a40-9638-8109539d6633", "default_work_type_code": "ENG-SW", "label": "OQC Digitalization Infrastructure" },
    "unify": { "worklog_type": "work", "eob_project_id": "013c7ee7-edcc-46bc-bcc8-55b15bb2481f", "default_work_type_code": "ENG-SW", "label": "Unify Plasma Single" },
    "edwards.operation.board": { "worklog_type": "non-project", "default_work_type_code": "ENG-SW", "label": "Team DX / Productivity" },
    "testrig-dashboard": { "worklog_type": "non-project", "default_work_type_code": "ENG-SW", "label": "Team Work" },
    "3dx.api": { "worklog_type": "non-project", "default_work_type_code": "ENG-SW", "label": "3DX API (Team Work)" },
    "cpet.db": { "worklog_type": "personal" },
    "cpet": { "worklog_type": "personal" },
    "ai.cycling.workout.planner": { "worklog_type": "personal" },
    "ai-cycling-coach": { "worklog_type": "personal" },
    "unahouse.finance": { "worklog_type": "personal" },
    "today.bike": { "worklog_type": "personal" },
    "asan.bicycle": { "worklog_type": "personal" },
    "cyanluna-portfolio": { "worklog_type": "personal" },
    "cyanluna.skills": { "worklog_type": "personal" },
    "bangwahu": { "worklog_type": "personal" },
    "remotion-video-gen": { "worklog_type": "personal" },
    "type1recovery": { "worklog_type": "personal" },
    "kanban-board": { "worklog_type": "personal" }
  }
}

Commands

`/worklog-sync login` — Authenticate with EOB

Ask user for email and password via AskUserQuestion.

Authenticate:

bash

EOB="https://eob.10.182.252.32.sslip.io"
AUTH=$(curl -s -X POST "$EOB/api/auth/login" \
  -H "Content-Type: application/x-www-form-urlencoded" \
  -d "username=$EMAIL&password=$PASSWORD")

Extract tokens and get user info:

bash

TOKEN=$(echo "$AUTH" | python3 -c "import sys,json; print(json.load(sys.stdin)['access_token'])")
REFRESH=$(echo "$AUTH" | python3 -c "import sys,json; print(json.load(sys.stdin)['refresh_token'])")
 
ME=$(curl -s "$EOB/api/auth/me" -H "Authorization: Bearer $TOKEN")
USER_ID=$(echo "$ME" | python3 -c "import sys,json; print(json.load(sys.stdin)['id'])")

Save to ~/.claude/worklog-sync.json.

`/worklog-sync map` — Configure Project Mapping

Fetch all kanban projects and their current settings:

bash

BOARD=$(curl -s "${AUTH_HEADER[@]}" "$KANBAN_API/api/board")
# board.projects = ["project-a", "project-b", ...]
# board.project_settings = { "project-a": {...}, ... }

Fetch EOB project hierarchy for matching:

bash

PROJECTS=$(curl -s "$EOB/api/projects/hierarchy" -H "Authorization: Bearer $TOKEN")

For each kanban project without settings, ask user via AskUserQuestion:

worklog_type: work / non-project / personal
If work: select EOB project from hierarchy
Default work type code

Save via API:

bash

curl -s "${AUTH_HEADER[@]}" -X PUT "$KANBAN_API/api/project-settings/$PROJECT" \
  -H 'Content-Type: application/json' \
  -d '{"worklog_type": "work", "eob_project_id": "...", "label": "..."}'

`/worklog-sync` — Main Sync Flow

Procedure:

Load auth & refresh token if needed

bash

CONFIG=$(cat ~/.claude/worklog-sync.json)
EOB=...  TOKEN=...  REFRESH=...  USER_ID=...

If token expired, try refresh → if refresh fails, prompt /worklog-sync login.

Determine target week (default: current week Mon–Sun)

bash

TODAY=$(date +%Y-%m-%d)
DOW=$(date -d "$TODAY" +%u)
MONDAY=$(date -d "$TODAY -$((DOW-1)) days" +%Y-%m-%d)
SUNDAY=$(date -d "$MONDAY +6 days" +%Y-%m-%d)

Fetch kanban board

bash

KANBAN_API=$(echo "$CONFIG" | python3 -c "import sys,json; print(json.load(sys.stdin).get('kanban_api','https://cyanlunakanban.vercel.app'))")
KANBAN_TOKEN=$(echo "$CONFIG" | python3 -c "import sys,json; print(json.load(sys.stdin).get('kanban_auth_token',''))")
BOARD=$(curl -s -H "X-Kanban-Auth: $KANBAN_TOKEN" "$KANBAN_API/api/board")

Load project mappings: try board.project_settings first, fall back to config.project_map
Filter out projects where worklog_type == "personal" → skip entirely
Projects not in any mapping → flag as "UNMAPPED" in preview, ask user to classify

Collect tasks relevant for the week

Status done with completed_at within the target week
Status impl, impl_review, test, plan, plan_review with timestamps within the week

Estimate hours from timestamps

Use task lifecycle timestamps to calculate actual work time per day:

`` started_at → planned_at = planning work planned_at → reviewed_at = review + iteration reviewed_at → tested_at = implementation time tested_at → completed_at = testing time started_at → completed_at = total elapsed (fallback) ``

Rules:

Calculate elapsed time between phase timestamps
Cap at 8h per day per task (workday assumption)
If elapsed > 1 day, distribute hours across work days (Mon–Fri) within the range
Minimum: 0.5h per task phase
Round to nearest 0.5h
agent_log timestamps can be used for more granular per-day breakdown

Example:

Task #42: started_at=04/01 09:00, completed_at=04/02 15:00
Elapsed: ~1.25 work days → 04/01: 4h, 04/02: 4h (distribute evenly)

Fetch existing worklogs (duplicate check)

bash

EXISTING=$(curl -s "$EOB/api/worklogs?user_id=$USER_ID&start_date=$MONDAY&end_date=$SUNDAY" \
  -H "Authorization: Bearer $TOKEN")

Skip if same date + project + similar description already exists.

Fetch work type tree (resolve codes to IDs)

bash

WORK_TYPES=$(curl -s "$EOB/api/work-types/tree" -H "Authorization: Bearer $TOKEN")

Aggregate into daily worklog cards

Core rule: same date + same project + same work_type → one worklog card.

Group all task entries by (date, project, work_type_code), then:

hours: Sum of all tasks in the group (cap at 8h per card)
project_id: From project_settings.eob_project_id
work_type_category_id: Resolve code from work type tree
description: Brief list of what was done inside the card

Description format — concise activity log, not individual task dumps: `` 인증 모듈 구현 완료, API 검증 수정, 사이드바 정렬 개선 ``

Each item: short summary (task title condensed to ~15 chars) + 완료/진행 중
Comma-separated, one line
If too many items (>5), summarize: SW 개발 7건 (인증 모듈, API 검증 외 5건)

Daily cap: If a single card exceeds 8h, cap at 8h. Remaining hours are dropped (user can adjust in preview).

Example aggregation: ``` Raw tasks for 02/27, OQC Digitalization, ENG-SW: #37 run.sh 실행 모드 개선 (0.5h) #40 SemiAutoTaskForm (0.5h) #41 TaskSchema parser (0.5h) #42 Edge Runner timeout (0.5h) #44 Gherkin DB 마이그레이션 (0.5h)

→ Aggregated card: date: 2026-02-27 project: OQC Digitalization Infrastructure work_type: ENG-SW hours: 2.5h description: "run.sh 실행모드 개선, SemiAutoTaskForm, TaskSchema parser, Edge Runner timeout, Gherkin DB 마이그레이션 완료" ```

Preview to user

## Worklog Preview: 2026-02-24 ~ 2026-03-01
 
| Date  | Project              | Type        | Hours | Description                                        |
|-------|----------------------|-------------|-------|----------------------------------------------------|
| 02/24 | OQC Digitalization   | ENG-SW      | 1.0h  | DB 도메인 분리 완료                                 |
| 02/24 | Unify Plasma Single  | ENG-SW      | 5.5h  | SQL 통합관리, db-viewer 제거, config manager 생성 외 |
| 02/25 | OQC Digitalization   | ENG-SW      | 2.0h  | FT&CC 카탈로그, Inspection 선택, 자동화 배지 외     |
| 02/25 | OQC Digitalization   | ENG-SW-TST  | 0.5h  | Auto task form 테스트                               |
| 02/27 | OQC Digitalization   | ENG-SW      | 8.0h  | Gherkin Pattern A, Corrective 탭, run.sh 개선 외    |
| 02/27 | Unify Plasma Single  | ENG-SW      | 8.0h  | Config Manager 통합, Metadata Viewer 외             |
 
**Total: 35h / 12 cards** (personal 3건 제외)
 
Proceed? (Enter to confirm, or edit)

User adjusts via AskUserQuestion if needed (hours, project, work type, date, remove).

Submit approved entries

bash

curl -s -X POST "$EOB/api/worklogs" \
  -H "Authorization: Bearer $TOKEN" \
  -H "Content-Type: application/json" \
  -d "{
    \"date\": \"$DATE\",
    \"user_id\": \"$USER_ID\",
    \"project_id\": \"$PROJECT_ID\",
    \"work_type_category_id\": $WTC_ID,
    \"hours\": $HOURS,
    \"description\": \"$DESCRIPTION\"
  }"

Report results

## Sync Complete
Created 3 entries (9h) for 2026-03-30 ~ 2026-04-05. Failed: 0

`/worklog-sync status` — Weekly Summary

Load auth, fetch current week's worklogs:

bash

curl -s "$EOB/api/worklogs?user_id=$USER_ID&start_date=$MONDAY&end_date=$SUNDAY" \
  -H "Authorization: Bearer $TOKEN"

Display:

## Week: 2026-03-30 ~ 2026-04-05
 
| Day | Hours | Entries |
|-----|-------|---------|
| Mon 03/30 | 3.75h | 5 |
| Tue 03/31 | 4.0h | 5 |
| Wed 04/01 | 8.0h | 3 |
| Thu 04/02 | 4.5h | 8 |
| Fri 04/03 | 2.5h | 3 |
| **Total** | **22.75h / 40h** | **24** |

Work Type Quick Reference

Code	Name	When to Use
`ENG-SW`	Software Development	Default for kanban coding tasks
`ENG-SW-COD`	Implementation (Coding)	Specific coding work
`ENG-SW-REQ`	Requirements Analysis	Planning/requirements tasks
`ENG-SW-TST`	Unit Testing	Test writing
`ENG-SW-DBG`	Debugging	Bug fixes
`PRJ-REV`	Review & Approval	Code review tasks
`PRJ-PLN`	Planning & Scheduling	Sprint planning
`MTG-INT`	Internal Meeting	Team meetings
`QMS-QC`	Quality Control	QC-related tasks
`SUP-TKT`	Ticket/Issue Resolution	Support tickets

Task-to-WorkType Inference Rules

When default_work_type_code doesn't cover it, infer from task content:

This is the start of the file. Read the full SKILL.md on GitHub.

Security

Security scanPassed, 93 of 100Pattern checks on the skill's files.
Model reviewNot runA model review is scheduled for the next rescan.

See the full security report

Quality evaluation

Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

See evaluation results

Source

SKILL.md in the repositoryCheckingworklog-sync/SKILL.md

Popularity

Repository stars: 165
Repository forks: 41
7-day trend score: 26

Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

Claude Code
Cursor
GitHub Copilot
Windsurf
Codex
Gemini CLI
Cline
Amp
Roo Code
Goose
Continue
Kilo Code
Junie
Trae
OpenHands
Qwen Code
AI Agent
Tabnine Chat
Sourcegraph Cody
Amazon Q
Firebase Genkit
Sweep
Devin
Phind
Mentat
Claude Desktop
Aider
GPT Pilot
Plandex
bolt.new
v0
Replit Agent
Anse
TypingMind
BetterChatGPT
LibreChat
Warp AI
Pieces
Fig AI

Embed badge

[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/cyanluna-git/cyanluna.skills/worklog-sync/badge)](https://verified-skill.com/skills/cyanluna-git/cyanluna.skills/worklog-sync)

Something wrong with this skill or its page? Tell us.

Install

SKILL.md

Overview

Project Classification

Project Settings Storage

Kanban API for project_settings

Configuration

Commands

/worklog-sync login — Authenticate with EOB

/worklog-sync map — Configure Project Mapping

/worklog-sync — Main Sync Flow

/worklog-sync status — Weekly Summary

Work Type Quick Reference

Task-to-WorkType Inference Rules

Security

Quality evaluation

Source

Popularity

Works with

`/worklog-sync login` — Authenticate with EOB

`/worklog-sync map` — Configure Project Mapping

`/worklog-sync` — Main Sync Flow

`/worklog-sync status` — Weekly Summary