relational-schema-design

Designs and reviews relational table structures for PostgreSQL and MySQL, covering entity modeling, normalization to third normal form, primary and foreign keys, relationship patterns, column type selection, CHECK and UNIQUE constraints, audit timestamps, and soft deletes. Detects and repairs structural flaws such as keyless tables, unbounded strings, text-encoded dates, polymorphic references, circular foreign keys, and unjustified denormalization. Use when creating a new schema, writing a CREATE TABLE script or migration, or auditing existing DDL for design defects. Not for query performance tuning, replication or backup administration, NoSQL or document stores, or non-relational data modeling.

Version

v1.0.0

Size

17 KB

Updated

2026-10-06

Your client verifies the signature before reading. This explicit manual read is available on every plan. Free automatically loads five chosen skills; paid plans automatically load relevant skills across the library.