mcpbeat

Database Schema Designer

onewave-ai/database-schema-designer

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.

2k tokens
context cost
the whole folder, loaded on every use
4
files
instructions only
0
copies elsewhere
how many repositories repackaged it
235
stars on the repo
on the repository, not the skill itself

Install

one command, takes just this skill from the repository 
npx skills add https://github.com/OneWave-AI/claude-skills --skill database-schema-designer

The instruction itself

4 sections, as written by the author

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.

How to use it

Copy the folder

Take onewave-ai/database-schema-designer from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.