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 | 加密敏感欄位、稽核存取 |