資料庫設計

從實體關係與存取方式檢視 database schema。

Community · 社群來源 · 資料與分析

來源狀態

可用來源

原始名稱: database-schema-designer

原始作者: softaworks

這是第三方 Community Skill；2lus 收錄不代表已完整安全審計或保證安全。

資源類型

Skill

與類似 Skill 有什麼不同？

SQL 查詢最佳化
Database Design 設計實體關係、約束及 schema 演進；SQL Query Optimization 針對已量測的查詢瓶頸調整存取方式。

來源描述的能力

這些是來源描述的可能操作，不代表 2lus 已授予權限或已測試。

尚未列出能力，請審查原始來源。

這個 Skill 是什麼？

規劃資料完整性、型別與可演進的 schema。

可以做什麼？何時適合使用？

建模新功能資料表
審查約束與關聯
安排 schema migration

如何使用

提供資料庫引擎、實體與讀寫模式
檢查正規化、PK、FK、型別與約束
提出索引取捨與分階段 migration 草案

使用前你需要準備

去識別化資料與欄位說明
資料庫引擎或工作簿規格

你可以替換：

[database]、[table]

環境與相依需求

需要 schema、資料量與讀寫需求；語法須依指定引擎覆核。

使用範例與 Prompt

以下是 2lus 撰寫的示範需求；請替換為你有權處理的檔案與專案，不代表已執行或保證結果。

入門

為圖書借閱設計實體關係，說明 primary key、foreign key 與借閱狀態約束。

實務

Review 訂單 schema 的 normalization、金額型別、刪除關聯與索引成本；只輸出建議。

進階

規劃把單租戶表改成多租戶的 expand/backfill/contract migration，說明完整性、鎖定與無法逆轉的資料風險。

實用提醒

先描述業務不變條件，再決定 constraint 與資料表邊界。

限制與注意事項

來源範例不適用每種引擎；down migration 不一定能還原已刪資料。

安全注意事項

不要提供正式資料；DDL、回填與刪欄位須另行核准及備份。

使用與設定

此條目不提供已確認的通用安裝指令；請依官方文件與 Agent 版本操作。

支援平台

未確認特定 Agent 相容性

來源與授權

來源查核日期（非安全認證）: 2026-09-29

MIT

原始來源 ↗ 授權條款 ↗ 官方文件 ↗

Database Design

Review database schemas through relationships and access patterns.

Community · Community source · Data & Analysis

Source status

Active source

Original name: database-schema-designer

Original author: softaworks

This is a third-party community skill. Inclusion by 2lus is not a complete security audit or safety guarantee.

Resource type

Skill

How is this different from similar skills?

SQL Query Optimization
Database Design models relationships, constraints and schema evolution; SQL Query Optimization targets measured query bottlenecks.

Documented capabilities

These are operations described upstream, not permissions granted or tested by 2lus.

Capabilities not declared here; review the original source.

What is this skill?

Plan data integrity, types and schema evolution.

Use cases and when to use it

Model feature tables
Review constraints and relationships
Plan schema migrations

How to use it

Supply engine, entities and workloads
Inspect normalization, keys, types and constraints
Propose index tradeoffs and staged migration

What you need

Redacted data and column definitions
Database engine or workbook specification

You can replace:

[database], [table]

Environment and dependencies

Provide schema, scale and workload; review syntax for the selected engine.

Usage and prompt examples

These example requests were written by 2lus. Substitute files and projects you may use; examples are not executed results or guarantees.

Beginner

Model library lending entities with primary keys, foreign keys and loan-state constraints.

Practical

Review an order schema for normalization, monetary types, deletion behavior and index cost without executing DDL.

Advanced

Plan an expand/backfill/contract migration from single-tenant to multi-tenant tables, including integrity, locking and irreversible data risks.

Tips

Describe business invariants before choosing constraints.

Limitations

Examples are engine-dependent; down migrations cannot necessarily recover deleted data.

Security notes

Exclude production records; DDL, backfills and deletion require approval and backups.

Usage and setup

No verified universal installation command is provided for this entry. Follow the official documentation for your agent version.

Supported agents

Specific agent compatibility unknown

Sources and license

Source check date (not a safety certification): 2026-09-29

MIT

Original source ↗ License terms ↗ Documentation ↗

Related skills

Before using a third-party skill, review its source, permissions and executable content. Commands are for viewing and copying only; 2lus does not execute them.

2lus AI Skills Library provides curated educational guides. Third-party content, licenses and availability are governed by their original sources. Review permissions and executable content before use or installation.

資料庫設計