skills.rest
Eigo-Mt-Fuji
Eigo-Mt-FujiCOMMUNITY
Explore all skills by this author →
Website𝕏@EikichiEngineerGitHub

database-schema-designer

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

Updated Jan 10, 2026
Search Tags:#indexing#normalization#data-modeling#ER-diagram#database-schema#migration-planning#DDL-generation
One-click install
npx skills add https://github.com/Eigo-Mt-Fuji/portfolio-2026 --skill database-schema-designer-eigo-mt-fuji
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/Eigo-Mt-Fuji/portfolio-2026/tree/main/.claude/skills/database-schema-designer
Command: npx skills add https://github.com/Eigo-Mt-Fuji/portfolio-2026 --skill database-schema-designer-eigo-mt-fuji

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Copilot agent for database schema design, ER diagrams, normalization, DDL generation, and performance optimization. It helps automate complex modeling tasks, reduces design time, and enforces best practices across relational and NoSQL design considerations.

Core Features & Use Cases

  • Data Modeling: Create ER diagrams and logical/physical models for RDBMS (PostgreSQL/MySQL/SQL Server) and NoSQL (MongoDB/DynamoDB).
  • Normalization & Integrity: Apply 1NF–3NF/BCNF, define keys, constraints, and triggers to maintain data quality.
  • DDL & Migration: Generate CREATE TABLE, indexes, constraints, and plan zero-downtime migrations with rollback strategies.
  • Performance & Scalability: Design indexing strategies, partitioning plans, and caching considerations; plan sharding or replication if needed.

Quick Start

Provide a general instruction: Describe domain requirements or attach a sample dataset; I will propose a complete schema, including ER diagrams 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 design a database schema for my application?▼

Design a database schema by defining your data entities, relationships, and applying normalization rules (1NF–3NF/BCNF). This skill generates complete ER diagrams, DDL statements, and constraints for PostgreSQL, MySQL, SQL Server, MongoDB, and DynamoDB based on your domain requirements.

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

Normalization eliminates redundancy and enforces data integrity through structured stages. This skill applies 1NF–3NF/BCNF rules, defines primary and foreign keys, adds constraints, and generates triggers to maintain consistency across your schema.

How do I create a zero-downtime database migration?▼

Plan zero-downtime migrations by staging schema changes, defining rollback strategies, and sequencing DDL operations. This skill generates migration scripts with indexing strategies and constraint definitions that minimize application downtime.

Can I optimize database performance through indexing and partitioning?▼

Yes. This skill designs indexing strategies, partitioning plans, and caching considerations for both relational and NoSQL databases. It generates optimized schemas that support scaling through sharding, replication, and query-specific index placement.

Does this work with both relational and NoSQL databases?▼

Yes. This skill supports data modeling and schema design for relational systems (PostgreSQL, MySQL, SQL Server) and NoSQL platforms (MongoDB, DynamoDB), with normalization and performance optimization tailored to each database type.

How do I generate DDL and handle schema governance at scale?▼

Generate CREATE TABLE statements, indexes, and constraints from logical models while maintaining governance standards. This skill automates DDL creation and scaling architecture design for multi-database environments.

Related Skills

Explore More Software Engineering Skills→
wojonswojons
4

database-optimization

Analyze and optimize database queries, indexes, and schema configurations.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

comparing-database-schemas

Compare PostgreSQL or MySQL schemas and generate transaction-safe migration scripts.

Community
Advanced
JeffallanJeffallan
10.9k

database-optimizer

Diagnose slow queries and optimize indexes for PostgreSQL and MySQL.

Community
Advanced
ref-docsref-docs

database-schema-designer

Design database schemas with ER diagrams, normalization, and DDL generation.

Official
Advanced