WIKI

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.

경로ai/wiki/projects/index.md

카테고리Index

태그#ai-review #airflow #cicd #crawler #infra #kubernetes #monitoring #mysql #portfolio #project #projects #security #wiki

# 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
BTS (Binlog Transfer System CDC)	[[bts.md]]	Move customer DB sync from file-level binlog shipping to event-level CDC; Maxwell blocked by MySQL 8.4 ZSTD binlog compression → custom Python `pymysqlreplication`+`zstandard` collector.
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.
License Collection	[[license-collection.md]]	License DB-ization (2021) → OSADL compatibility DB (2023) → AI/LLM full-text license analysis V3 (2025) removing external-service 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.
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.
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.
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.
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.

연결 문서

ProjectBTS — Binlog Transfer System Quality Improvement (CDC)

AI Summary Purpose Capture durable knowledge about improving BTS Binlog Transfer System , the mechanism that ships database changes from the company's master DB to customer on premise DBs, and the move from file based Binlog Shipping toward

binlogbtscdcdata-pipeline

ProjectDistribution DB — Instance Separation & Index Optimization

AI Summary Purpose Capture durable knowledge about the Distribution DB DIST DB , its instance separation work, and the index cleanup/optimization performed to keep binlog shipping to customer on premise servers healthy. Key points DIST DB i

binlogdata-pipelinedistributioninfra

ProjectVulnerability Collection (OSV + OS Package Trackers)

AI Summary Purpose Capture durable design knowledge for collecting open source and OS package vulnerabilities from multiple upstream sources OSV, Alpine secdb, Debian Security Tracker, Ubuntu CVE Tracker and normalizing them into the compan

airflowcicdcollectioncrawler

ProjectLicense Collection & Analysis

AI Summary Purpose Capture durable knowledge about the open source license data pipeline license compatibility data, license DB ization, and the AI based license analysis redesign. Key points Three evolutionary stages over time 1. 2021 Lice

ai-reviewairflowcicdcollection

ProjectLabrador Platform (k8s, data-platform, scrapers, sqlmodel)

AI Summary Purpose Capture durable knowledge about the Labrador data platform how its four repos interact, the labrador sqlmodel queue refactor the most reusable engineering result , and the AI automated PR review system. Key points Four re

ai-agentai-reviewairflowcicd

ProjectInfra — GatheringDB Incident & DB Update Monitoring

AI Summary Purpose Capture two durable infra learnings the gatherdb01 memory exhaustion/swap incident and its root cause + fix , and the ELK based DB Update Monitoring system that watches binlog shipping and alerts via JIRA/KakaoWork. Key p

binlogcicdgrafanainfra

ProjectHome Server & Personal DevOps Homelab

AI Summary Purpose Capture durable knowledge about the personal home server self hosted Nextcloud, Google Drive mount and the Mac Mini DevOps homelab k3s + ArgoCD + GitHub Actions + AI PR review . Key points Self hosting stack Docker Nextcl

ai-agenthomeinfrakubernetes

ProjectHermes + Discord LLM Wiki Operations System

AI Summary Purpose Capture durable knowledge about the user's personal AI operations workflow that uses Hermes Agent, Discord, and llm wiki as a git backed knowledge base. Key points Discord is used as the conversational control surface for

agentai-reviewdiscorddocumentation

ProjectPersonal Portfolio Platform (`hyunwook.tech`)

AI Summary Purpose Capture durable knowledge about hyunwook.tech , the personal portfolio, tech blog, wiki, docs, and API monorepo under ~/hw/project . Key points The repository README describes hyunwook.tech as a personal portfolio + wiki

ai-reviewcrawlerinfrapersonal

ProjectVibekits

AI Summary Purpose Capture durable knowledge about vibekits , a personal random tools and casual browser games project under ~/hw/project . Key points The README describes Vibekits as random decision tools and casual browser games built wit

ai-reviewcrawlerinfraportfolio

ProjectYouTube Shorts Automation Platform (`yt-pipeline-n8n`)

AI Summary Purpose Capture durable knowledge about yt pipeline n8n , a personal YouTube Shorts automation platform MVP under ~/hw/project . Key points The README describes a Mock MVP for operating multiple Japan target YouTube Shorts channe

ai-agentai-reviewautomationcicd