skills.rest
JayRHa
JayRHaCOMMUNITY
Explore all skills by this author →
Website𝕏@jannik_reinhardGitHub

sql-schema-designer

Converts fuzzy domain requirements into normalized relational database schemas with DDL and ER models.

3|2|Updated Jun 9, 2026
Search Tags:#design#postgresql#normalization#database-schema#ddl#er-model
One-click install
npx skills add https://github.com/JayRHa/AgentSkills --skill sql-schema-designer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-schema-designer
Source: https://github.com/JayRHa/AgentSkills/tree/main/sql-schema-designer
Command: npx skills add https://github.com/JayRHa/AgentSkills --skill sql-schema-designer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designs normalized relational database schemas with primary/foreign keys, constraints, indexes, and deliberate denormalization, producing engine-aware DDL and an ER model. Use this skill when the user asks to design a database schema, model entities and relationships, normalize tables, fix update/insert/delete anomalies, choose data types and keys, add constraints or indexes, write CREATE TABLE DDL, or review/refactor an existing schema for PostgreSQL, MySQL, SQLite, or SQL Server.

Core Features & Use Cases

  • Normalize requirements into 3NF/BCNF schemas with keys, constraints, and indexes.
  • Generate engine-aware DDL (PostgreSQL, MySQL, SQLite, SQL Server) plus a complete ER model.
  • Support evaluation, refactoring, and documentation for data models in production environments.

Quick Start

Provide domain entities, relationships, and engine details, and I will output a ready-to-run schema and documentation.

Frequently Asked Questions about sql-schema-designer

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

FAQPage Schema
How do I design a normalized database schema from fuzzy requirements?▼

Designing a normalized database schema from fuzzy requirements involves converting domain entities into 3NF/BCNF relational models with primary/foreign keys, constraints, and indexes to generate ready-to-run DDL.

Can I generate CREATE TABLE DDL for PostgreSQL, MySQL, SQLite, and SQL Server?▼

Yes, you can generate engine-aware CREATE TABLE DDL for PostgreSQL, MySQL, SQLite, and SQL Server, ensuring syntax and data types match your specific database platform.

What is the best way to fix update, insert, and delete anomalies in an existing schema?▼

Fixing update, insert, and delete anomalies requires refactoring the existing schema into normalized 3NF/BCNF forms, deliberately selecting keys and constraints to eliminate data redundancy.

How do I model entity relationships and add referential actions to a database design?▼

Modeling entity relationships and adding referential actions involves creating an ER model with explicit foreign keys and defining cascading actions to maintain referential integrity across tables.

Does database normalization to 3NF or BCNF require specific prerequisite data?▼

Database normalization to 3NF or BCNF requires providing domain entities, their relationships, and engine details to accurately output a normalized schema with appropriate constraints and indexing.

When should I apply deliberate denormalization during relational schema design?▼

Deliberate denormalization should be applied during relational schema design when optimizing for read performance, requiring a documented data model that justifies the trade-off against update anomalies.

Related Skills

Explore More Software Engineering Skills→
SSiertsemaSSiertsema

conceptual-data-modeling

Define domain entities, relationships, and business rules in plain language.

Community
Intermediate
tinkermonkeytinkermonkey
1

LAYER_08_DATA_STORE

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

Community
Intermediate
jeremylongshorejeremylongshore
2.6k

generating-database-seed-data

Generate SQL or JavaScript seed scripts with Faker-based realistic data.

Community
Intermediate
FindMalekFindMalek
9

database-schema-designer

Design normalized SQL and NoSQL schemas with keys, constraints, and migration templates.

Community
Advanced