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.
Install
npx skills add sandbaseai/workbuddy-skill --skill schema-designgit 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-designPersonal 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
Details
- Skill name
schema-design- Repository
- sandbaseai/workbuddy-skill
- 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
9sandbaseai/workbuddy-skill
Design, review, implement, and verify least-privilege access controls across users, services, tenants, resources, and administrative workflows.
Accessibility Review
9sandbaseai/workbuddy-skill
Use when reviewing a web interface or interaction for semantic, keyboard, focus, screen-reader, ARIA, and contrast accessibility risks.
Acquire Codebase Knowledge
9sandbaseai/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.
SQL Code Review
9sandbaseai/workbuddy-skill
Use when reviewing SQL across MySQL, PostgreSQL, SQL Server, or Oracle for injection risk, access control, correctness, performance, maintainability, and migration safety.
Project Bindings
9sandbaseai/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.
SQL Optimization
9sandbaseai/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.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.