database

name	database
scope	universal
description	Guide database design, migration, and query optimization. Use when: schema design, migration planning, query optimization, index strategy. Keywords: database, schema, migration, SQL, index, query.
allowed-tools	Read, Grep, Glob
argument-hint	[schema or migration to review | 要審查的 schema 或遷移]

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