Schema Design
Database schema design with normalization, relationships, constraints, and data integrity.
Install
/plugin marketplace add sethdford/claude-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add sethdford/claude-skills --skill schema-designgit 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-designPersonal 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)
Details
- Skill name
schema-design- Repository
- sethdford/claude-skills
- 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
A B Test Design
48sethdford/claude-skills
Design rigorous A/B tests with hypotheses, variants, metrics, and sample size calculations.
A B Test Design Pm
48sethdford/claude-skills
Analytics and experimentation skill for product managers.
Abuse Case Design
48sethdford/claude-skills
Design abuse cases (negative use cases) showing how attackers misuse system features. Use when identifying attacks that exploit intended functionality or business logic flaws.
Schema Evolution
48sethdford/claude-skills
Manage database schema changes while maintaining backwards compatibility. Handle migrations, versioning, and zero-downtime deployments. Use when evolving data models in production systems.
Data Partitioning
48sethdford/claude-skills
Design partitioning and sharding strategies for data at scale. Use when single database hits throughput or storage limits.
Storage Selection
48sethdford/claude-skills
Choose the right database technology for specific workloads. Evaluate relational, NoSQL, data warehouses, and search engines. Use when selecting storage systems for new features or optimizing existing ones.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.