database
Installation
SKILL.md
Database Assistant | 資料庫助手
Guide database design, migration planning, and query optimization.
引導資料庫設計、遷移規劃和查詢最佳化。
Core Principles | 核心原則
| Principle | Description | 說明 |
|---|---|---|
| Normalization | Eliminate redundancy (3NF minimum) | 消除冗餘（至少 3NF） |
| Referential Integrity | Enforce FK constraints | 強制外鍵約束 |
| Index Strategy | Index query patterns, not all columns | 依查詢模式建立索引 |
| Migration Safety | Always reversible, zero-downtime | 可逆、零停機 |
| Data Protection | Encrypt sensitive fields, audit access | 加密敏感欄位、稽核存取 |
Schema Design Checklist | Schema 設計檢查清單
- Primary keys defined (prefer UUID or BIGINT) | 主鍵已定義
Related skills
More from asiaostrich/universal-dev-standards
bdd
[UDS] Guide through Behavior-Driven Development workflow
24atdd
[UDS] Guide through Acceptance Test-Driven Development workflow
23methodology
[UDS] Manage development methodology workflow
21reverse
[UDS] System archeology — reverse engineer code across Logic, Data, and Runtime dimensions
20docgen
[UDS] Generate usage documentation from project sources
20sdd
[UDS] Create or review specification documents for Spec-Driven Development
19