skills.rest
seb1n
seb1nCOMMUNITY
Explore all skills by this author →
GitHub

database-schema-design

Design normalized relational database schemas and generate SQL DDL scripts.

147|32|Updated Feb 11, 2026
Search Tags:#SQL#schema design#database#data modeling#normalization#DDL
One-click install
npx skills add https://github.com/seb1n/awesome-ai-agent-skills --skill database-schema-design-seb1n
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-design
Source: https://github.com/seb1n/awesome-ai-agent-skills/tree/main/database/database-schema-design
Command: npx skills add https://github.com/seb1n/awesome-ai-agent-skills --skill database-schema-design-seb1n

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill automates the creation of normalized relational database schemas, ensuring data integrity and efficient querying for any application.

Core Features & Use Cases

  • Requirement Analysis: Understands application data needs to define entities and attributes.
  • Normalization: Applies normalization up to 3NF to reduce redundancy and improve data consistency.
  • Constraint & Indexing: Defines necessary constraints (NOT NULL, UNIQUE, CHECK) and indexes for performance and integrity.
  • SQL DDL Generation: Produces executable SQL scripts for creating tables, relationships, and indexes.
  • Use Case: Design a PostgreSQL schema for a new e-commerce platform, including users, products, orders, and payment details, complete with foreign key constraints and indexes for fast lookups.

Quick Start

Use the database-schema-design skill to create a normalized schema for a blog application with tables for posts, users, and comments.

Frequently Asked Questions about database-schema-design

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

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

Database schema design solves data redundancy and consistency issues by analyzing application requirements to model entities, applying normalization up to 3NF, and defining constraints and indexes to ensure efficient querying and data integrity across relational databases.

How do I generate SQL DDL scripts with constraints and indexes for a new database?▼

Generating SQL DDL scripts involves modeling entities from your application domain, applying normalization up to 3NF to reduce redundancy, and defining necessary constraints like NOT NULL and UNIQUE alongside indexes to produce executable database creation scripts.

Does this database schema design approach apply normalization up to 3NF for any application domain?▼

Yes, this database schema design approach analyzes requirements for any application domain and applies normalization up to 3NF to reduce data redundancy, ensuring data consistency and efficient querying across your relational database schema.

What is the best way to model entities and define indexes for a PostgreSQL e-commerce schema?▼

The best way to model entities and define indexes for a PostgreSQL schema is to analyze domain requirements, apply normalization up to 3NF for tables like users and orders, and generate SQL DDL scripts with foreign key constraints and indexes for fast lookups.

Related Skills

Explore More Software Engineering Skills→
musujmusuj

phase-1-schema

Define project terminology, entities, relationships, and data structures.

Community
Intermediate
h4vzzh4vzz
33

database-schema-design

Design normalized relational database schemas and generate SQL DDL.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
tuyenhttuyenht

NoSQL Patterns

Provide expert patterns for optimizing MongoDB, Redis, and DynamoDB databases.

Community
Intermediate