data-model-designer

Design PostgreSQL relational schemas with explicit constraints and migration planning.

Updated Aug 23, 2026

Search Tags:#schema design #database #postgresql #migration #data modeling #ER diagram

Ready to run

npx skills add https://github.com/FScoward/senju --skill data-model-designer-fscoward

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: data-model-designer
Source: https://github.com/FScoward/senju/tree/main/skills/data-model-designer
Command: npx skills add https://github.com/FScoward/senju --skill data-model-designer-fscoward

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the process of designing accurate and scalable PostgreSQL data models, reducing errors and saving development time.

Core Features & Use Cases

Conceptual and Logical Design: Utilizes T-shaped ER techniques and Expand & Contract patterns to create reliable database schemas.
Schema Evolution Planning: Guides safe, zero-downtime migration strategies for existing databases.
Use Case: A data engineer models an e-commerce platform's database, ensuring proper normalization, referential integrity, and migration plan for schema updates.

Quick Start

Generate entity-relationship diagrams and SQL DDL scripts from your data requirements for immediate use in PostgreSQL.

Frequently Asked Questions about data-model-designer

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

FAQPage Schema

How do I design a scalable PostgreSQL schema for a new application?▼

To design a scalable PostgreSQL schema, you should utilize T-shaped ER techniques to ensure proper normalization and explicitly define referential integrity. This approach reduces data modeling errors while creating reliable relational database structures.

What is the best way to plan zero-downtime database migrations in PostgreSQL?▼

The best way to plan zero-downtime database migrations is by applying Expand and Contract patterns. This schema evolution strategy guides safe updates to existing databases without disrupting service availability.

How do I generate SQL DDL scripts and ER diagrams from data requirements?▼

You can generate SQL DDL scripts and ER diagrams from your data requirements by defining conceptual and logical models first. This produces immediate, executable PostgreSQL scripts and visual diagrams for your schema.

Why should I explicitly define schema constraints and relationships in PostgreSQL?▼

Explicitly defining schema constraints and relationships in PostgreSQL is necessary to maintain strict data integrity. This practice ensures correctness and safety by preventing invalid data entries during both new development and migrations.

Can I use T-shaped ER techniques for modeling an e-commerce platform database?▼

Yes, you can use T-shaped ER techniques for modeling an e-commerce platform database. This method ensures proper normalization and referential integrity, providing a robust relational schema for complex data structures.

When do I need to use Expand and Contract patterns for database schema evolution?▼

You need to use Expand and Contract patterns when evolving existing database schemas safely. This approach is required for planning zero-downtime migrations, ensuring that schema updates do not break dependent applications.