addyosmani / addyosmani/agent-skills
[skill-gap] Proposal: `database-and-schema-design` — schema design, migrations, indexing discipline
- 主要语言
- JavaScript
- 星标
- 93.8k
- 派生
- 10k
- 平均合并
- 3 天 15 小时
- 30 天内合并 PR
- 23
描述
I've been using agent-skills in a production project and hit what looks like the biggest remaining gap in the Build phase: there's `api-and-interface-design`, but nothing on schema design, data modeling, migration discipline, or indexing strategy. Almost every production app touches a database, and agents are notorious for writing sloppy migrations (irreversible changes, missing indexes on foreign keys, destructive column drops without expand/contract).
**Pre-flight checks done:**
- Catalog: no existing skill covers this. `api-and-interface-design` treats schema only as an input to API shape; `deprecation-and-migration` covers system/API deprecation strategy, not DB migration mechanics; `ci-cd-and-automation` runs migrations but doesn't teach writing them.
- Open PRs: no overlapping proposal.
- Issues: #378 asks to deepen the DB substance of `performance-optimization` — I'd draw the boundary as: modeling/schema/migrations in this skill, query tuning stays in performance-optimization, with cross-references instead of duplication.
**Proposed scope:** entity/relationship modeling and normalization trade-offs; migration discipline (reversible by default, expand/contract for destructive changes, rollback tested); indexing discipline (FKs, query-shape-driven, no speculative indexes); constraints as correctness tools.
**Verification gates:** migration runs both ways against realistic data; rollback tested; schema change reviewed against actual query patterns.
Happy to contribute the skill + eval cases as a PR if this direction sounds right.
贡献指南
评估
这个 Issue 还没有评估数据。