database-schema-designer

Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.

1.07x

Quality

76%

Does it follow best practices?

Impact

89%

1.07x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./dist/plugins/database-schema-designer/skills/database-schema-designer/SKILL.md

Evaluation results

96%

Marketplace Database Schema

SQL schema design best practices

Criteria

Without context

With context

3NF normalization

100%

80%

DECIMAL for money

100%

FK constraints defined

100%

ON DELETE strategy

100%

FK indexes present

100%

Timestamp columns

70%

80%

Appropriate VARCHAR sizing

70%

100%

Many-to-many junction table

100%

NOT NULL on required fields

100%

Date/time as TIMESTAMP not string

100%

90%

22%

User Profile Schema Migration

Backward-compatible migration scripts

Criteria

Without context

With context

UP migration present

100%

DOWN migration present

50%

60%

File naming convention

100%

BEGIN/COMMIT transactions

60%

Nullable column first

100%

Backfill step present

30%

80%

Schema and data separated

80%

100%

FK index in migration

100%

Backward compatible order

100%

No irreversible operations

100%

81%

-8%

Query Performance Audit

Indexing strategy and query optimization

Criteria

Without context

With context

FK columns indexed

100%

WHERE columns indexed

100%

ORDER BY columns indexed

100%

Composite index column order

100%

70%

No over-indexing

100%

N+1 pattern identified

100%

JOIN recommended over N+1

100%

SELECT * avoided

100%

Index type rationale

30%

20%

Write impact acknowledged

60%

20%

Repository: softaworks/agent-toolkit
Commit: 3027f20

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

Table of Contents

Marketplace Database Schema User Profile Schema Migration Query Performance Audit

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.