Database Design Hardened

👤 snazar-faberlens 📦 v1.0.0 ⭐ 4.3 ⬇️ 627 下载
💻 开发编程 免费

📖 技能介绍


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

💬 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

更多技能请访问小葱技能站7w4.net。

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."

🤖 AI 评测

整体质量中等偏上,核心功能实用,支持多种数据库。主要优点是功能覆盖全面、用法简单直接;不足是使用指南不够完善,部分说明重复赘余,实际使用时的技巧和注意事项分享较少。对于需要快速生成数据库脚本的用户来说是一个可用的工具,但深度和细节还有提升空间。

📊 多维度评分

适应性3.7
规范性4.2
有效性4.5
可靠性4.2
可信度4.9

📁 包含文件 (6 个)

📄 SAFETY.md 18 KB
📄 SKILL.md 2.1 KB
📄 _meta.json 143 B
📄 scripts/db.sh 19.7 KB
📄 scripts/script.sh 2.3 KB
📄 tips.md 49 B