Database schema designer
Skill bg-szy/TOP-SKILLS/skills/claude-skills/database-schema-designer
全球最大的 Claude Code 技能聚合库 · 收录 3900+ 来自 12+ 来源的技能,提供在线搜索与趋势分析看板 / The world's largest Claude Code skill aggregation hub — 3900+ skills from 12+ sources with online search and trend dashboard
npx -y skills add bg-szy/TOP-SKILLS --skill database-schema-designerAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
2 things to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
- 4 stars4 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Design optimized database schemas for SQL and NoSQL databases including tables, relationships, indexes, and constraints. Creates ERD diagrams, migration scripts, and data modeling best practices. Use when users need database design, schema optimization, or data architecture planning.
SKILL.md
2.1 KB, 352 tokens by cl100k_base, as published. Nobody here has run it
Database Schema Designer
Design optimized, scalable database schemas with proper relationships and indexes.
Contents
references/schema-templates.md— SQL/NoSQL schema templates, ASCII ERD, and migration script templates.references/output-format.md— labeled section structure for the final deliverable.references/best-practices.md— naming, data types, indexes, relationships, SQL/NoSQL design rules, and the output quality checklist.
Workflow
-
Gather requirements. Determine the database engine (PostgreSQL, MySQL, MongoDB, etc.), application domain, main entities, most common queries, expected data volume and growth, performance requirements, and any compliance constraints.
-
Design the schema. Apply the engine-appropriate rules in
references/best-practices.md(SQL Database Design or NoSQL Database Design). -
Generate the complete schema. Produce CREATE TABLE statements or collection documents using the templates in
references/schema-templates.md. -
Create the entity relationship diagram in text format following the ERD template in
references/schema-templates.md. -
Provide migration scripts with both up and down (rollback) paths, per the migration template in
references/schema-templates.md. -
Format the complete output using the labeled sections in
references/output-format.md. -
Verify the result against the output quality checklist in
references/best-practices.md.
Example Triggers
- "Design a database schema for an e-commerce platform"
- "Create SQL tables for a blog system"
- "Help me design a MongoDB schema for a social network"
- "Optimize this database schema for performance"
- "Generate migration scripts for my schema"
Generate production-ready, optimized database schemas that scale.