database-schema-design

Database schema design for PostgreSQL/MySQL with normalization, relationships, constraints. Use for new databases, schema reviews, migrations, or encountering missing PKs/FKs, wrong data types, premature denormalization, EAV anti-pattern.

1.07x

Quality

92%

Does it follow best practices?

Impact

98%

1.07x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Evaluation results

100%

12%

E-commerce Platform Database Schema

Primary keys, foreign keys, indexes, and audit columns

Criteria

Without context

With context

UUID primary keys

100%

All tables have PKs

100%

Foreign keys explicit

100%

ON DELETE/UPDATE specified

100%

FK indexes present

100%

Audit columns all tables

50%

100%

TIMESTAMPTZ for timestamps

100%

NOT NULL on required fields

100%

Bounded VARCHAR lengths

100%

DECIMAL for money

100%

CHECK for enum status

100%

CHECK for numeric ranges

100%

95%

-3%

Content Publishing Platform Schema

Normalization, EAV avoidance, naming conventions, soft deletes

Criteria

Without context

With context

No EAV pattern

100%

JSONB for metadata

100%

70%

GIN index on JSONB

100%

Soft delete pattern

100%

Junction table for M:M

100%

Table naming convention

100%

FK column naming

100%

Index naming convention

100%

Normalized 3NF

100%

NOT NULL required fields

100%

Bounded VARCHAR

100%

TIMESTAMPTZ audit columns

75%

No polymorphic comments

100%

11%

Project Management SaaS Schema

Cascade rules, updated_at triggers, BOOLEAN types, data types

Criteria

Without context

With context

CASCADE on org delete

100%

CASCADE on project delete

100%

SET NULL on user delete

100%

updated_at trigger function

100%

Trigger on each table

100%

BOOLEAN for flags

100%

CHECK on status enum

70%

100%

CHECK on priority range

100%

UUID primary keys

100%

FK indexes present

100%

TIMESTAMPTZ audit columns

100%

NOT NULL on required fields

100%

Repository: secondsky/claude-skills
Commit: 90d6bd7

Evaluated: about 1 month ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

E-commerce Platform Database Schema Content Publishing Platform Schema Project Management SaaS Schema

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.