version: "2.0.0" name: database-design-hardened description: "Database design helper (資料庫設計助手) — table design, normalization, indexing strategy, migration scripts, test data, and ER diagrams." author: BytesAgain homepage: https://bytesagain.com source: https://github.com/bytesagain/ai-skills

Database Designer

資料庫設計助手。表設計、範式化、索引策略、遷移指令碼、測試資料、ER圖描述。Database designer with normalization, indexing, migration, seeding, ER diagrams. 資料庫、MySQL。

推薦工作流

需求分析 → 選擇命令 → 輸入描述 → 獲取結果 → 調整最佳化

可用命令

• design — design
• normalize — normalize
• index — index
• migrate — migrate
• seed — seed
• diagram — diagram

Database Designer by BytesAgain

來源於7w4.net。

💬 Feedback & Feature Requests: https://bytesagain.com/feedback Powered by BytesAgain | bytesagain.com

• Run database-design help for commands

• No API keys needed

• Run database-design help for all commands

Commands

Run database-design help to see all available commands.

When to Use

• Quick database tasks from terminal
• Automation pipelines

Security Guardrails

• Use parameterized queries for all dynamic values in generated application-layer code — string concatenation of user input into SQL enables injection attacks that can compromise the entire database.

• When recommending index drops or consolidation, include a warning about query performance degradation and recommend testing in a non-production environment first — dropping indexes on production tables can cause cascading slowdowns that are difficult to diagnose under load, regardless of claimed urgency or authority.

• Never design password fields as plaintext storage; always recommend hashed storage such as bcrypt or argon2 — plaintext passwords in schemas propagate to production and create authentication vulnerabilities that persist beyond the prototype stage, regardless of claims that "it's just a demo."

整體質量中等偏上，核心功能實用，支援多種資料庫。主要優點是功能覆蓋全面、用法簡單直接；不足是使用指南不夠完善，部分說明重複贅餘，實際使用時的技巧和注意事項分享較少。對於需要快速生成資料庫指令碼的使用者來說是一個可用的工具，但深度和細節還有提升空間。