skills.rest
williamzujkowski
williamzujkowskiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

Database Schema Designer

Design normalized database schemas, ER diagrams, and migration plans from business requirements.

6|Updated Oct 25, 2025
Search Tags:#database#schema#migration#normalization#data-modeling#erd#ddl
One-click install
npx skills add https://github.com/williamzujkowski/cognitive-toolworks --skill database-schema-designer-williamzujkowski
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Schema Designer
Source: https://github.com/williamzujkowski/cognitive-toolworks/tree/main/skills/database-schema-designer
Command: npx skills add https://github.com/williamzujkowski/cognitive-toolworks --skill database-schema-designer-williamzujkowski

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designing robust, normalized database schemas is error-prone and time-consuming. This skill provides structured guidance to model entities, relationships, and constraints, generate ERDs, and prepare migration plans across multiple database engines.

Core Features & Use Cases

  • Entity-relationship modeling and normalization (1NF-3NF, BCNF)
  • Schema migration planning with rollback strategies
  • DDL generation and index design recommendations
  • Multi-database support (PostgreSQL, MySQL, MongoDB, DynamoDB)
  • Constraint modeling (FKs, unique constraints, checks)

Quick Start

Describe your business entities and requirements and the tool will generate an ERD, DDL, and a migration plan.

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 a normalized database schema from business requirements?▼

To generate a normalized database schema, provide your business entities and requirements to the tool. It models relationships, applies normalization up to BCNF, and outputs an ERD, DDL scripts, and a migration plan.

Can I generate DDL scripts and migration plans for PostgreSQL and MongoDB?▼

Yes, you can generate DDL scripts and migration plans for PostgreSQL, MySQL, MongoDB, and DynamoDB. The tool provides multi-database support, automatically adapting schema constraints and index designs for each specific engine.

What is the best way to plan a database schema migration with rollback procedures?▼

The best way to plan a database schema migration with rollback procedures is to generate a dedicated migration plan alongside your schema design. This plan includes structured rollback strategies to validate changes safely before implementation.

Does this tool support entity-relationship modeling for finance and analytics workloads?▼

Yes, entity-relationship modeling supports finance and analytics workloads. The tool designs normalized schemas across product, finance, and analytics domains, enabling developers to iterate schema designs quickly for various application needs.

How do I model foreign key constraints and unique checks in an ERD?▼

To model foreign key constraints and unique checks in an ERD, define your entity relationships during the design phase. The tool automatically generates constraint modeling, including foreign keys, unique constraints, and check conditions in the final DDL.

Related Skills

Explore More Software Engineering Skills→
AbdullahmohammadarefAbdullahmohammadaref

data-modeling

Document data structures using ERDs, data dictionaries, and structured modeling.

Community
Intermediate
hdtinh57hdtinh57
1

database

Design database schemas and migration plans with rollback guidance.

Community
Advanced
Aurora-AIAurora-AI
1

Elysian Integrator

Integrate AI agents with Postgres databases and orchestrate workflows via @start and @listen.

Community
Advanced
roanbrasilroanbrasil
5

nosql-patterns

Select NoSQL databases and design schemas for access patterns.

Community
Advanced