skills.rest
jeremylongshore
jeremylongshoreCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

designing-database-schemas

Design normalized relational database schemas and generate Mermaid ERDs with SQL CREATE statements.

2.6k|379|Updated Oct 10, 2025
Search Tags:#design#SQL#schema design#database#data modeling#ERD#normalization
One-click install
npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill designing-database-schemas
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: designing-database-schemas
Source: https://github.com/jeremylongshore/claude-code-plugins-plus/tree/main/plugins/database/database-schema-designer/skills/database-schema-designer
Command: npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill designing-database-schemas

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill assists in designing robust and normalized database schemas. It provides guidance on normalization principles, helps map relationships between entities, generates ERD diagrams for visualization, and ultimately produces SQL CREATE statements, saving design time and ensuring data integrity.

Core Features & Use Cases

  • Normalization Guidance: Apply 1NF through BCNF principles for efficient schema design.
  • ERD Generation: Visualize database relationships with Mermaid diagrams.
  • SQL CREATE Statements: Automatically generate SQL for tables, columns, indexes, and constraints.
  • Use Case: Design a new database schema for a social media application, including users, posts, and comments, complete with relationships and SQL creation scripts.

Quick Start

User request: "Design a database schema for a social media application with users, posts, and comments."

The skill will:

  1. Design tables for users, posts, and comments, including relevant attributes (e.g., user_id, username, post_id, content, timestamp).
  2. Define relationships between the tables (e.g., one user can have many posts, one post can have many comments).
  3. Generate an ERD diagram visualizing the relationships.
  4. Create SQL CREATE TABLE statements for the tables, including primary keys, foreign keys, and indexes.

Frequently Asked Questions about designing-database-schemas

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

FAQPage Schema
How do I design a database schema that follows normalization principles?▼

Database schema normalization applies 1NF through BCNF principles to eliminate data redundancy and ensure data integrity. This Skill guides you through each normalization level, helping you structure tables and relationships efficiently for relational databases.

Can I generate SQL CREATE statements automatically from a database design?▼

Yes. After designing your schema with relationship mapping and entity definitions, this Skill automatically generates SQL CREATE TABLE statements with primary keys, foreign keys, indexes, and constraints ready for execution.

How do I visualize database relationships and entity mappings?▼

Entity-relationship diagrams (ERDs) visualize database structure by mapping one-to-one, one-to-many, and many-to-many relationships between tables. This Skill generates Mermaid ERD diagrams that clarify your schema design before implementation.

What's the best way to map relationships between database entities?▼

Relationship mapping defines how entities connect: one-to-one (single record pairs), one-to-many (one record links to multiple others), and many-to-many (multiple records on both sides). This Skill applies these patterns explicitly to structure your schema correctly.

Do I need to normalize existing database schemas?▼

Normalizing existing schemas reduces redundancy, improves query performance, and prevents data anomalies. This Skill applies normalization guidance to reshape your current schema toward 1NF through BCNF, identifying and resolving structural inefficiencies.

How do I handle many-to-many relationships in database design?▼

Many-to-many relationships require a junction table that links two entities with separate foreign keys. This Skill recognizes these patterns and generates the appropriate table structure, primary keys, and constraints for proper SQL implementation.

Related Skills

Explore More Software Engineering Skills→
KaranKathur06KaranKathur06

data-modeling

Design data models with ERD notation, data dictionaries, and conceptual/logical/physical artifacts.

Community
Intermediate
xloxn69xloxn69
7

sql-schema-generator

Generate SQL schemas, migrations, and table definitions with DDL constraints.

Community
Basic
seb1nseb1n
147

database-schema-design

Design normalized relational database schemas and generate SQL DDL scripts.

Community
Intermediate
flowkraftflowkraft
75

Data Modelling Skill

Design relational database schemas with universal data model patterns and SQL DDL.

Community
Advanced