Schema Design

Use when designing or reviewing relational schema changes, initialization SQL, migrations, privileges, seed data, constraints, indexes, or schema tests; preserve authority boundaries and verify the real database contract.

9 stars 3 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add sandbaseai/workbuddy-skill --skill schema-design
Manual install
git clone --depth 1 https://github.com/sandbaseai/workbuddy-skill.git /tmp/workbuddy-skill
mkdir -p ~/.claude/skills
cp -r /tmp/workbuddy-skill/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

# Database Schema Design

Use this skill for schema changes, DDL, migrations, indexes, privileges, seed data, or database contract review. The committed schema and migration sources define the current shape; they are not a license to redesign unrelated tables. A work order, issue, or explicit change scope defines what may change. Read existing bindings, neighboring SQL, naming rules, migration order, roles, and tests first.

## Establish authority and boundaries

Record the target database, allowed files/objects, current version or initialization order, owners, application roles, writers, readers, affected services, data classification, and rollback plan. Separate facts from proposed behavior. Never invent principals, grants, seed identities, schema strata, or production data. Do not change multiple databases or rename/split service accounts without explicit authority for each.

Keep foundational invariants independent of later application layers. Separate structural definitions, audit observation, notifications, connection bootstrap, views/grants, mutation writers, and approved seeds according to the repository's declared strata. Do not introduce a new stratum, duplicate an object in two strata, or use conditional SQL to hide an ordering error.

## Design for database-enforced integrity
Read the full skill on GitHub

Details

Skill name
schema-design
Path
skills/schema-design/SKILL.md
License
MIT
Repo updated
8 September 2026

FAQ

What does the Schema Design skill do?

Use when designing or reviewing relational schema changes, initialization SQL, migrations, privileges, seed data, constraints, indexes, or schema tests; preserve authority boundaries and verify the real database contract.

How do I install the Schema Design skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add sandbaseai/workbuddy-skill --skill schema-design. 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 sandbaseai/workbuddy-skill, which has 9 GitHub stars and 3 forks.

Related skills

Access Control Security Best Practices

9

sandbaseai/workbuddy-skill

Design, review, implement, and verify least-privilege access controls across users, services, tenants, resources, and administrative workflows.

Security

Accessibility Review

9

sandbaseai/workbuddy-skill

Use when reviewing a web interface or interaction for semantic, keyboard, focus, screen-reader, ARIA, and contrast accessibility risks.

Frontend & Design

Acquire Codebase Knowledge

9

sandbaseai/workbuddy-skill

Use when the user asks to map, document, or onboard into an existing codebase and needs evidence-backed architecture, structure, conventions, integrations, testing, and concerns documentation.

Software Development

SQL Code Review

9

sandbaseai/workbuddy-skill

Use when reviewing SQL across MySQL, PostgreSQL, SQL Server, or Oracle for injection risk, access control, correctness, performance, maintainability, and migration safety.

Databases

Project Bindings

9

sandbaseai/workbuddy-skill

Use when authoring or changing a repository's project-specific bindings such as module ownership, workspace roots, database locations, gate keys, namespaces, palettes, registry contracts, or release values; keep facts in one authoritative declaration.

Databases

SQL Optimization

9

sandbaseai/workbuddy-skill

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.

Databases

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