Stats
Actions
Tags
Guides database schema design, migration planning, and query optimization. Includes normalization checklists, index strategy reference, and a five-step migration workflow. Useful for any SQL-based project.
How this skill is triggered — by the user, by Claude, or both
Slash command
/universal-dev-standards:database-assistant [schema or migration to review | 要審查的 schema 或遷移][schema or migration to review | 要審查的 schema 或遷移]This skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Guide database design, migration planning, and query optimization.
Guide database design, migration planning, and query optimization.
引導資料庫設計、遷移規劃和查詢最佳化。
| 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 | 加密敏感欄位、稽核存取 |
| Normal Form | Rule | 規則 |
|---|---|---|
| 1NF | Atomic values, no repeating groups | 原子值、無重複群組 |
| 2NF | 1NF + no partial dependencies | 1NF + 無部分相依 |
| 3NF | 2NF + no transitive dependencies | 2NF + 無遞移相依 |
| Denormalize | Only for proven read performance needs | 僅針對已證實的讀取效能需求 |
PLAN ──► WRITE ──► TEST ──► DEPLOY ──► VERIFY
Identify affected tables, estimate data volume, plan rollback strategy.
識別受影響的表、估算資料量、規劃回滾策略。
Write forward and rollback scripts. Use incremental, numbered migrations.
撰寫正向和回滾腳本。使用遞增編號的遷移。
Run on staging with production-like data. Verify data integrity post-migration.
在 staging 環境使用類生產資料執行。驗證遷移後資料完整性。
Apply during maintenance window or use online schema change tools.
在維護窗口執行，或使用線上 Schema 變更工具。
Check row counts, constraint validity, application functionality.
檢查列數、約束有效性、應用程式功能。
| Type | Use Case | 使用場景 |
|---|---|---|
| B-tree | Equality, range queries (default) | 等值、範圍查詢（預設） |
| Hash | Exact match only | 僅精確匹配 |
| GIN | Full-text search, JSONB | 全文搜尋、JSONB |
| Partial | Filtered subsets | 過濾子集 |
| Composite | Multi-column queries | 多欄位查詢 |
/database - Interactive database design guide | 互動式資料庫設計引導
/database schema - Review schema design | 審查 Schema 設計
/database --migration - Migration planning assistant | 遷移規劃助手
After /database completes, the AI assistant should suggest:
資料庫設計完成。建議下一步 / Database design complete. Suggested next steps:
- 執行
/security檢查資料保護措施 — Check data protection measures- 執行
/testing規劃資料庫測試策略 ⭐ Recommended / 推薦 — Plan database testing strategy- 執行
/checkin確認遷移符合提交規範 — Verify migrations meet check-in standards- 產生 API 端點 → 執行
/api-design— Generate API endpoints → Run/api-design
| Version | Date | Changes | 變更說明 |
|---|---|---|---|
| 1.0.0 | 2026-03-23 | Initial release | 初始版本 |
CC BY 4.0 — Documentation content
npx claudepluginhub asiaostrich/universal-dev-standards --plugin universal-dev-standardsDesigns database schemas, indexing strategies, query optimization, and migration patterns for SQL and NoSQL databases. Use for schema design, N+1 fixes, normalization, and performance tuning.
Provides best practices for database schema design, query optimization, migrations, indexing, N+1 avoidance, pagination, and transactions across PostgreSQL, MySQL, Oracle, SQLite. Use for schema design, queries, or migrations.
Guides SQL database design, query optimization, and migration safety. Use when writing queries, designing schemas, or planning zero-downtime migrations.