tai-ch0802/database-design
i18n/zh-TW/database-design/SKILL.md
資料庫設計原則與決策。Schema 設計、索引策略、ORM 選擇、無伺服器資料庫。
$ install --global
skillsauthnpx skillsauth add tai-ch0802/skills-bundle database-designInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 20, 2026, 4:36 AM16.7s8 files scanned
SKILL.md
- name:
- database-design
- description:
- 資料庫設計原則與決策。Schema 設計、索引策略、ORM 選擇、無伺服器資料庫。
- allowed-tools:
- Read, Write, Edit, Glob, Grep
資料庫設計
學習思考方式，而非複製 SQL 模式。
🎯 選擇性閱讀規則
僅閱讀與請求相關的檔案！ 查看內容地圖，找到你需要的。
| 檔案 | 描述 | 何時閱讀 |
|------|------|----------|
| database-selection.md | PostgreSQL vs Neon vs Turso vs SQLite | 選擇資料庫 |
| orm-selection.md | Drizzle vs Prisma vs Kysely | 選擇 ORM |
| schema-design.md | 正規化、PK、關聯 | 設計 schema |
| indexing.md | 索引類型、複合索引 | 效能調優 |
| optimization.md | N+1、EXPLAIN ANALYZE | 查詢最佳化 |
| migrations.md | 安全遷移、無伺服器 DB | Schema 變更 |
⚠️ 核心原則
- 不明確時詢問使用者資料庫偏好
- 根據情境選擇資料庫/ORM
- 不要什麼都預設 PostgreSQL
決策檢查清單
設計 schema 前：
- [ ] 詢問使用者資料庫偏好了嗎？
- [ ] 為此情境選擇了資料庫？
- [ ] 考慮了部署環境？
- [ ] 規劃了索引策略？
- [ ] 定義了關聯類型？
反模式
❌ 簡單應用預設 PostgreSQL（SQLite 可能就夠了） ❌ 跳過索引 ❌ 生產環境使用 SELECT * ❌ 結構化資料更好時卻儲存 JSON ❌ 忽略 N+1 查詢
Related Skills
tai-ch0802/testing-mastery
development
VerifiedTrustedCommunity
Unified testing skill — TDD workflow, unit/integration patterns, E2E/Playwright strategies. Replaces tdd-workflow + testing-patterns + webapp-testing.
2SKILL.mdUpdated May 5, 2026
tai-ch0802/skill-vetter
testing
VerifiedTrustedCommunity
Security-first skill vetting for AI agents. Use before installing any skill from ClawdHub, GitHub, or other sources. Checks for red flags, permission scope, and suspicious patterns.
2SKILL.mdUpdated May 5, 2026
tai-ch0802/sdd
development
VerifiedTrustedCommunity
Spec-Driven Development (SDD): A structured workflow (Requirement -> Analysis -> Implementation) enforcing explicit documentation before coding.
2SKILL.mdUpdated May 5, 2026
tai-ch0802/sa
development
VerifiedTrustedCommunity
Methodologies for System Analysis (SA), focusing on technical architecture, data flow modeling, and API design.
2SKILL.mdUpdated May 5, 2026