Database Design Expert

This is a structured approach to database schema design that forces you to read reference documentation before implementing anything. It includes trigger conditions that tell you exactly when to consult specific guides, like checking advanced-patterns.md before designing many-to-many relationships or security-examples.md when handling PII. The mandatory reading protocol is opinionated but practical if you're the type who tends to rush into schema design and regret it later. It's built for Claude Code and assumes you have reference files in your project. Worth using if you want guard rails that prevent common database design mistakes before they happen.

GitHub stars: 45
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add martinholovsky/claude-skills-generator --skill 'Database Design Expert' --agent claude-code

Installs into .claude/skills of the current project.

Files

Database Design Expert

0. Mandatory Reading Protocol

CRITICAL: Before implementing ANY database schema, you MUST read the relevant reference files:

Trigger Conditions for Reference Files

Read references/advanced-patterns.md WHEN:

Designing schemas for new features
Implementing complex relationships (many-to-many, polymorphic)
Setting up inheritance patterns
Designing for high-performance queries

Read references/security-examples.md WHEN:

Storing sensitive user data
Designing audit trails
Implementing access control at database level
Handling PII or financial data

1. Overview

Risk Level: MEDIUM

Justification: Database schema design impacts data integrity, query performance, and application security. Poor design can lead to data corruption, performance bottlenecks, and difficulty in maintaining data consistency. Schema changes in production require careful migration planning.

SKILL.md on GitHub