菜单
Safely modify the Drizzle schema and create a migration for FixNow Postgres. Validates the change against docs/database-schema.md, runs drizzle-kit generate then migrate, and updates the schema doc. Use when user says "thêm field X vào users", "đổi enum status", "add Review table", "tạo migration".
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Bootstrap the FixNow Next.js project from scratch — install Next.js, Tailwind, Drizzle ORM, NextAuth, shadcn/ui, and set up the base folder structure. Use this skill ONCE when starting a fresh project, or to verify all base dependencies are present. Triggers when user says "khởi tạo dự án", "init FixNow", "scaffold project", "setup base".
Run a responsive QA pass on a FixNow page or component across desktop, tablet, and mobile Chrome viewports. Verifies no horizontal scroll, touch targets, Vietnamese diacritics, layout shifts, and Lighthouse mobile score. Use when user says "kiem tra responsive", "test trang X", "check tren mobile/tablet", "qa giao dien".
Scaffold a Next.js App Router API route (route.ts) for FixNow with zod validation, auth check via NextAuth, Drizzle ORM access, and proper error handling. Use when user says "tạo API endpoint X", "scaffold POST /api/appointments", "thêm route handler GET /api/parts".
Scaffold a new Next.js App Router page following FixNow conventions — correct route group, Server vs Client component split, layout integration, mobile-first Tailwind. Use when user says "tạo trang X", "scaffold page /pricing", "thêm route /track".
Manage db/seed.ts for FixNow with realistic Vietnamese fixture data for services, parts, admin user, and sample appointments using Drizzle. Use when user says "seed data", "tạo dữ liệu mẫu", "reset demo data", "thêm linh kiện vào DB".
Add or update shadcn/ui components for FixNow by running the official shadcn CLI. Never copy component source from the shadcn-ui/ui repo by hand. Use this when the user says "them component button", "cai shadcn select", "shadcn table", "init shadcn", or whenever a required component is missing from components/ui/.
| name | db-migrate |
| description | Safely modify the Drizzle schema and create a migration for FixNow Postgres. Validates the change against docs/database-schema.md, runs drizzle-kit generate then migrate, and updates the schema doc. Use when user says "thêm field X vào users", "đổi enum status", "add Review table", "tạo migration". |
Thay đổi schema Drizzle + tạo migration an toàn.
db/schema.ts hiện tại + docs/database-schema.md.Nếu rủi ro cao → STOP, xin xác nhận từ user.
db/schema.tsTuân thủ:
id, createdAt, updatedAt.relations() nếu có FK.npx drizzle-kit generate
File SQL xuất ở drizzle/<timestamp>_<auto_name>.sql. Đọc kỹ trước khi apply.
Kiểm tra:
CREATE TABLE đúng các column + type.ALTER TABLE ... ADD COLUMN có DEFAULT nếu NOT NULL.DROP COLUMN / DROP TABLE ngoài ý muốn.Nếu phát hiện rename bị nhầm thành drop+add → sửa file SQL tay thành ALTER TABLE ... RENAME COLUMN ....
npx drizzle-kit migrate
Hoặc test trước trên DB scratch:
# Tạo tạm DB test
# psql -c "CREATE DATABASE fixnow_test;"
# DATABASE_URL=postgresql://...fixnow_test npx drizzle-kit migrate
Sửa docs/database-schema.md:
npx tsc --noEmit
Schema thay đổi sẽ phản ánh ngay ở types.
Nếu table mới hoặc column NOT NULL mới → cập nhật db/seed.ts. Xem skill seed-fixtures.
ALTER TYPE ... ADD VALUE thủ công, không drop enum.Migration history phải immutable trong git. Cần đổi → tạo migration mới revert + apply lại.
docs/database-schema.md.drizzle-kit generate, không push (trừ prototype).migrate.npx tsc --noEmit pass.db/seed.ts đã update nếu cần.db/schema.ts + drizzle/<new>.sql + drizzle/meta/_journal.json.fixnow-drizzle-modeler.seed-fixtures để có data demo.