LEE-SANG-BOK/vkc-drizzle-schema-migration
cursor-plugin/viet-k-connect/skills/vkc-drizzle-schema-migration/SKILL.md
Standardize Drizzle schema/migration/seed workflow for Viet K-Connect. Use when adding or changing DB tables, especially DB-driven visa rulesets and document templates (no hardcoding). (키워드= 드리즐, DB 스키마, 마이그레이션, seed, schema.ts, migrations)
testing
Updated May 25, 2026
$ install --global
skillsauthnpx skillsauth add LEE-SANG-BOK/VKC-2- vkc-drizzle-schema-migrationInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 25, 2026, 2:00 AM14.2s1 file scanned
SKILL.md
- name:
- vkc-drizzle-schema-migration
- description:
- Standardize Drizzle schema/migration/seed workflow for Viet K-Connect. Use when adding or changing DB tables, especially DB-driven visa rulesets and document templates (no hardcoding). (키워드= 드리즐, DB 스키마, 마이그레이션, seed, schema.ts, migrations)
- short-description:
- Drizzle schema + migration workflow
VKC Drizzle Schema & Migration
When to use
- Adding/updating DB tables/enums/indexes
- Introducing DB-driven configuration (visa rulesets, doc templates, regulation snapshots)
Hard rules
- DB schema lives in
src/lib/db/schema.ts. - Migrations are generated/applied via
drizzle-kit(npm run db:generate,npm run db:migrate). - Visa rulesets and doc templates MUST be DB tables, not hardcoded TS objects.
- Coordinate ownership:
src/lib/db/schema.tsandsrc/lib/db/migrations/**should not be modified concurrently by multiple agents.
Workflow
- Update
src/lib/db/schema.ts
- Add table(s), enum(s), indexes.
- Prefer explicit indexes for
(userId, createdAt)where rate limits depend on time windows.
- Generate migration
npm run db:generate
- Apply migration locally (if DB configured)
npm run db:migrate
- Seed (if needed)
- Use
npm run db:seedor project seed scripts.
References
- Rules & examples:
.codex/skills/vkc-drizzle-schema-migration/references/drizzle-rules.md
Related Skills
LEE-SANG-BOK/vkc-wizardkit
development
VerifiedTrustedCommunity
Build step-based wizard UIs (step UI, fixed bottom CTA with safe-area, localStorage draft save, runtime validation, submit event logging). Use for visa assessment, doc generation, admin queue inputs. (키워드= 위저드, 단계형 폼, 멀티스텝, 하단 고정 CTA, draft 저장, 제출 로그)
SKILL.mdUpdated May 25, 2026
LEE-SANG-BOK/vkc-visa-assessment-engine
development
VerifiedTrustedCommunity
Design and implement the Viet K-Connect visa assessment engine (DB-driven ruleset JSON schema + versioning + effective dates). No hardcoded rules in code. Use for building /api/visa/assess and admin ruleset management. (키워드= 비자 평가, 룰셋, 규칙 엔진, DB-driven, 버전/적용일, /api/visa/assess)
SKILL.mdUpdated May 25, 2026
LEE-SANG-BOK/vkc-ux-audit
testing
VerifiedTrustedCommunity
Run a VKC UX expert audit (Nielsen-style heuristic review + mobile-first flow check) and produce a prioritized issue list with severity and fixes. (키워드= UX 감사, 휴리스틱, 모바일 QA, 접근성, 사용성)
SKILL.mdUpdated May 25, 2026
LEE-SANG-BOK/vkc-skill-router
data-ai
VerifiedTrustedCommunity
Route VKC tasks to the correct domain skill from manifest.json. Always start with guardrails, shared-memory-router, loop-supervisor; then pick one domain skill by path/task keywords. (키워드=skill router, manifest, domain skill, which skill)
SKILL.mdUpdated May 25, 2026