schema-design

What problem does it solve?

This Skill solves the problem of creating robust, well-documented, and performant relational database schemas that are maintainable and scalable.

Core Features & Use Cases

• Database Schema Design: Guides users through designing normalized database schemas (up to 3NF).
• Relationship Modeling: Helps define one-to-one, one-to-many, and many-to-many relationships with proper cardinality.
• Index and Constraint Definition: Assists in creating appropriate indexes and integrity constraints (PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE, CHECK).
• ORM Adaptation: Facilitates translation of the schema design to specific ORM syntaxes (Prisma, Drizzle, SQLAlchemy, etc.).
• Documentation Generation: Ensures tables and columns are documented for clarity.
• Use Case: A user needs to design a new database for an e-commerce platform, including tables for users, products, orders, and payments, ensuring data integrity and efficient querying.

Quick Start

Use the schema-design skill to create a normalized database schema for an online store, including tables for products, customers, and orders.