skills.rest
gaebalai
gaebalaiCOMMUNITY
Explore all skills by this author →
Website𝕏@gaebalaiGitHub

database-schema-designer

Generate ER diagrams, normalization analysis, and DDL scripts for database schemas.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides AI-assisted database schema design, ER diagram generation, normalization analysis, DDL creation, and performance optimization to shorten design cycles and improve data integrity.

Core Features & Use Cases

  • ER Diagram generation: Create clear entity-relationship diagrams for relational schemas and NoSQL data models.
  • Normalization & DDL: Assess normalization levels and generate DDL scripts with constraints, indexes, and metadata.
  • Migration & Performance planning: Propose safe migration steps and indexing strategies to support scalable systems.
  • Use Case: When starting a new project, model core entities, relationships, and constraints, then produce ready-to-run schema artifacts.

Quick Start

Provide a project brief describing domain, target DBMS, key entities, and performance goals to receive a complete schema outline, ER diagram, and DDL.

Frequently Asked Questions about database-schema-designer

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

FAQPage Schema
How do I generate an ER diagram for my database schema?▼

Generate an ER diagram by providing a project brief with your domain, target DBMS, and key entities. The skill outputs clear mermaid ER diagrams for relational schemas and NoSQL data models to visualize relationships.

What's the best way to normalize an existing database schema and create DDL scripts?▼

Normalize a database schema and create DDL scripts by submitting your entities for assessment. The skill evaluates normalization levels and generates ready-to-run DDL scripts complete with constraints, indexes, and metadata.

Can I plan database migrations and indexing strategies for scalable systems?▼

Plan database migrations and indexing strategies by defining your performance goals and target DBMS. The skill proposes safe migration steps and indexing strategies to support scalable real-world data systems.

Does schema design support both relational and NoSQL data modeling?▼

Schema design supports both relational and NoSQL data modeling. You can model core entities and relationships for either database type, then produce ready-to-run schema artifacts including ER diagrams and DDL.

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

Normalization analysis is needed when designing a new database schema to improve data integrity. The skill assesses normalization levels to shorten design cycles and ensure secure data handling within your target DBMS.

Related Skills

Explore More Software Engineering Skills→
VictorSmaniottoVictorSmaniotto

modelagem-dominio-9box

Model domain entities and value objects for Laravel performance management.

Community
Intermediate
DatTran26DatTran26

ck:databases

Translate business requirements into scalable MongoDB and PostgreSQL schema designs.

Community
Advanced
pedronauckpedronauck
567

postgres-drizzle

Define PostgreSQL schemas, queries, and migrations with Drizzle ORM.

Community
Intermediate
joyz0joyz0

data-migration-design

Manage versioned database schema changes with transactional execution and automated rollback.

Community
Advanced