skills.rest
OneWave-AI
OneWave-AIOFFICIAL
Explore all skills by this author →
GitHub

database-schema-designer

Design optimized SQL and NoSQL database schemas with ERDs and migration scripts.

245|39|Updated Oct 22, 2025
Search Tags:#database design#SQL#NoSQL#schema#data modeling#backend development#ERD#migration scripts
One-click install
npx skills add https://github.com/OneWave-AI/claude-skills --skill database-schema-designer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/OneWave-AI/claude-skills/tree/main/database-schema-designer
Command: npx skills add https://github.com/OneWave-AI/claude-skills --skill database-schema-designer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the complex process of designing and optimizing database schemas, providing developers with production-ready SQL or NoSQL structures, ERD diagrams, and migration scripts. It saves significant development time and ensures robust data architecture.

Core Features & Use Cases

  • Schema Generation: Design tables, relationships, indexes, and constraints for both SQL (e.g., PostgreSQL, MySQL) and NoSQL (e.g., MongoDB) databases.
  • ERD Diagrams: Generate clear, text-based Entity Relationship Diagrams for visual representation of data models.
  • Migration Scripts: Create CREATE TABLE and ALTER TABLE scripts with rollback capabilities for seamless database evolution.
  • Use Case: A backend developer needs to design a database schema for a new e-commerce platform. This Skill generates optimized SQL tables, defines relationships, adds appropriate indexes, and provides migration scripts, accelerating development.

Quick Start

Example: Design a database schema

"Design a PostgreSQL database schema for a blog platform with users, posts, comments, and tags. Include relationships and indexes."

Frequently Asked Questions about database-schema-designer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a database schema for SQL and NoSQL databases?▼

Design database schemas by defining tables, relationships, indexes, and constraints for SQL databases like PostgreSQL and MySQL, or document structures with embedding vs. referencing for NoSQL databases like MongoDB. The Skill generates optimized schemas with primary/foreign keys, normalization rules, and soft delete patterns.

What should I include in a normalized database schema?▼

Normalized schemas should include primary keys, foreign keys, indexes on frequently queried columns, constraints, created_at/updated_at timestamp fields, and soft delete implementations. The Skill applies 3NF normalization or justified denormalization based on query patterns and performance requirements.

How do I generate migration scripts for database changes?▼

Migration scripts are generated as CREATE TABLE and ALTER TABLE statements with rollback capabilities, enabling safe database evolution. The Skill produces scripts ready for deployment across schema versions.

Can I use this to design schemas for both relational and document databases?▼

Yes. The Skill handles SQL databases (PostgreSQL, MySQL) with relational modeling and NoSQL databases (MongoDB) with document-oriented design, choosing embedding or referencing strategies based on query patterns and data access needs.

What does an Entity Relationship Diagram show in database design?▼

ERD diagrams visually represent entities, their attributes, and relationships between tables or collections. The Skill generates text-based ERDs to clarify data model structure before implementation.

When should I denormalize a database schema?▼

Denormalize when query performance analysis shows that normalized structures create bottlenecks, and when the benefits of read optimization outweigh data redundancy costs. The Skill justifies denormalization decisions based on specific query patterns and access frequency.

Related Skills

Explore More Software Engineering Skills→
mrlynnmrlynn
8

document-model-advisor

Analyze MongoDB data relationships and access patterns to inform embed or reference decisions.

Community
Advanced
inbharataiinbharatai
22

db-schema-designer

Design normalized relational database schemas with ERDs, indexes, constraints, and migration scripts.

Community
Intermediate
yashvinthanyashvinthan

Backend Models Standards

Enforce naming, data types, constraints, relationships, and validation for backend database models.

Community
Intermediate
SempriniSemprini
1

schema-import

Convert database schemas and ETL logic into draft MD-DDL domain models.

Community
Advanced