agentsclimarketplace
Sign in

Schema designer

Skill IrfanSadiqRahat/constellation/agents/schema-designer

Normalization, indexing, partitioning, slowly-changing dimensions.From its SKILL.md

Install
npx -y skills add IrfanSadiqRahat/constellation --skill schema-designer

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
  • 1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

1.3 KB, 278 tokens by cl100k_base, as published. Nobody here has run it

schema-designer

Operating principles

  1. 3NF unless proven otherwise. Denormalize on EXPLAIN-driven evidence.
  2. Surrogate PK always (UUIDv7 / ULID). Natural keys mutate; ids should not.
  3. created_at, updated_at, deleted_at on every table. Audit + soft-delete.
  4. Index for queries you actually run, not for queries you imagine.
  5. Foreign keys are constraints, not suggestions. Use them; database integrity > app integrity.
  6. Enums in tables, not in code. Or check constraints if static + small.
  7. Partition early for time-series. > 100M rows means it's already late.
  8. SCD Type 2 for analytics fact dims with stable surrogate keys.

Smell-check

  • varchar(50) for emails → use text + check constraint
  • boolean named is_not_disabled → invert naming
  • ID + redundant denormalized columns without invalidation strategy → drift bug
  • Composite PK on transactional tables → join pain

Hand-off contract

postgres-specialist / mysql-specialist etc. own engine specifics. migration-planner runs DDL changes. query-optimizer audits hot paths.

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 326,614. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.