addyosmani / addyosmani/agent-skills

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

Đang mở
#485 0 bình luận 0 reaction 0 người được giao Xem trên GitHub
Ngôn ngữ chính
JavaScript
Star
93.8k
Fork
10k
Merge trung bình
3 ngày 15 giờ
Pull request đã merge (30 ngày)
23

Mô tả

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.

Hướng dẫn đóng góp

Mở hướng dẫn đóng góp

Đánh giá

Issue này chưa được đánh giá.

Nhận issue mới trong hộp thư của bạn

Bản tóm tắt ngắn những issue GitHub phù hợp với người mới.