skills.rest
sitharaj88
sitharaj88COMMUNITY
Explore all skills by this author →
GitHub

db-design

Generate database schemas with ER diagrams, normalization, and migration plans.

1|Updated Mar 2, 2026
Search Tags:#database design#SQL#NoSQL#schema#migration#ER diagram
One-click install
npx skills add https://github.com/sitharaj88/claude-skills --skill db-design-sitharaj88
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-design
Source: https://github.com/sitharaj88/claude-skills/tree/main/skills/db-design
Command: npx skills add https://github.com/sitharaj88/claude-skills --skill db-design-sitharaj88

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps users design robust and efficient database schemas from requirements, including visual ER diagrams, normalization analysis, and migration strategies.

Core Features & Use Cases

  • Schema Generation: Creates detailed database schemas based on user-defined entities, relationships, and access patterns.
  • ER Diagramming: Generates visual Entity-Relationship diagrams using Mermaid syntax for clear representation.
  • Normalization & Optimization: Applies normalization rules and suggests denormalization strategies for performance.
  • Migration Planning: Outlines step-by-step migration plans for existing or new schemas.
  • Database Recommendation: Suggests appropriate database engines (SQL/NoSQL) based on project needs.
  • Use Case: Design a PostgreSQL schema for a social media application, including user profiles, posts, comments, and relationships, complete with an ER diagram and migration steps.

Quick Start

Use the db-design skill to generate a PostgreSQL schema for a blog with entities for users, posts, and comments, including an ER diagram.

Frequently Asked Questions about db-design

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

FAQPage Schema
How do I design a database schema from application requirements?▼

Designing a database schema from requirements involves generating detailed entity definitions, relationship mappings, and access pattern analysis. This skill automates schema generation by creating normalized data models, ER diagrams, and migration strategies from your project specifications.

Can I generate ER diagrams for both PostgreSQL and MongoDB?▼

Yes, you can generate ER diagrams for PostgreSQL, MySQL, MongoDB, and DynamoDB. The schema design process creates visual Entity-Relationship diagrams using Mermaid syntax to represent relational and NoSQL database structures clearly.

What's the best way to plan database migrations for a new schema?▼

Planning database migrations requires outlining step-by-step migration strategies for schema changes. This skill generates comprehensive migration plans that facilitate efficient data modeling and transitioning for both existing schemas and new application development.

When do I need normalization analysis for my database design?▼

Normalization analysis is needed when structuring relational databases to reduce data redundancy and improve integrity. This skill applies normalization rules during schema generation and suggests denormalization strategies to optimize query performance.

Does this database design approach support NoSQL access pattern mapping?▼

Yes, this database design approach supports NoSQL access pattern mapping. It generates schemas based on user-defined entities and access patterns, suggesting appropriate database engines like DynamoDB or MongoDB based on your specific project needs.

Related Skills

Explore More Software Engineering Skills→
popup-studio-aipopup-studio-ai
589

phase-1-schema

Define project terminology and data models to eliminate ambiguity.

Official
Intermediate
dhruvinrsonidhruvinrsoni

database-design

Design relational and NoSQL database schemas with migrations and indexes.

Community
Advanced
Eigo-Mt-FujiEigo-Mt-Fuji

database-schema-designer

Design database schemas, ER diagrams, and DDL for relational and NoSQL databases.

Community
Advanced
OKHP3OKHP3
2

okhp3-mermaid-data

Generate entity-relationship and class diagrams in Mermaid syntax for database schemas.

Community
Intermediate