# Projects Index
AI Summary
Purpose:
- Index for ai/wiki/projects: the durable, AI-facing source docs for work and
personal engineering projects.
Key points:
- Each entry below links to one project doc with purpose, problems, approach,
decisions, tech, and status.
- These overlap with human/portfolio (Korean showcase) but are the AI-facing
sources.
Relevant when:
- Looking for the right project doc before diving in.
Do not read full document unless:
- You need this section index.
Linked documents:
- ai/wiki/index.md
Entries
| Name | File | One line |
|---|---|---|
| 2026 Career Transition | [[2026-career-transition.md]] | Active job-search context, public resume/portfolio URLs, and separate Remember Data Engineer / Toss Payments Data Engineer application strategies with evidence boundaries. |
| 2026 Active Job Shortlist | [[2026-active-job-shortlist.md]] | Current apply/hold decisions after role-fit, posting-status, finance, welfare, and culture checks; SOCAR Platform Engineer (DBA) is the 2026-08-04 priority. |
| CI/CD AI Review Kit | [[ci-cd-ai-review-kit.md]] | Central Bitbucket bootstrap kit with secret-scan-before-AI, full-SHA pinning, profile tests, and spec.md-driven crawler data-format checks; current use is confirmed, quantitative adoption metrics are not. |
| BTS (Binlog Transfer System CDC) | [[bts.md]] | Production batch CDC sends ROW-format binlog files to customer environments; a Go Updater parses events offline, handles MySQL 8.4 ZSTD payloads, and applies parameterized SQL. Separate event-level Python Collector work remains design/PoC evidence. |
| Distribution DB | [[distribution-db.md]] | DIST DB instance separation (FILE COMPONENT vs other) for binlog-shipping health, plus an index drop/OPTIMIZE maintenance runbook (non-replicated, per-instance). |
| Vulnerability Collection | [[vulnerability-collection.md]] | OSV + Alpine/Debian/Ubuntu OS-package vuln collection on a raw-diff + hash strategy; fixed_version "0" = not_affected; dpkg version compare; git-based incremental. |
| RHEL VEX Vulnerability Collection | [[rhel-vex-vuln-collection.md]] | Design-stage RHEL OS-package vulnerability collection based on the full 63,152-document CSAF/VEX corpus: CPE dictionary, vulnerability facts, document state, channel/module-aware matching, and document recomputation with row-diff application. Implementation and cutover remain incomplete. |
| Confluence Data-Part Onboarding | [[confluence-datapart-onboarding.md]] | DT-space onboarding tree for data-part newcomers (2026-08-28): hub 4226220048 + 8 numbered child pages under the user's personal page, with the page-id map and HTML/mermaid publishing notes. |
| Crawler Source Governance | [[crawler-source-governance.md]] | Source intake route from terms/license/API review to runtime rate limits, alternatives, written agreements, attribution, and an explicit separation between customer-operated collection and LabradorLabs redistribution. |
| ISMP / Monitoring SFR Data-Part Scope | [[ismp-sfr-data-part-scope.md]] | 2026-08-28 split of pasted 관제 SFR items against the collection/BTS stack, with ISMP year-2 overlap marked Assumption and a 28-question clarification list. |
| License Collection | [[license-collection.md]] | License DB-ization (2021) → OSADL compatibility DB (2023) → AI/LLM full-text license analysis V3 (2025), replacing the prior analysis service while retaining the LLM API as an explicit dependency. |
| Labrador Platform | [[labrador-platform.md]] | Four-repo k8s/Airflow/scrapers/sqlmodel platform; sqlmodel queue refactor to single ON DUPLICATE KEY UPDATE UPSERT; Bitbucket+Claude AI PR review. |
| Library 누락 개선 (repo별) | [[library-missing-improvements.md]] | 2026-06~07 라이브러리 크롤러 누락 개선을 repo별 표로 정리 — 근본원인(transient 완료마킹·feed-ahead·escape 누락 등) + 크롤러 수정 + 백필. |
| Library 누락 전수감사 | [[library-missing-product-audit.md]] | 8개 생태계 product 단위 누락 정량화(audit-only) — DB≠registry 실검증 원칙, 통합 결과표. |
| Infra: DB Monitoring & Incident | [[infra-db-monitoring.md]] | gatherdb01 memory/swap incident (buffer pool 89% of container limit; disable innodb_dedicated_server) + ELK DB-update monitoring with JIRA/KakaoWork alerts. |
| Infra: Forgejo Git Mirror | [[forgejo-git-mirror.md]] | Internal-only 2-server Forgejo mirror (labGit1/labGit2, INFR-393): Plan A sharding via shared md5-parity rule (seeder=broker=nginx), seeded from TB_COMP_FILE_VALID_V6 (~107k repos, ~4.8TB), on-demand mirror broker with refresh-on-request, weekly baseline sync. |
| Humanize Korean Skill | [[humanize-korean-skill.md]] | Korean AI-tell detection/rewriting skill (~/.claude/skills/humanize-korean): fast monolith + strict 5-agent pipeline, taxonomy SSOT v2.0.1, promotion/rejection governance for new pattern candidates. |
| Home Server & DevOps Homelab | [[home-server.md]] | Self-hosted Nextcloud/NPM + rclone Google Drive mount; Mac Mini k3s + ArgoCD GitOps homelab with Gemini AI PR review. |
| Hermes + Discord LLM Wiki Operations System | [[hermes-discord-llm-wiki-system.md]] | Personal AI operations workflow that uses Discord as the control surface, Hermes Agent as the execution layer, and llm-wiki as a git-backed durable knowledge base. |
| System Associates Procurement-Notice Triage | [[system-associates-procurement-triage.md]] | Nara Market notice collection, keyword and LLM triage, Discord alerts, and Hermes follow-up Q&A used by a sales/marketing team; non-developer self-service configuration remains unverified. |
| Personal Portfolio Platform | [[personal-portfolio-platform.md]] | Personal hyunwook.tech monorepo for portfolio, tech blog, wiki, docs, Go API, and Docker-backed local infrastructure. |
| Vibekits | [[vibekits.md]] | Personal multilingual random tools and casual browser games built with React/Vite, Canvas/Three.js, Supabase-ready ranking/auth, ads, and sharing primitives. |
| Personal AI Notetaker | [[personal-ai-notetaker.md]] | Personal Tiro-like AI notetaker plan for macOS/iOS/Android: Flutter + Drift/SQLite, local-first audio, whisper.cpp batch transcription first, optional macOS ScreenCaptureKit helper. |
| YouTube Shorts Automation Platform | [[youtube-shorts-automation-platform.md]] | Personal control-plane/worker-plane automation MVP for Japan-target YouTube Shorts channels with FastAPI, Streamlit, n8n, Python Worker, mock docs/upload, and AI quality packs. |