addyosmani / addyosmani/agent-skills

[skill-gap] Proposal: `database-and-schema-design` — schema design, migrations, indexing discipline

オープン
#485 コメント 0 件 リアクション 0 件 担当者 0 名 GitHub で見る
主要言語
JavaScript
スター
93.8k
フォーク
10k
平均マージ
3日 15時間
マージ済み PR(30日)
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 はまだ評価されていません。

新しい issue をメールで受け取る

初心者向けの GitHub issue を短くまとめたダイジェスト。