database-schema-designer

Database Schema Designer - Auto-activating skill for Backend Development. Triggers on: database schema designer, database schema designer Part of the Backend Development skill category.

1.00x

Quality

Does it follow best practices?

Impact

100%

1.00x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./planned-skills/generated/06-backend-dev/database-schema-designer/SKILL.md

Evaluation results

100%

Online Bookstore Database Schema

Production-ready schema with step-by-step guidance

Criteria

Without context

With context

Runnable DDL

100%

Primary keys defined

100%

Foreign key constraints

100%

Indexes present

100%

Appropriate data types

100%

Normalization applied

100%

Step-by-step design document

100%

Rationale included

100%

Validation checklist produced

100%

Validation items checked

100%

NOT NULL constraints

100%

Enum or check constraints

100%

Without context: $0.4975 · 2m 27s · 21 turns · 21 in / 8,878 out tokens

With context: $0.5876 · 2m 38s · 28 turns · 60 in / 9,426 out tokens

100%

Microservices Data Layer for a Logistics Platform

Microservices database patterns and production configs

Criteria

Without context

With context

Three separate schemas

100%

Runnable DDL files

100%

Constraints in schemas

100%

Migration strategy documented

100%

Example migration file

100%

Rollback approach covered

100%

Data duplication strategy

100%

Step-by-step structure

100%

Production readiness notes

100%

Indexes in schemas

100%

No cross-service foreign keys

100%

Without context: $0.5799 · 2m 42s · 25 turns · 26 in / 10,381 out tokens

With context: $0.7709 · 3m 21s · 29 turns · 285 in / 13,959 out tokens

100%

Real-Time Notification System Backend

Caching and messaging schema design with validation

Criteria

Without context

With context

Runnable DDL

100%

Notification and delivery tables

100%

DB constraints and indexes

100%

Redis key naming convention

100%

Redis data structures specified

100%

TTL strategy defined

100%

Cache invalidation approach

100%

Message JSON schema defined

100%

Consumer processing notes

100%

Validation report present

100%

Tradeoffs documented

100%

Step-by-step structure

100%

Without context: $0.8667 · 5m 19s · 26 turns · 27 in / 17,918 out tokens

With context: $0.7475 · 4m 3s · 29 turns · 368 in / 13,462 out tokens

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: 994edc4

Evaluated: 18 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Online Bookstore Database Schema Microservices Data Layer for a Logistics Platform Real-Time Notification System Backend

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.