Schema Design

Database schema design with normalization, relationships, constraints, and data integrity.

48 stars 10 forksDatabases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add sethdford/claude-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add sethdford/claude-skills --skill schema-design
Manual install
git clone --depth 1 https://github.com/sethdford/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/engineer/database-engineering/skills/schema-design ~/.claude/skills/schema-design

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Schema Design

Designing schemas that are correct, performant, and maintainable.

## Context

You are designing a database schema. Plan for data integrity and query patterns.

## Domain Context

- **Normalization**: 1NF, 2NF, 3NF; eliminate anomalies
- **Keys**: Primary keys, foreign keys, unique constraints
- **Types**: Choose appropriate column types; int vs bigint matters
- **Constraints**: NOT NULL, UNIQUE, CHECK enforce data integrity
- **Indexes**: Think about query patterns upfront

## Instructions

1. **Identify Entities**: What nouns? User, Order, Product?
2. **Identify Relationships**: One-to-many, many-to-many?
3. **Normalize**: 3NF typical; reduce duplication
4. **Keys**: Primary key on each table; foreign keys for relationships
5. **Types**: int for IDs, text for strings, jsonb for semi-structured
6. **Constraints**: Enforce data integrity at database level
7. **Indexes**: Plan indexes for common queries

## Anti-Patterns

- No primary keys; can't uniquely identify rows
- Storing arrays/lists in columns; use junction tables
- Text columns for numbers; use appropriate types
- No foreign keys; data integrity is application's problem
- Too much normalization; separate tables hurt performance
- No constraints; garbage data gets inserted

## Further Reading

- C.J. Date, _An Introduction to Database Systems_
- PostgreSQL schema design documentation
- Star schema (data warehouse design)
Read the full skill on GitHub

Details

Skill name
schema-design
Path
engineer/database-engineering/skills/schema-design/SKILL.md
License
MIT
Repo updated
11 March 2026

FAQ

What does the Schema Design skill do?

Database schema design with normalization, relationships, constraints, and data integrity.

How do I install the Schema Design skill?

Claude Code plugin: /plugin marketplace add sethdford/claude-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Schema Design popular?

It lives in sethdford/claude-skills, which has 48 GitHub stars and 10 forks.

Related skills

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.