skills.rest
imudak
imudakCOMMUNITY
Explore all skills by this author →
GitHub

database-schema-designer

Design database schemas and generate Mermaid ER diagrams with SQL DDL scripts.

Updated Aug 23, 2026
Search Tags:#database design#SQL#schema design#PostgreSQL#normalization#ER diagram#DDL generation
One-click install
npx skills add https://github.com/imudak/claudemd-gen --skill database-schema-designer-imudak
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/imudak/claudemd-gen/tree/main/.claude/skills/database-schema-designer
Command: npx skills add https://github.com/imudak/claudemd-gen --skill database-schema-designer-imudak

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill automates the complex and time-consuming process of designing robust database schemas, generating essential documentation like ER diagrams and DDL, and ensuring adherence to best practices for normalization and performance.

Core Features & Use Cases

  • Database Schema Design: Conceptual, logical, and physical data modeling.
  • ER Diagram Generation: Creates visual representations of database structures using Mermaid syntax.
  • Normalization: Applies normalization rules (1NF, 2NF, 3NF, BCNF) to ensure data integrity and reduce redundancy.
  • DDL Generation: Produces SQL CREATE TABLE and CREATE INDEX statements for various RDBMS.
  • Performance Optimization: Provides recommendations for indexing, partitioning, and query optimization.
  • Use Case: A startup needs to design a new PostgreSQL database for their e-commerce platform. This Skill can guide them through defining tables, relationships, constraints, and generate the initial SQL schema, ensuring it's scalable and maintainable.

Quick Start

Use the database-schema-designer skill to design a PostgreSQL schema for an e-commerce platform with users, products, and orders.

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 from raw requirements?▼

Database schema design analyzes raw data modeling requirements to produce conceptual, logical, and physical data models. It evaluates normalization, data integrity, performance, and scalability to generate an optimal database structure.

How do I generate an ER diagram for PostgreSQL tables?▼

Generating an ER diagram for PostgreSQL tables produces visual representations of database structures using Mermaid syntax. It maps relationships and constraints automatically based on the analyzed data modeling requirements.

Can I generate SQL DDL scripts for MySQL and PostgreSQL?▼

Yes, DDL generation produces SQL CREATE TABLE and CREATE INDEX statements for RDBMS like PostgreSQL and MySQL. It outputs executable scripts enforcing constraints, normalization, and physical data model definitions.

What's the best way to normalize a database schema to BCNF?▼

Normalizing a database schema to BCNF applies normalization rules (1NF, 2NF, 3NF, BCNF) to ensure data integrity and reduce redundancy. It restructures tables and relationships to eliminate functional dependencies.

Does this database design process support Japanese documentation output?▼

Yes, the database design process supports both English and Japanese documentation output. It generates ER diagrams, DDL scripts, and schema optimization recommendations natively in either language.

How do I optimize schema performance for a scalable e-commerce database?▼

Optimizing schema performance for a scalable e-commerce database provides recommendations for indexing, partitioning, and query optimization. It analyzes physical data models to ensure maintainability under high transaction loads.

Related Skills

Explore More Software Engineering Skills→
abranjithabranjith

build-data-model

Design normalized relational data models from plain-language domain requirements.

Community
Advanced
tinkermonkeytinkermonkey
1

LAYER_08_DATA_STORE

Define physical database schemas with SQL DDL for PostgreSQL, MySQL, and SQLite.

Community
Intermediate
wecode-aiwecode-ai
705

mermaid-diagram

Validate Mermaid syntax and render diagrams from plain-language prompts.

Official
Basic
roanbrasilroanbrasil
5

nosql-patterns

Select NoSQL databases and design schemas for access patterns.

Community
Advanced